NOTE: you may complete this assignment either individually or in groups of 2 students. (If you complete this assignment in a pair, then you only need to submit one assignment, which should be a single report, with uniform formatting, fonts etc.)
College football is big business, with coaches’ total pay and revenues, in millions of dollars. The file College Football contains the coaches’ pay and revenues for college football at 105 of the 124 schools that are part of the Division 1 Football Bowl Subdivision. (Source: Data extracted from “College Football Coaches Continue to See Salary Explosion,” USA TODAY, November 20, 2012.)
What conclusions might you reach concerning Coaches’ Pay and Revenues for College Football? Write a report to interested stakeholders summarising your conclusions.
For the ‘coaches’ pay’ and ‘revenue’:
(a) Construct Histograms for each.
(b) Construct Boxplots for each.
(c) Compute Summary Statistics for each.
(d) Create a scatter plot for the Coaches’ pay and Revenues for the 105 Colleges.
(e) Compute the correlation coefficient between Coaches’ pay and Revenues.
You must include all Excel results for this data as part of the justification for your conclusions. (Include them within the appropriate section – not at the end of your document.)
Your assignment must be submitted as a single word document via LMS. You will find the data in College Football on LMS under Topic 5, Data Files for Workshop Questions (Levine 2016).1 Based on Question 3.42 in Levine et al (2016)
Your completed assignment needs to include the following components:
INCLUDE THE MARKING GUIDE (BELOW) AT THE END OF YOUR ASSIGNMENT.
Marks will be allocated according to the quality of each of the components above. It is important that you present your assignment with sufficient detail to fully answer the given question, while at the same time present your arguments in a concise way. (As a guide: Word Limit, ~1500 words).
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.
Get Free Quote!
250 Experts Online