Complete the problems below from the textbook. You will need to use the “Lincolnville School District Bus Data” file for this assignment.Chapter 12 – Problem 51Refer to the Lincolnville School District bus data.

Complete the problems below from the textbook. You will need to use the “Lincolnville School District Bus Data” file for this assignment.

1. Chapter 12 – Problem 51

Refer to the Lincolnville School District bus data.

a. Conduct a test of hypothesis to reveal whether the mean maintenance cost is equal

for each of the bus manufacturers. Use the .01 significance level.

b. Conduct a test of hypothesis to determine whether the mean miles traveled since the

last maintenance is equal for each bus manufacturer. Use the .05 significance level.

1. Chapter 15 – Problem 57
2. Please refer attachment
3. Chapter 15 – Problem 64
5. Refer to the Lincolnwood School District bus data.
6. a. Suppose we consider a bus “old” if it has been in service more than 8 years. At the
7. .01 significance level, can we conclude that less than 40% of the district’s buses are
8. old? Report the p-value.
9. b. Find the median maintenance cost and the median age of the buses. Organize the
10. data into a two-by-two contingency table, with buses above and below the median of
11. each variable. Determine whether the age of the bus is related to the amount of the
12. maintenance cost. Use the .05 significance level.
13. c. Is there a relationship between the maintenance cost and the manufacturer of the
14. bus? Use the breakdown in part (b) for the buses above and below the median maintenance
15. cost and the bus manufacturers to create a contingency table. Use the .05
16. significance level.

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.

Submit output in one Excel file.