Please show which excel formulas to use for the below calculations:

Question 18

Given the following contingency table with category labels A, B, C, X, Y, and Z, what is the expected count with 1 decimal place in the joint category of C and X?

	X	Y	Z
A	18	10	10
B	15	6	2
C	18	1	5

Your Answer:

Hint:

Counts may differ from H0: Model, because of Random error, or model does not fit the data.

Expected counts are computed based on H0.

• A unit of observation can only be counted once.
• The minimum expected count in any one cell must be 5 for the statistics to work.

The chi-squared test statistic measures the deviation of the observed from the expected counts, and follows the skewed chi-squared distribution with parameter DF (slide 5 step 1).