We can now calculate the p-value for the chi-square test statistic by using a formula of form =CHISQ.TEST(Obs,Exp,df) whereObsis the 3 × 3 array of observed values,Exp= the 3 × 3 array of expected values anddf= (row count – 1) (column count – 1) = 2 ∙ 2 = 4. Sin...
We can now calculate the p-value for the chi-square test statistic by using a formula of form =CHISQ.TEST(Obs,Exp,df) whereObsis the 3 × 3 array of observed values,Exp= the 3 × 3 array of expected values anddf= (row count – 1) (column count – 1) = 2 ∙ 2 = 4. Sin...