Answer the questions below in Excel, with one question on a separate spreadsheet.

Statistical Inference

Note. Use a = 0.05 for all tests.

1.The Bank Call Center data shows the data on 70 former employees at one of the bank’s call centers.

a. Is the average length of service for all employees shorter than 2.5 years?

1.What are the null and alternative hypotheses?

2.Pick the correct test and calculate the test statistics.

3.Is the alternative hypothesis supported? Why?

a.Explain your evaluation based on the critical value, p-value, and confidence interval

b. Is the average planned length of service for all employees different from 2 years?

1.What are the null and alternative hypotheses?

2.Pick the correct test and calculate the test statistics.

3.Is the alternative hypothesis supported? Why?

a.Explain your evaluation based on the critical value, p-value, and confidence interval

2.Use the Retail Survey data.

a. Do more than half of the consumers prefer Slim Fit?

4.What are the null and alternative hypotheses?

5.Pick the correct test and calculate the test statistics.

6.Is the alternative hypothesis supported? Why?

a.Explain your evaluation based on the critical value, p-value, and confidence interval