all details are in the word document. supporting documents are in the excel

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

1. Chapter 10 – Problem 8

2. Chapter 10 – Problem 13

3. Chapter 10 – Problem 53

4. Chapter 10 – Problem 54

**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.**

8. (a) State the null hypothesis and the alternate hypothesis. (b) State the decision rule. (c) Compute the value of the test statistic. (d) What is your decision regarding H0? (e) What is the p-value? Interpret it.

At the time she was hired as a server at the Grumney Family Restaurant, Beth Brigden was told, “You can average $80 a day in tips.” Assume the population of daily tips is normally distributed with a standard deviation of $9.95. Over the first 35 days she was employed at the restaurant, the mean daily amount of her tips was $84.85. At the .01 significance level, can Ms. Brigden conclude that her daily tips average more than $80?

13. The mean income per person in the United States is $50,000, and the distribution of incomes follows a normal distribution. A random sample of 10 residents of Wilmington, Delaware, had a mean of $60,000 with a standard deviation of $10,000. At the .05 level of significance, is that enough evidence to conclude that residents of Wilmington, Delaware, have more income than the national average?

**53. Refer to the Baseball 2016 data,**

which report information on the 30 Major League Baseball teams for the 2016 season.

a. Conduct a test of hypothesis to determine whether the mean salary of the teams was different from $100.0 million. Use the .05 significance level.

b. Using a 5% significance level, conduct a test of hypothesis to determine whether the mean attendance was more than 2,000,000 per team.

**54. Refer to the Lincolnville School District bus data**.

a. Select the variable for the number of miles traveled last month. Conduct a hypothesis test to determine whether the mean miles traveled last month equals 10,000. Use the .01 significance level. Find the p-value and explain what it means.

b. A study of school bus fleets reports that the average per bus maintenance cost is $4,000 per year. Using the maintenance cost variable, conduct a hypothesis test to determine whether the mean maintenance cost for Lincolnville’s bus fleet is more than $4,000 at the .05 significance level. Determine the p-value and report the results.