I need help answering the following question step by step in Excel: A plant spec

Question

I need help answering the following question step by step in Excel:

A plant specialist is looking at dominant and non dominant features regarding the blending of two plants. He is expecting that out of this blending there will come 4 variations of hybrids and that the frequency of them will be according to the Mendelian ratio 9:3:3:1 (or 56,25%; 18,75%; 18,75%; 6,25%). The results from the experiment showed however that 860 plants were in the first variation, 350 in the second variation, 300 in the third variation and 90 in the forth variation. If we have 95% confidence level. Is it possible to say that the frequency is according to the Mendelian ratio?

I have the correct answers from the teacher, they are as follows:
H0: The frequency is according to the Mendelian ratio
H1: The frequency is not according to the Mendelian ratio
Degrees of freedom: 3
Critical chi square value: 7,815
Calculated chi square value: 11,1111
The results are that we reject H0 and therefore come to the conclusion that the frequency is not according to the Mendelian ratio.

Even though I have the correct answers I still don´t get how he calculates this, so I kindly ask if you could help me calculate this step by step in EXCEL.

Explanation / Answer

Ans:

Multiply 1600*pi for expected count.

df=4-1=3

p-value=CHIDIST(11.111,3)=0.0111

critical chi square=CHIINV(0.05,3)=7.815

As,p-value<0.05,we reject null hypothesis.

Observed(O) pi Expected(E) (O-E)^2/E 1 860 0.5625 900 1.778 2 350 0.1875 300 8.333 3 300 0.1875 300 0.000 4 90 0.0625 100 1.000 Total 1600 1 1600 11.111

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.