We know that there aretotal frequencies. As a result, we multiply each frequency by and calculate the table below.

The following steps will be used to calculate the test statistic.
1. In the first column of the excel sheet, we write the expected frequencies.
2. Fill in the first column of the excel sheet with the observed frequencies.
3. Create a column titled (Observed - Expected)
4. Create a new column to calculate the square of the result (Observed Expected)
5. Divide the square of (Observed - Predicted) by the expected frequencies of each observation in the last column.
6. Finally, we add the last two columns together.
Let's now perform the calculation in Excel as follows:

test statistic is