Answer:
Step-by-step explanation:
Notation and previous concepts
A chi-square test is "used to test if the variance of a population is equal to a specified value. This test can be either a two-sided test or a one-sided test. The two-sided version tests against the alternative that the true variance is either less than or greater than the specified value"
represent the sample size
represent the confidence level
represent the sample variance obtained
represent the value that we want to test
Null and alternative hypothesis
On this case we want to check if the population variance specification is violated, so the system of hypothesis would be:
Null Hypothesis:
Alternative hypothesis:
Calculate the statistic
For this test we can use the following statistic:
And this statistic is distributed chi square with n-1 degrees of freedom. We have eveything to replace.
Calculate the p value
In order to calculate the p value we need to have in count the degrees of freedom , on this case 131. And since is a right tailed test the p value would be given by:
In order to find the p value we can use the following code in excel:
"=1-CHISQ.DIST(123.952,131,TRUE)"