What conclusions might you reach concerning Coaches’ Pay and Revenues for College Football? Write a report to interested stakeholders summarising your conclusions.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

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).¹ Based on Question 3.42 in Levine et al (2016)

 

 

Further comments:

Your completed assignment needs to include the following components:

• An Introduction, where the key aspects of this topic are fully discussed. (This discussion should be referenced using the Chicago referencing method)
• The Body of your assignment, where all your findings are presented. (This should include relevant Excel results, graphs, tables…) Each of the pieces of information that are included need to be discussed in relation to the given question.
• A Conclusion, which summarises your key findings and links these back to your comments in the introduction.
• A Bibliography which includes all resources referenced within your assignment.

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

Attachments:

Expert's Answer

866 Times Downloaded

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

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. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

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

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

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

. 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 Sea Ports. Here are the classes and their instance variables we wish to define:

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