Suppose you have recorded the gender (M or F) and the university status (1Y, 2Y, 3Y, 4Y, 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 (CHITEST in earlier versions of Excel) to gener- ate the dialogue box in Figure 14.3. Highlight or type in the cell ranges for the observed and expected cell counts.

Transcribed Image Text:

Status Gender 1Y 2Y 3Y 4Y Grad FM 16 8 8 8 4 9 11 12 12 12