1. Enter your observed results on one row and your expected results on a second row on the Excel spreadsheet (see the example below). After the data has been entered, place the cursor where you wish to have the significance test for chi-square appear and click the mouse button. Now move the cursor to the Function Wizard (fx) button and click on it.
2. A dialog box will appear. Click on Statistical from the left section of the box and CHITEST on the right section. After you have made those two selections, click on Next> at the bottom of the dialog box.
3. Enter the cell range for your observed data in the actual_range box. For example, if the data for your first variable were in row 2 from column B to D, you would enter B2:D2. Instead of typing the range, you can also move the cursor to the beginning of the set of scores you wish to use and click and drag the cursor across them. Do the same for the expected results in the expected_range box. Once you have entered the range for both variables, click on Finish at the bottom of the dialog box.
4. The significance test for chi-square goodness of fit will appear in the cell you selected.
Del Siegle, PhD