Please state what was clicked on when doing the problem, So I can learn.

Problem Set #5 (Chapters 6 & 7, 15 points): Problems a and b below involve working with Engine Production Time sample data for constructing confidence intervals and hypothesis testing. Problem e utilizes Employee Survey data. Note that you are using the t statistic for these problems. a) Utilizing the worksheet Problem 5a, complete the following: Assume that the production manager wants to estimate the true mean production time to manufacture an engine. Compute the sample stand dev, degrees freedom, and sample mean in cells G2:G5. In cells G7 & G8 specify formulas that calculate the upper and lower boundaries of the confidence interval to estimate the true mean time to produce engines. Interpret the confidence interval in the space provided. (Note: The template beginning in row 14 will give you your t-value). b.) Utilizing the worksheet Problem 5b, complete the following: 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:18 and specify the hypothesized value and a .05 level of significance (a = .05) of the test. Now specify Ho and H1 in cells G4 & G5 and specify the appropriate information in cells G7, 69, and G11. Clearly state your conclusion about the null and alternative hypotheses in cell G13. c.)Utilizing the worksheet Problem 5c, complete the following: Assume that a Human Resource officer wants to determine if there is a difference in Male and Female college GPAs. Utilizing the Employee Retention survey sample data, which is sorted by gender, perform a two sample t-test (assuming unequal variances) using the Data Analysis took pack. Do not include labels and use a = .05. Locate the results in the range 15:L18 and change variable 1 to Male and variable 2 to Female. Clearly indicate the Ho & H1 hypotheses in cells L1 and L2. State your conclusion regarding Ho in the area provided in row 21. C G M N 0 P 0 Problem HI 3 Employee Retention LOCATE t-test RESULTS BELOW SAMPLE 5 8 7 a 9 11 6 3 1 19 Conclusion 350 23 24 YearsPLE YsEducation College GPA Age Gender College Grad Local 1 10 18 301 33 F Y Y 4 10 18 3.85 24 F Y Y 5 16 2.50 F Y Y 9 82 19 3.43 32 F Y Y 14 7.2 15 238 23 F N Y 15 16 347 27 F Y Y 19 5.9 2.95 20 F N Y 24 4.7 18 3.12 26 F Y N 28 3.9 10 3.00 20 F Y N 31 37 10 3.50 23 F Y N 37 0.9 10 279 23 F Y Y 0.7 13 F N N 40 0.3 18 3.79 24 F Y N 2 10 10 278 20 M Y Y 3 10 18 3.15 29 M Y N 25 10 2.95 23 M Y Y 7 17 30 M Y Y 8 84 10 264 23 M Y Y 10 79 15 275 34 M N Y 7.6 295 28 M N Y 12 7.5 13 250 23 M N Y 13 7.5 10 2.85 24 M Y Y 16 55 10 3.10 20 Y Y 17 2.90 21 M N Y 18 62 10 271 M Y N 20 58 18 3.36 25 Y Y 21 10 2.75 24 M Y N 22 51 17 2.48 32 M Y N 23 4.8 270 28 M N Y 25 4.5 13 23 M N Y 10 280 M Y N 27 17 3.57 24 M Y Y 29 3.7 10 200 23 M Y N 30 3.7 16 3.19 24 M N N 32 3.5 14 284 21 M N Y 33 16 3.13 24 M Y N 34 25 1.75 M N N 35 1.8 10 2.99 20 M Y N 35 1.5 15 213 22 M N N 38 08 18 3.15 20 M Y N 30 54 ST 39 60 2 63 44 65 Problem Set #5 (Chapters 6 & 7, 15 points): Problems a and b below involve working with Engine Production Time sample data for constructing confidence intervals and hypothesis testing. Problem e utilizes Employee Survey data. Note that you are using the t statistic for these problems. a) Utilizing the worksheet Problem 5a, complete the following: Assume that the production manager wants to estimate the true mean production time to manufacture an engine. Compute the sample stand dev, degrees freedom, and sample mean in cells G2:G5. In cells G7 & G8 specify formulas that calculate the upper and lower boundaries of the confidence interval to estimate the true mean time to produce engines. Interpret the confidence interval in the space provided. (Note: The template beginning in row 14 will give you your t-value). b.) Utilizing the worksheet Problem 5b, complete the following: 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:18 and specify the hypothesized value and a .05 level of significance (a = .05) of the test. Now specify Ho and H1 in cells G4 & G5 and specify the appropriate information in cells G7, 69, and G11. Clearly state your conclusion about the null and alternative hypotheses in cell G13. c.)Utilizing the worksheet Problem 5c, complete the following: Assume that a Human Resource officer wants to determine if there is a difference in Male and Female college GPAs. Utilizing the Employee Retention survey sample data, which is sorted by gender, perform a two sample t-test (assuming unequal variances) using the Data Analysis took pack. Do not include labels and use a = .05. Locate the results in the range 15:L18 and change variable 1 to Male and variable 2 to Female. Clearly indicate the Ho & H1 hypotheses in cells L1 and L2. State your conclusion regarding Ho in the area provided in row 21. C G M N 0 P 0 Problem HI 3 Employee Retention LOCATE t-test RESULTS BELOW SAMPLE 5 8 7 a 9 11 6 3 1 19 Conclusion 350 23 24 YearsPLE YsEducation College GPA Age Gender College Grad Local 1 10 18 301 33 F Y Y 4 10 18 3.85 24 F Y Y 5 16 2.50 F Y Y 9 82 19 3.43 32 F Y Y 14 7.2 15 238 23 F N Y 15 16 347 27 F Y Y 19 5.9 2.95 20 F N Y 24 4.7 18 3.12 26 F Y N 28 3.9 10 3.00 20 F Y N 31 37 10 3.50 23 F Y N 37 0.9 10 279 23 F Y Y 0.7 13 F N N 40 0.3 18 3.79 24 F Y N 2 10 10 278 20 M Y Y 3 10 18 3.15 29 M Y N 25 10 2.95 23 M Y Y 7 17 30 M Y Y 8 84 10 264 23 M Y Y 10 79 15 275 34 M N Y 7.6 295 28 M N Y 12 7.5 13 250 23 M N Y 13 7.5 10 2.85 24 M Y Y 16 55 10 3.10 20 Y Y 17 2.90 21 M N Y 18 62 10 271 M Y N 20 58 18 3.36 25 Y Y 21 10 2.75 24 M Y N 22 51 17 2.48 32 M Y N 23 4.8 270 28 M N Y 25 4.5 13 23 M N Y 10 280 M Y N 27 17 3.57 24 M Y Y 29 3.7 10 200 23 M Y N 30 3.7 16 3.19 24 M N N 32 3.5 14 284 21 M N Y 33 16 3.13 24 M Y N 34 25 1.75 M N N 35 1.8 10 2.99 20 M Y N 35 1.5 15 213 22 M N N 38 08 18 3.15 20 M Y N 30 54 ST 39 60 2 63 44 65