Homework
Using the McGraw-Hill Dataset in the Excel file, located here, complete the following tasks:
Task I
i. Create a frequency distribution table for the Team Salary variable and answer the questions:
ii. What is the range of salary?
iii. What is the shape of the distribution? Does it appear that any of the teams have a salary that is out of line with the others?
iv. Draw a cumulative relative frequency distribution of team salary. Using this distribution, forty percent of the teams have a salary of less than what amount?
v. About how many teams have a total salary of more than $220 million?
Task II
i. The Year Opened is the first year of operation for that stadium. For each team, use this variable to create a new variable, stadium age, by subtracting the value of the variable Year Opened from the current year.
ii. Develop a box plot with the new variable Stadium Age.
iii. Are there any outliers? If so, which of the stadiums are outliers?
iv. Using the variable salary create a box plot. Are there any outliers?
v. Compute the Salary quartiles using formula 4-1. Write a brief summary of your analysis.
vi. Draw a scatter diagram with the variable Wins on the vertical axis and salary on the horizontal axis. What are your conclusions?
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Excel-Data.rar