FOR THIS QUESTION, EXCEL *MUST* BE USED TO CALCULATE THE P-VALUE FOR CHI SQUARED! Here is a link to the Khan Academy page on dihybrid crosses and gene mapping. Here is a link to the Math Bench web page on performing chi-squared tests. There are two alleles for the arr gene, A and a. There are also two alleles for bee gene, B and b. The two genes are on a chromosome that is 1.5 micrometers in length, but it has yet to be determined if the two genes are linked. Below is data from a study to determine if the genes are linked, and if so, how far apart the genes are on the chromosome. An 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? Enter either 1 or 2 in the answer box The table below depicts the observed genotypic abundances of the offspring. Genotype Aa Bb Aa bb aa Bb aa bb Abundance 33 37 39 31 What is your calculated value of chi squared? Report your answer to FOUR decimal places FURTHER CALCULATIONS SHOULD BE PERFORMED IN EXCEL ON THE UNROUNDED NUMBER What is the P-value determined using the formula -(1-chisq.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. Report your answer to FOUR decimal places Using an alpha value of 0.05, do you fail to reject or reject the null hypothesis? 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 •Or enter n/a if the genes are not linked
FOR THIS QUESTION, EXCEL *MUST* BE USED TO CALCULATE THE P-VALUE FOR CHI SQUARED! Here is a link to the Khan Academy page on dihybrid crosses and gene mapping. Here is a link to the Math Bench web page on performing chi-squared tests. There are two alleles for the arr gene, A and a. There are also two alleles for bee gene, B and b. The two genes are on a chromosome that is 1.5 micrometers in length, but it has yet to be determined if the two genes are linked. Below is data from a study to determine if the genes are linked, and if so, how far apart the genes are on the chromosome. An 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? Enter either 1 or 2 in the answer box The table below depicts the observed genotypic abundances of the offspring. Genotype Aa Bb Aa bb aa Bb aa bb Abundance 33 37 39 31 What is your calculated value of chi squared? Report your answer to FOUR decimal places FURTHER CALCULATIONS SHOULD BE PERFORMED IN EXCEL ON THE UNROUNDED NUMBER What is the P-value determined using the formula -(1-chisq.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. Report your answer to FOUR decimal places Using an alpha value of 0.05, do you fail to reject or reject the null hypothesis? 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 •Or enter n/a if the genes are not linked
Human Anatomy & Physiology (11th Edition)
11th Edition
ISBN:9780134580999
Author:Elaine N. Marieb, Katja N. Hoehn
Publisher:Elaine N. Marieb, Katja N. Hoehn
Chapter1: The Human Body: An Orientation
Section: Chapter Questions
Problem 1RQ: The correct sequence of levels forming the structural hierarchy is A. (a) organ, organ system,...
Related questions
Question
Transcribed Image Text:FOR THIS QUESTION, EXCEL *MUST* BE USED TO CALCULATE THE P-VALUE FOR CHI SQUARED!
Here is a link to the Khan Academy page on dihybrid crosses and gene mapping. Here is a link to the Math Bench web page on performing chi-squared tests.
There are two alleles for the arr gene, A and a. There are also two alleles for bee gene, B and b. The two genes are on a chromosome that is 1.5 micrometers in length, but it has yet to be
determined if the two genes are linked. Below is data from a study to determine if the genes are linked, and if so, how far apart the genes are on the chromosome.
An 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?
Enter either 1 or 2 in the answer box
The table below depicts the observed genotypic abundances of the offspring.
Genotype
Aa Bb
Aa bb
aa Bb
aa bb
Abundance
33
37
39
31
What is your calculated value of chi squared?
Report your answer to FOUR decimal places
FURTHER CALCULATIONS SHOULD BE PERFORMED IN EXCEL ON THE UNROUNDED NUMBER
What is the P-value determined using the formula -(1-chisq.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.
Report your answer to FOUR decimal places
Using an alpha value of 0.05, do you fail to reject or reject the null hypothesis?
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
•Or enter n/a if the genes are not linked
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Human Anatomy & Physiology (11th Edition)
Biology
ISBN:
9780134580999
Author:
Elaine N. Marieb, Katja N. Hoehn
Publisher:
PEARSON
Biology 2e
Biology
ISBN:
9781947172517
Author:
Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:
OpenStax
Anatomy & Physiology
Biology
ISBN:
9781259398629
Author:
McKinley, Michael P., O'loughlin, Valerie Dean, Bidle, Theresa Stouter
Publisher:
Mcgraw Hill Education,
Molecular Biology of the Cell (Sixth Edition)
Biology
ISBN:
9780815344322
Author:
Bruce Alberts, Alexander D. Johnson, Julian Lewis, David Morgan, Martin Raff, Keith Roberts, Peter Walter
Publisher:
W. W. Norton & Company
Laboratory Manual For Human Anatomy & Physiology
Biology
ISBN:
9781260159363
Author:
Martin, Terry R., Prentice-craver, Cynthia
Publisher:
McGraw-Hill Publishing Co.
Inquiry Into Life (16th Edition)
Biology
ISBN:
9781260231700
Author:
Sylvia S. Mader, Michael Windelspecht
Publisher:
McGraw Hill Education