Answer:
In order to find the p value we can use the following code in excel:
"=CHISQ.DIST(23.453,27,TRUE)"
Conclusion
If we compare the p value and the significance level provided we see that so on this case we have enough evidence in order to FAIL reject the null hypothesis at the significance level provided. And that means that the population variance is not significantly lower than 5% so we can't conclude that we have a moderate risk for this case.
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 lower than 25, 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 27. 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:
"=CHISQ.DIST(23.453,27,TRUE)"
Conclusion
If we compare the p value and the significance level provided we see that so on this case we have enough evidence in order to FAIL reject the null hypothesis at the significance level provided. And that means that the population variance is not significantly lower than 5% so we can't conclude that we have a moderate risk for this case.