An automotive part must be machined to close tolerances to be acceptable to customers. Production specifications call for a maximum variance in the lengths of the parts of 0.0004. A quality control sample produced the data in the Microsoft Excel Online file below. Using a = 0.05, test to see whether the population variance specification is being violated. X Open spreadsheet 1. Formulate the null and alternative hypotheses for this application. Ho: 02 Ha: 02 2. Test statistic = (to 2 decimals) 3. The p-value is 4. Conclusion: V 5. Test results: v Check My Work Reset ProblemB20 w Jx A B C D E F Part Length Inferences About a Population Variance Formulas 5.005 4.96 Sample size #N/A 5.01 Sample mean #N/A 4.965 Sample variance #N/A 5.015 Sample standard deviation #N/A 4.95 4.96 Hypothesized variance 0.0004 5 10 5.015 Degrees of freedom #N/A 11 5 12 5.01 Level of significance 0.05 13 4.98 14 5.02 Critical Value (2 decimals) #N/A 15 4.95 16 4.945 Test statistic (2 decimals) #N/A 17 4.955 18 4.97 p-value (4 decimals) #N/A 19 4.985 20 5.015 Reject null hypothesis? #N/A 21 5.02 22 5.005 23 4.97 24 4.99 25 4.955 26 4.945 27 4.98 28 5.02 29 4.96 30 5.02 31 4.975