Be sure to save this file. Your assignment is to complete the tasks provided within the Excel document. Upload your Excel submission to Blackboard by Sunday midnight.
Using the McGraw-Hill Dataset in the Excel file, located here, complete the following tasks:
Task#1: A United Nations report shows the mean family income for Mexican migrants to the United States is $27,000 per year. A Farm Labor Organizing Committee evaluation of 25 Mexican family units reveals the mean to be $30,000 with a sample standard deviation of $10,000. Does this information disagree with the United Nations report? Apply the .01 significance level.
Task#2: Refer to the Baseball data:
1) At the 0.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?
2) At the 0.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?
3) Compute the mean and the standard deviation of the number of wins for the 10 teams with the highest salaries. Do the same for the 10 teams with the lowest salaries. At the .05 significance level, is there a difference in the mean attendance for the two groups?