Using the McGraw-Hill Dataset in the Excel file, located here, complete the following tasks: Task#1: A United Natio
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →
). 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?
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds