QUESTION 3 FOR THIS QUESTION, EXCEL \"MUST BE USED TO CALCULATE THE P-VALUE FOR
ID: 204262 • Letter: Q
Question
QUESTION 3 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 aro two alleles for the arr gene, A and a·There 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 gone and the bee gone 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 hypothesis? 1 Enter either 1 or 2 in the answer box · The table below depicts the observed genotypic abundances of the offspring Genotype Abundance Aa Bb Aa bb aa Bb 40 30 40 35 Use the predicted and observed data to perform a chi-squared test to assess if two genes arr and bee are linked. Below is a video about how to perform the calculations in Excel Name: ChiSquaredinExcel (05:24) Duration: 05:24 Added: 20 Feb 2018 05:04 PM Added By: Joseph Battistelli tests chisquare Tags: chi square, dihybrid cross What is your calculated value of ch squared? Watch Media Click Save and Submit to sqve and submit. Click Save All Ansuwers to save all ansivers Save All AnwersExplanation / Answer
Null hypothesis: The observed values are not deviating from the ratio of 1:1:1:1.
Chisquare test:
Category
Aa Bb
Aa bb
aa Bb
aa bb
Total
Observed values (O)
40
30
40
35
145
Exptected Ratio (ER)
1
1
1
1
4
Exprected Values (E)
36.25
36.25
36.25
36.25
Deviation (O-E)
3.75
-6.25
3.75
-1.25
D^2
14.0625
39.0625
14.0625
1.5625
D^2/E
0.387931
1.077586
0.387931
0.043103
1.896552
X^2
1.896552
Degrees of freedom
4
-
1
3
Inference: The calculated chisquare value i.e. 1.896 is less than the table value i.e. 7.82 at 3 DF and 0.05 probability, hence the nullhypothesis is accepted.
Which of the two hypothesis is the null hypothesis:
The answer is 1
Calculated chisquare value : 1.896
Si8ng...the null hypothesis : accept.
n/a micrometers
Category
Aa Bb
Aa bb
aa Bb
aa bb
Total
Observed values (O)
40
30
40
35
145
Exptected Ratio (ER)
1
1
1
1
4
Exprected Values (E)
36.25
36.25
36.25
36.25
Deviation (O-E)
3.75
-6.25
3.75
-1.25
D^2
14.0625
39.0625
14.0625
1.5625
D^2/E
0.387931
1.077586
0.387931
0.043103
1.896552
X^2
1.896552
Degrees of freedom
4
-
1
3
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.