Question 1
Using the MLB data file, answer the following questions.
a.Conduct a test of the hypothesis to determine whether the mean salary of the teams was different from $100.0 million.
Ho: μ = 100 H1: μ ≠ 100
Use the .05 significance level. Use thetdistribution for this calculation (since you do not have all of the player salaries, the data in the file represents a sample of the player salaries). Should we reject or fail to reject the null hypothesis? See LO10-6.
b.Using the 5% significance level, conduct a test of the hypothesis to determine whether the mean attendance was more than 2,000,000 per team.
Ho: μ ≤ 2,000,000 H1: μ > 2,000,000 This is a one-tail test. Be sure to choose the correct value from thetdistribution table.
Should we reject or fail to reject the null hypothesis?
c.At the .05 significance level, can we conclude that there is a difference in the mean salary of teams in the American League versus teams in the National League? See LO11-3 and LO11-04. Use t-test - two-sample assuming equal variances.
d.At the .05 significance level, can we conclude that there is a difference in the mean home attendance of teams in the American League versus teams in the National League? See LO11-3 and LO11-04. Use t-test - two-sample assuming equal variances.
e.Create a variable that classifies a team's total attendance into three groups: less than 2.0 million; 2.0 million up to 3.0 million; and, 3.0 million or more. At the .05 significance level, is there a difference in the mean number of games won among the three groups? (you will use the ANOVA function)
f.Using the same attendance variable developed in part b, is there a difference in the mean number of home runs hit per team? Usethe .05 significance level.(you will use the ANOVA function)
Question 2
Using the LincolnvilleSchool District bus data file, answer the following.
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. (use thetdistribution table)
Ho: μ = 10,000 H1: μ ≠ 10,000
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. (use thetdistribution table)
Ho: μ ≤ 4,000 H1: μ > 4,000
Is there a difference in the mean maintenance costs for the diesel versus gasoline buses? Use the .05 significance level.