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 Table results for this data as part of the justification for your conclusions.
School
Test score
Graduation %
1
28.2
85
2
24.8
62
3
25.2
48
4
24.4
54
5
23.7
67
6
22.8
55
7
22.9
59
8
22.3
45
9
22.2
63
10
22.3
76
11
21.7
77
12
21.7
42
13
21.9
58
14
21.3
77
15
20.9
51
16
21.2
41
17
21.1
51
18
20.5
75
19
20.8
58
20
20.4
58
21
20.5
47
22
20.5
44
23
19.5
62
24
20.1
54
25
19.9
33
26
19.4
43
27
19.4
50
28
19.3
40
29
18.9
52
30
18.9
34
31
18.5
48
32
18.8
41
33
18.3
50
34
18.5
48
35
17.7
53
36
17.9
37
37
16.4
40
38
16.5
57
USA 
India