FOR THIS QUESTION, EXCEL *MUST* BE USED TO CALCULATE THE P-VALUE FOR CHI SQUARED! Here is a M iii) to the Khan Academy page on dihybrid crosses and gene mapping. Here is a lin iii) to the Math Bench web page on performing chi-squared tests. There are two alleles for the arrgene, A and a. There are also two alleles for beegene, B and b. The two genes are on a chromosome that is 15 micrometers in length, but it has yet to be determined if the two genes are linked. Below is data from a study to determine ifthe genes are linked, and if so, how far apart the genes are on the chromosome. Ah organism that is heterozygous for both the arr gene and the bee gene is crossed with an organism that is homozygous recessive for both genes. Using this information, it is possible to calculate the expected phenotypic ratio of the offspring of the two organisms. assuming the two genes are *NOT* linked. If the genes are linked. the offspring will not exhibit the expected phenotypic ratio. 1 . The arr and bee genes are independent of each other. 2. The arr and bee genes are linked. Above are the two hypotheses. Which of the two hypotheses is the null hypothesis? 0 Enter either 1 or 2 in the answer box The table below depicts the observed genotypic abundances of the offspring. Genotype Abundance Aa Bb 33 Aa bb 37 aa Bb 39 aa bb 31 What is your calculated value of chi squared? 0 Report your answer to FOUR decimal places 0 FURTHER CALCULATIONS SHOULD BE PERFORMED IN EXCEL ON THE UNROUNDED NUMBER What is the P-value determined using the formula =(1chisq.dist(x, df, TRUE)) in Excel, where x is the calculated value of chi squared, df is the degrees of freedom, and TRUE indicates a cumulative distribution function. 0 Report your answer to FOUR decimal places Using an alpha value of 0.05, do you fail to reject or reject the null hypothesis? 0 Enter either fail to reject, or reject. If the genes are linked, use the percent of offspring that experienced crossing over to determine the distance between the two genes in micrometers. If the genes are not linked, enter n/a in the box below micrometers - Report your answer in micrometers - Report your answer to four decimal places 0 Or enter n/a ifthe genes are not linked