Suppose you have recorded the gender (M or F) and the college status (Fr, So, Jr, Sr, Grad)

for 100 statistics students, as shown in the table below.

1. Enter the observed values into the first five columns of an Excel spreadsheet.
2. Calculate (by hand) the 10 estimated expected cell counts and enter them into another range in the spreadsheet.
3. Place your cursor in an empty cell, and use Formulas ➤ More Functions ➤ Statistical ➤ CHISQ.TEST to generate the Dialog box in Figure 14.3. Highlight or type in the cell ranges for the observed and expected cell counts.

4. When you click OK, MS Excel will calculate the p-value associated with the chi-square test of independence. For this data, the large p-value (.153) indicates a nonsignificant result. There is insufficient evidence to indicate that a student’s gender is dependent on class status.

Transcribed Image Text:

Status Gender Fr So Jr Sr Grad FM 16 8 8 8 4 M 9 11 12 12 12