McGraw-Hill Dataset in the Excel File

). 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:

Don't use plagiarized sources. Get Your Custom Essay on
McGraw-Hill Dataset in the Excel File
Just from $13/Page
Order Essay

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?

ORDER NOW »»

and taste our undisputed quality.