91Ó°ÊÓ

Given tables are

we have to find P value

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:

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

The P value is$≈0.56$