91Ó°ÊÓ

Given tables are

we have to determine what can be concluded at $5\%$significance level.

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

The following steps will be used to calculate the ${\mathrm{χ}}^2$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:

${\mathrm{χ}}^2$test statistic is $≈2.04$$≈2.04$

The P value can be computed in excel as shown below:

The P value is $≈0.56$

therefore, At the $5\%$significance level, we are unable to reject the null hypothesis. As a result, there is sufficient information to conclude that observed and predicted test scores are identical.