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).
DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma
Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t
Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th
1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of