Assume that the production manager wants to test the hypothesis that the true mean production time to manufacture an engine is greater than 49 minutes (Hint: H1: U > 49). Compute the sample size, sample mean, and sample standard deviation in cells J6:J8 and specify the hypothesized value and a .05 level of significance (? = .05) of the test in cells J9 and J10. Now specify Ho and H1 in cells G4 & G5 and specify the appropriate information in cells G7, G9, and G11. Clearly state your conclusion about the null and alternative hypotheses in cell G13.

Problem 5b Engine Production Time One Sample Test for the Mean Ho Population standard deviation unknown Sample Production Time (min) H1 65.1 Sample Size 62.3 Test Statistic Sample Mean 60.4 Sample Standard Deviation 58.7 Critical value Hypothesized value 58.1 Level of significance 56.9 P-value 57.0 t-statistic #DIV/O! 56.5 Conclusion One-tailed t-value #NUM! 55.1 Two-tailed t-value (+ and -) #NUM! 10 54.3