Data Analysis with Microsoft Excel: Updated for Office 2007

292 Fundamentals of Statistics

require calculus is higher than expected under the null hypothesis. The ex-

pected count can also be calculated using the formula

Expected count 5

(^1) Row total (^231) Column total 2
Total observations
Thus the expected count of courses that have a calculus prerequisite in
the MathSci departments could also be calculated as follows:
Expected count 5

593119

333

5 21.08

To create a table of expected counts, you can either use Excel to perform

the manual calculations or use the StatPlus add-in to create the table for you.

To create a table of expected counts:

1 Click Descriptive Statistics and then Table Statistics from the StatPlus

menu.

2 Enter the range A4:C8.

3 Click the Output button; then click the New Worksheet option button

and type the worksheet name, Calculus Department Table. Click OK.

4 Click the OK button to start generating the table of expected counts.

See Figure 7-16.

Figure 7-16
Table of
observed and
expected
counts