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

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 individuals without a college degree the same as those with a college degree?
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?
b. Are employees’ actual length of service shorter than their planned length of service?
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?
2. Use the Retail Survey data.
a. Are consumers’ gender related to their color preference?
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?
3. Use the Travel Expenses data

a. Compare the travel expenses of the four sales representatives. Are travel expenses of the 3 sales reps different from each other? If there is a difference, how do they differ?
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?