Stadium_Waste-Descriptive_Analysis_4

Install Packages

library(skimr)
library(summarytools)
library(readxl)
library("readr")
library("tidyverse")

── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.1.4     ✔ purrr     1.0.4
✔ forcats   1.0.0     ✔ stringr   1.5.1
✔ ggplot2   3.5.2     ✔ tibble    3.2.1
✔ lubridate 1.9.4     ✔ tidyr     1.3.1
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
✖ tibble::view()  masks summarytools::view()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

library(dplyr)

Import the Data

str(data)

tibble [1,391 × 19] (S3: tbl_df/tbl/data.frame)
 $ Conference                            : chr [1:1391] "Pac12" "Pac12" "Pac12" "Pac12" ...
 $ School                                : chr [1:1391] "Arizona State" "Arizona State" "Arizona State" "Arizona State" ...
 $ State                                 : chr [1:1391] "AZ" "AZ" "AZ" "AZ" ...
 $ Area Classification (0-Rural; 1-Urban): num [1:1391] 0 0 0 0 0 0 0 0 0 0 ...
 $ Year                                  : num [1:1391] 2015 2015 2015 2015 2015 ...
 $ Tenure Year                           : num [1:1391] 1 1 1 1 1 1 1 2 2 2 ...
 $ In-Season_Game                        : num [1:1391] 1 2 3 4 5 6 7 1 2 3 ...
 $ S_Trash (tons)                        : num [1:1391] 4.45 5.56 7.99 3.83 5.04 ...
 $ S_Recycle (tons)                      : num [1:1391] 3.34 3.09 2.88 3.67 5.34 3.7 5.39 2.13 1.19 6.45 ...
 $ S_Compost                             : num [1:1391] 0.15 0.8 0.8 1.4 1.6 2.37 0.6 0 1.6 0.8 ...
 $ S_Other (e.g. Food Donation, reuse)   : num [1:1391] 0 0 0 0 0 0 0 0 0 0 ...
 $ S_Waste Total                         : num [1:1391] 7.94 9.45 11.67 8.9 11.98 ...
 $ S_Diversion                           : num [1:1391] 0.44 0.412 0.315 0.57 0.579 ...
 $ Attendance                            : chr [1:1391] "46500" "43310" "61904" "44157" ...
 $ Game Time                             : POSIXct[1:1391], format: "1899-12-31 20:00:00" "1899-12-31 19:00:00" ...
 $ Game result (Win=1; Loss=0)           : chr [1:1391] "1" "1" "0" "1" ...
 $ Athletic Dept Profit                  : num [1:1391] 566524 566524 566524 566524 566524 ...
 $ Athletic Dept Total Expenses          : num [1:1391] 83873516 83873516 83873516 83873516 83873516 ...
 $ Athletic Dept Total Revenues          : num [1:1391] 84440040 84440040 84440040 84440040 84440040 ...

Clean the data

Select the column

data_clean <- data %>% select(`Conference`, `School`, `Area Classification (0-Rural; 1-Urban)`, `Year`, `Tenure Year`, `In-Season_Game`, `S_Diversion`, `Attendance`, `Game Time`,`Game result (Win=1; Loss=0)`,`Athletic Dept Profit`, `Athletic Dept Total Expenses`, `Athletic Dept Total Revenues`)
data_clean$`Game Time`=format(data_clean$`Game Time`, format = "%H:%M")
data_clean <- data_clean %>% mutate(`Game Time`= as.character(`Game Time`)) %>% mutate(`Area Classification (0-Rural; 1-Urban)`= as.character(`Area Classification (0-Rural; 1-Urban)`)) %>% mutate(`Attendance`= as.numeric(`Attendance`))

Warning: There was 1 warning in `mutate()`.
ℹ In argument: `Attendance = as.numeric(Attendance)`.
Caused by warning:
! NAs introduced by coercion

head(data_clean)

# A tibble: 6 × 13
  Conference School  Area Classification …¹  Year `Tenure Year` `In-Season_Game`
  <chr>      <chr>   <chr>                  <dbl>         <dbl>            <dbl>
1 Pac12      Arizon… 0                       2015             1                1
2 Pac12      Arizon… 0                       2015             1                2
3 Pac12      Arizon… 0                       2015             1                3
4 Pac12      Arizon… 0                       2015             1                4
5 Pac12      Arizon… 0                       2015             1                5
6 Pac12      Arizon… 0                       2015             1                6
# ℹ abbreviated name: ¹​`Area Classification (0-Rural; 1-Urban)`
# ℹ 7 more variables: S_Diversion <dbl>, Attendance <dbl>, `Game Time` <chr>,
#   `Game result (Win=1; Loss=0)` <chr>, `Athletic Dept Profit` <dbl>,
#   `Athletic Dept Total Expenses` <dbl>, `Athletic Dept Total Revenues` <dbl>

Convert the character variables to factor variables

cols_to_factor <- data_clean%>% select_if(is.character) %>% colnames() 
cols_to_factor

[1] "Conference"                            
[2] "School"                                
[3] "Area Classification (0-Rural; 1-Urban)"
[4] "Game Time"                             
[5] "Game result (Win=1; Loss=0)"           

 data_clean <- data_clean %>% 
  mutate(`Game result (Win=1; Loss=0)` = na_if(`Game result (Win=1; Loss=0)`, "N/A")) %>%
          mutate(across(all_of(cols_to_factor), as.factor))

str(data_clean)

tibble [1,391 × 13] (S3: tbl_df/tbl/data.frame)
 $ Conference                            : Factor w/ 5 levels "ACC","Big10",..: 4 4 4 4 4 4 4 4 4 4 ...
 $ School                                : Factor w/ 31 levels "Arizona State",..: 1 1 1 1 1 1 1 1 1 1 ...
 $ Area Classification (0-Rural; 1-Urban): Factor w/ 2 levels "0","1": 1 1 1 1 1 1 1 1 1 1 ...
 $ Year                                  : num [1:1391] 2015 2015 2015 2015 2015 ...
 $ Tenure Year                           : num [1:1391] 1 1 1 1 1 1 1 2 2 2 ...
 $ In-Season_Game                        : num [1:1391] 1 2 3 4 5 6 7 1 2 3 ...
 $ S_Diversion                           : num [1:1391] 0.44 0.412 0.315 0.57 0.579 ...
 $ Attendance                            : num [1:1391] 46500 43310 61904 44157 56534 ...
 $ Game Time                             : Factor w/ 54 levels "09:00","10:00",..: 49 44 46 44 46 13 15 49 44 44 ...
 $ Game result (Win=1; Loss=0)           : Factor w/ 2 levels "0","1": 2 2 1 2 1 2 2 2 2 2 ...
 $ Athletic Dept Profit                  : num [1:1391] 566524 566524 566524 566524 566524 ...
 $ Athletic Dept Total Expenses          : num [1:1391] 83873516 83873516 83873516 83873516 83873516 ...
 $ Athletic Dept Total Revenues          : num [1:1391] 84440040 84440040 84440040 84440040 84440040 ...

Descriptive Analysis

summary(data_clean)

 Conference                  School    Area Classification (0-Rural; 1-Urban)
 ACC  :230   Michigan           :143   0   : 149                             
 Big10:594   Ohio State         :123   1   :1221                             
 Big12: 77   UNC                :100   NA's:  21                             
 Pac12:221   Penn State         : 82                                         
 SEC  :269   Tennessee          : 77                                         
             Colorado University: 59                                         
             (Other)            :807                                         
      Year       Tenure Year     In-Season_Game   S_Diversion    
 Min.   :2003   Min.   : 1.000   Min.   :1.000   Min.   :0.0000  
 1st Qu.:2013   1st Qu.: 2.000   1st Qu.:2.000   1st Qu.:0.1585  
 Median :2016   Median : 4.000   Median :4.000   Median :0.2984  
 Mean   :2015   Mean   : 5.958   Mean   :3.867   Mean   :0.3996  
 3rd Qu.:2018   3rd Qu.: 9.000   3rd Qu.:6.000   3rd Qu.:0.6770  
 Max.   :2024   Max.   :20.000   Max.   :9.000   Max.   :0.9868  
 NA's   :84                                                      
   Attendance       Game Time   Game result (Win=1; Loss=0)
 Min.   :  1275   12:00  :357   0   :416                   
 1st Qu.: 48542   15:30  :248   1   :969                   
 Median : 78556   19:30  :131   NA's:  6                   
 Mean   : 73502   19:00  :101                              
 3rd Qu.:101762   12:30  : 71                              
 Max.   :115109   20:00  : 62                              
 NA's   :1        (Other):421                              
 Athletic Dept Profit Athletic Dept Total Expenses Athletic Dept Total Revenues
 Min.   :-64721133    Min.   : 48207321            Min.   : 47191240           
 1st Qu.:        0    1st Qu.: 86924779            1st Qu.: 89079982           
 Median :  1763077    Median :115349117            Median :122739052           
 Mean   :  4407879    Mean   :120151264            Mean   :125072097           
 3rd Qu.:  8224233    3rd Qu.:139798191            3rd Qu.:147511034           
 Max.   : 65413805    Max.   :327782612            Max.   :331905866           
                      NA's   :145                  NA's   :145                 

skim(data_clean)

Data summary

Name	data_clean
Number of rows	1391
Number of columns	13
_______________________
Column type frequency:
factor	5
numeric	8
________________________
Group variables	None

Variable type: factor

skim_variable	n_missing	complete_rate	ordered	n_unique	top_counts
Conference	0	1.00	FALSE	5	Big: 594, SEC: 269, ACC: 230, Pac: 221
School	0	1.00	FALSE	31	Mic: 143, Ohi: 123, UNC: 100, Pen: 82
Area Classification (0-Rural; 1-Urban)	21	0.98	FALSE	2	1: 1221, 0: 149
Game Time	0	1.00	FALSE	54	12:: 357, 15:: 248, 19:: 131, 19:: 101
Game result (Win=1; Loss=0)	6	1.00	FALSE	2	1: 969, 0: 416

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
Year	84	0.94	2015.36	4.62	2003	2013.00	2016.0	2018.00	2024.00	▂▂▅▇▂
Tenure Year	0	1.00	5.96	4.64	1	2.00	4.0	9.00	20.00	▇▃▂▂▁
In-Season_Game	0	1.00	3.87	1.98	1	2.00	4.0	6.00	9.00	▇▇▃▆▁
S_Diversion	0	1.00	0.40	0.29	0	0.16	0.3	0.68	0.99	▇▆▃▃▃
Attendance	1	1.00	73502.37	28000.27	1275	48541.75	78556.0	101762.00	115109.00	▁▅▅▅▇
Athletic Dept Profit	0	1.00	4407878.58	12982815.85	-64721133	0.00	1763077.0	8224233.00	65413805.00	▁▁▇▂▁
Athletic Dept Total Expenses	145	0.90	120151263.53	46373051.82	48207321	86924779.00	115349117.0	139798191.00	327782612.00	▇▇▁▁▁
Athletic Dept Total Revenues	145	0.90	125072097.49	48770769.83	47191240	89079982.00	122739052.0	147511034.00	331905866.00	▇▇▂▁▁

summary_df <- summarytools::dfSummary(data_clean,
                                     varnumbers=FALSE,
                                     plain.ascii=FALSE,
                                     style="grid",
                                     graph.col = TRUE,
                                     valid.col=FALSE)

# Print the summary table and suppress warnings
print(summary_df,
      method="render",
      table.classes="table-condensed")

Data Frame Summary

data_clean

Dimensions: 1391 x 13
Duplicates: 0

Variable	Stats / Values	Freqs (% of Valid)	Graph	Missing
Conference [factor]	1. ACC 2. Big10 3. Big12 4. Pac12 5. SEC	230 ( 16.5% ) 594 ( 42.7% ) 77 ( 5.5% ) 221 ( 15.9% ) 269 ( 19.3% )		0 (0.0%)
School [factor]	1. Arizona State 2. Arkansas 3. Auburn 4. Clemson 5. Colorado University 6. Duke 7. Florida 8. Georgia 9. Georgia Tech 10. Illinois [ 21 others ]	33 ( 2.4% ) 6 ( 0.4% ) 36 ( 2.6% ) 28 ( 2.0% ) 59 ( 4.2% ) 38 ( 2.7% ) 43 ( 3.1% ) 36 ( 2.6% ) 33 ( 2.4% ) 28 ( 2.0% ) 1051 ( 75.6% )		0 (0.0%)
Area Classification (0-Rural; 1-Urban) [factor]	1. 0 2. 1	149 ( 10.9% ) 1221 ( 89.1% )		21 (1.5%)
Year [numeric]	Mean (sd) : 2015.4 (4.6) min ≤ med ≤ max: 2003 ≤ 2016 ≤ 2024 IQR (CV) : 5 (0)	22 distinct values		84 (6.0%)
Tenure Year [numeric]	Mean (sd) : 6 (4.6) min ≤ med ≤ max: 1 ≤ 4 ≤ 20 IQR (CV) : 7 (0.8)	20 distinct values		0 (0.0%)
In-Season_Game [numeric]	Mean (sd) : 3.9 (2) min ≤ med ≤ max: 1 ≤ 4 ≤ 9 IQR (CV) : 4 (0.5)	1 : 209 ( 15.0% ) 2 : 212 ( 15.2% ) 3 : 210 ( 15.1% ) 4 : 206 ( 14.8% ) 5 : 204 ( 14.7% ) 6 : 199 ( 14.3% ) 7 : 131 ( 9.4% ) 8 : 19 ( 1.4% ) 9 : 1 ( 0.1% )		0 (0.0%)
S_Diversion [numeric]	Mean (sd) : 0.4 (0.3) min ≤ med ≤ max: 0 ≤ 0.3 ≤ 1 IQR (CV) : 0.5 (0.7)	1301 distinct values		0 (0.0%)
Attendance [numeric]	Mean (sd) : 73502.4 (28000.3) min ≤ med ≤ max: 1275 ≤ 78556 ≤ 115109 IQR (CV) : 53220.2 (0.4)	1200 distinct values		1 (0.1%)
Game Time [factor]	1. 09:00 2. 10:00 3. 11:00 4. 11:05 5. 11:30 6. 12:00 7. 12:05 8. 12:10 9. 12:15 10. 12:20 [ 44 others ]	1 ( 0.1% ) 2 ( 0.1% ) 58 ( 4.2% ) 2 ( 0.1% ) 7 ( 0.5% ) 357 ( 25.7% ) 1 ( 0.1% ) 2 ( 0.1% ) 1 ( 0.1% ) 17 ( 1.2% ) 943 ( 67.8% )		0 (0.0%)
Game result (Win=1; Loss=0) [factor]	1. 0 2. 1	416 ( 30.0% ) 969 ( 70.0% )		6 (0.4%)
Athletic Dept Profit [numeric]	Mean (sd) : 4407879 (12982816) min ≤ med ≤ max: -64721133 ≤ 1763077 ≤ 65413805 IQR (CV) : 8224233 (2.9)	187 distinct values		0 (0.0%)
Athletic Dept Total Expenses [numeric]	Mean (sd) : 120151264 (46373052) min ≤ med ≤ max: 48207321 ≤ 115349117 ≤ 327782612 IQR (CV) : 52873412 (0.4)	189 distinct values		145 (10.4%)
Athletic Dept Total Revenues [numeric]	Mean (sd) : 125072098 (48770770) min ≤ med ≤ max: 47191240 ≤ 122739052 ≤ 331905866 IQR (CV) : 58431052 (0.4)	189 distinct values		145 (10.4%)

Generated by summarytools 1.1.4 (R version 4.5.1)
2025-10-08

Focous on missing data

Area Classification (0-Rural; 1-Urban)

Area_Classification_Missing <- subset(data_clean, is.na(`Area Classification (0-Rural; 1-Urban)`))
print.data.frame (Area_Classification_Missing)

   Conference         School Area Classification (0-Rural; 1-Urban) Year
1       Big10 Michigan State                                   <NA> 2016
2       Big10 Michigan State                                   <NA> 2016
3       Big10 Michigan State                                   <NA> 2016
4       Big10 Michigan State                                   <NA> 2016
5       Big10 Michigan State                                   <NA> 2016
6       Big10 Michigan State                                   <NA> 2016
7       Big10 Michigan State                                   <NA> 2016
8       Big10 Michigan State                                   <NA> 2017
9       Big10 Michigan State                                   <NA> 2017
10      Big10 Michigan State                                   <NA> 2017
11      Big10 Michigan State                                   <NA> 2017
12      Big10 Michigan State                                   <NA> 2017
13      Big10 Michigan State                                   <NA> 2017
14      Big10 Michigan State                                   <NA> 2017
15      Big10 Michigan State                                   <NA> 2018
16      Big10 Michigan State                                   <NA> 2018
17      Big10 Michigan State                                   <NA> 2018
18      Big10 Michigan State                                   <NA> 2018
19      Big10 Michigan State                                   <NA> 2018
20      Big10 Michigan State                                   <NA> 2018
21      Big10 Michigan State                                   <NA> 2018
   Tenure Year In-Season_Game S_Diversion Attendance Game Time
1            1              1  0.31454738      74516     19:00
2            1              2  0.12079048      75505     12:00
3            1              3  0.28341596      74214     15:30
4            1              4  0.15448427      75625     15:30
5            1              5  0.21509253      75802     12:00
6            1              6  0.16111329      73701     12:00
7            1              7  0.12678612      73701     12:00
8            2              1  0.31990103      71202     12:00
9            2              2  0.21425811      72910     15:30
10           2              3  0.18494272      74023     20:00
11           2              4  0.22219494      73331     15:30
12           2              5  0.19099072      74111     15:30
13           2              6  0.16292771      71605     12:00
14           2              7  0.15878788      70216     16:00
15           3              1  0.18667320      73114     19:00
16           3              2  0.10285285      73752     12:00
17           3              3  0.13200000      72850     12:00
18           3              4  0.05487805      76131     12:00
19           3              5  0.18742217      72657     12:00
20           3              6  0.14628821      74633     12:00
21           3              7  0.13849093      64951     16:00
   Game result (Win=1; Loss=0) Athletic Dept Profit
1                            1              1142101
2                            0              1142101
3                            0              1142101
4                            0              1142101
5                            0              1142101
6                            1              1142101
7                            0              1142101
8                            1              8515105
9                            1              8515105
10                           0              8515105
11                           1              8515105
12                           1              8515105
13                           1              8515105
14                           1              8515105
15                           1              8224233
16                           1              8224233
17                           0              8224233
18                           0              8224233
19                           1              8224233
20                           0              8224233
21                           1              8224233
   Athletic Dept Total Expenses Athletic Dept Total Revenues
1                     121892394                    123034495
2                     121892394                    123034495
3                     121892394                    123034495
4                     121892394                    123034495
5                     121892394                    123034495
6                     121892394                    123034495
7                     121892394                    123034495
8                     117506272                    126021377
9                     117506272                    126021377
10                    117506272                    126021377
11                    117506272                    126021377
12                    117506272                    126021377
13                    117506272                    126021377
14                    117506272                    126021377
15                    137416056                    145640289
16                    137416056                    145640289
17                    137416056                    145640289
18                    137416056                    145640289
19                    137416056                    145640289
20                    137416056                    145640289
21                    137416056                    145640289

Year

Year_Missing <- subset(data_clean, is.na(`Year`))
print.data.frame (Year_Missing)

   Conference     School Area Classification (0-Rural; 1-Urban) Year
1       Big10 Ohio State                                      1   NA
2       Big10 Ohio State                                      1   NA
3       Big10 Ohio State                                      1   NA
4       Big10 Ohio State                                      1   NA
5       Big10 Ohio State                                      1   NA
6       Big10 Ohio State                                      1   NA
7       Big10 Ohio State                                      1   NA
8       Big10 Ohio State                                      1   NA
9       Big10 Ohio State                                      1   NA
10      Big10 Ohio State                                      1   NA
11      Big10 Ohio State                                      1   NA
12      Big10 Ohio State                                      1   NA
13      Big10 Ohio State                                      1   NA
14      Big10 Ohio State                                      1   NA
15      Big10 Ohio State                                      1   NA
16      Big10 Ohio State                                      1   NA
17      Big10 Ohio State                                      1   NA
18      Big10 Ohio State                                      1   NA
19      Big10 Ohio State                                      1   NA
20      Big10 Ohio State                                      1   NA
21      Big10 Ohio State                                      1   NA
22      Big10 Ohio State                                      1   NA
23      Big10 Ohio State                                      1   NA
24      Big10 Ohio State                                      1   NA
25      Big10 Ohio State                                      1   NA
26      Big10 Ohio State                                      1   NA
27      Big10 Ohio State                                      1   NA
28      Big10 Ohio State                                      1   NA
29      Big10 Ohio State                                      1   NA
30      Big10 Ohio State                                      1   NA
31      Big10 Ohio State                                      1   NA
32      Big10 Ohio State                                      1   NA
33      Big10 Ohio State                                      1   NA
34      Big10 Ohio State                                      1   NA
35      Big10 Ohio State                                      1   NA
36      Big10 Ohio State                                      1   NA
37      Big10 Ohio State                                      1   NA
38      Big10 Ohio State                                      1   NA
39      Big10 Ohio State                                      1   NA
40      Big10 Ohio State                                      1   NA
41      Big10 Ohio State                                      1   NA
42      Big10 Ohio State                                      1   NA
43      Big10 Ohio State                                      1   NA
44      Big10 Ohio State                                      1   NA
45      Big10 Ohio State                                      1   NA
46      Big10 Ohio State                                      1   NA
47      Big10 Ohio State                                      1   NA
48      Big10 Ohio State                                      1   NA
49      Big10 Ohio State                                      1   NA
50      Big10 Ohio State                                      1   NA
51      Big10 Ohio State                                      1   NA
52      Big10 Ohio State                                      1   NA
53      Big10 Ohio State                                      1   NA
54      Big10 Ohio State                                      1   NA
55      Big10 Ohio State                                      1   NA
56      Big10 Ohio State                                      1   NA
57      Big10 Ohio State                                      1   NA
58      Big10 Ohio State                                      1   NA
59      Big10 Ohio State                                      1   NA
60      Big10 Ohio State                                      1   NA
61      Big10 Ohio State                                      1   NA
62      Big10 Ohio State                                      1   NA
63      Big10 Ohio State                                      1   NA
64      Big10 Ohio State                                      1   NA
65      Big10 Ohio State                                      1   NA
66      Big10 Ohio State                                      1   NA
67      Big10 Ohio State                                      1   NA
68      Big10 Ohio State                                      1   NA
69      Big10 Ohio State                                      1   NA
70      Big10 Ohio State                                      1   NA
71      Big10 Ohio State                                      1   NA
72      Big10 Ohio State                                      1   NA
73      Big10 Ohio State                                      1   NA
74      Big10 Ohio State                                      1   NA
75      Big10 Ohio State                                      1   NA
76      Big10 Ohio State                                      1   NA
77      Big10 Ohio State                                      1   NA
78      Big10 Ohio State                                      1   NA
79      Big10 Ohio State                                      1   NA
80      Big10 Ohio State                                      1   NA
81      Big10 Ohio State                                      1   NA
82      Big10 Ohio State                                      1   NA
83      Big10 Ohio State                                      1   NA
84      Big10 Ohio State                                      1   NA
   Tenure Year In-Season_Game S_Diversion Attendance Game Time
1            1              1   0.6149968     105123     12:00
2            1              2   0.7679121     104317     12:00
3            1              3   0.6966610     105178     15:30
4            1              4   0.6671018     105051     12:00
5            1              5   0.7003745     105287     15:30
6            1              6   0.7545045     105449     12:00
7            1              7   0.7151380     105453     15:30
8            2              1   0.6226106     105011     12:00
9            2              2   0.5481172     105002     12:00
10           2              3   0.4191617     102989     12:00
11           2              4   0.3021583     105175     12:00
12           2              5   0.3666667     105378     15:30
13           2              6   0.5878378     105711     20:00
14           2              7   0.3272727     105564     12:00
15           3              1   0.3762598     105092     12:00
16           3              2   0.3518041     106033     20:00
17           3              3   0.3460389     105219     15:30
18           3              4   0.3718062     105301     15:30
19           3              5   0.3531915     105011     12:00
20           3              6   0.3240043     104719     12:00
21           3              7   0.3100983     105455     15:30
22           4              1   0.5701970     105040     19:30
23           4              2   0.3040096     105545     15:30
24           4              3   0.3042409     105075     12:00
25           4              4   0.2799588     105017     15:30
26           4              5   0.4732824     105291     12:00
27           4              6   0.7554439     105387     12:00
28           4              7   0.5448155     105466     15:30
29           4              8   0.5631865     105491     12:00
30           5              1   0.7737129     105001     12:00
31           5              2   0.6474666     105016     12:00
32           5              3   0.7218826     105096     15:30
33           5              4   0.8195793     105306     15:30
34           5              5   0.7404657     105511     20:00
35           5              6   0.8242154     105195     12:00
36           5              7   0.7455702     105493     15:30
37           6              2   0.8320000     104745     12:00
38           6              3   0.7985918     105232     12:00
39           6              4   0.8456694     105019     12:00
40           6              5   0.8695464     106102     20:00
41           6              6   0.9439779     105290     12:00
42           6              7   0.9819820     105311     15:30
43           6              8   0.9739414     105899     12:00
44           7              1   0.9648650     103980     12:00
45           7              2   0.9701422     104984     15:30
46           7              3   0.9711978     103595     12:00
47           7              4   0.9847349     105826     20:00
48           7              6   0.9651958     105889     20:00
49           7              7   0.9806096     104990     15:30
50           8              1   0.9568461     107517     20:00
51           8              2   0.9416908     104404     12:00
52           8              3   0.9387927     108362     18:00
53           8              4   0.9382449     106795     15:30
54           8              5   0.9733522     106961     20:00
55           8              6   0.9867765     101426     12:00
56           8              7   0.9310241     108610     12:00
57           9              1   0.9684423     107145     15:30
58           9              2   0.9698581     104095     15:30
59           9              3   0.9604530     106123     15:30
60           9              4   0.9536952     107869     12:00
61           9              5   0.9623429     108423     20:00
62           9              6   0.9661586     108075     20:00
63           9              7   0.9626427     108975     15:30
64          10              1   0.9485340     107193     12:00
65          10              2   0.9467382     104410     15:30
66          10              3   0.9577099     105830     12:00
67          10              4   0.9540089     107420     15:30
68          10              5   0.9555846     107296     15:30
69          10              6   0.9542985     108750     20:00
70          10              7   0.9622553     110045     12:00
71          11              1   0.8419447     109088     19:30
72          11              2   0.8359955     108414     16:30
73          11              3   0.7718407     106187     12:00
74          11              4   0.9419062     107180     16:00
75          11              5   0.9413146     109302     15:30
76          11              6   0.9352106     107011     12:00
77          11              7   0.9308797     105282     15:30
78          12              1   0.9471842     102169     12:00
79          12              2   0.9475715      93057     15:30
80          12              3   0.9424229     103336     15:30
81          12              4   0.9423831     104193     16:00
82          12              5   0.9359395     100042     12:00
83          12              6   0.9345038     104245     12:00
84          12              7   0.9381043     106588     12:00
   Game result (Win=1; Loss=0) Athletic Dept Profit
1                            1               184302
2                            1               184302
3                            1               184302
4                            1               184302
5                            1               184302
6                            1               184302
7                            0               184302
8                            1              1472174
9                            1              1472174
10                           1              1472174
11                           1              1472174
12                           1              1472174
13                           0              1472174
14                           1              1472174
15                           1              -148027
16                           0              -148027
17                           1              -148027
18                           1              -148027
19                           1              -148027
20                           1              -148027
21                           1              -148027
22                           1               434422
23                           1               434422
24                           1               434422
25                           1               434422
26                           1               434422
27                           1               434422
28                           1               434422
29                           1               434422
30                           1              9528952
31                           1              9528952
32                           1              9528952
33                           0              9528952
34                           1              9528952
35                           1              9528952
36                           0              9528952
37                           1             17623645
38                           1             17623645
39                           1             17623645
40                           1             17623645
41                           1             17623645
42                           1             17623645
43                           1             17623645
44                           1             23612978
45                           1             23612978
46                           1             23612978
47                           1             23612978
48                           1             23612978
49                           1             23612978
50                           0             31295680
51                           1             31295680
52                           1             31295680
53                           1             31295680
54                           1             31295680
55                           1             31295680
56                           1             31295680
57                           1             10196870
58                           1             10196870
59                           1             10196870
60                           1             10196870
61                           1             10196870
62                           1             10196870
63                           0             10196870
64                           1              1714752
65                           1              1714752
66                           1              1714752
67                           0              1714752
68                           1              1714752
69                           1              1714752
70                           1              1714752
71                           0              9665921
72                           1              9665921
73                           1              9665921
74                           1              9665921
75                           1              9665921
76                           1              9665921
77                           1              9665921
78                           1              -915988
79                           1              -915988
80                           1              -915988
81                           1              -915988
82                           1              -915988
83                           1              -915988
84                           1              -915988
   Athletic Dept Total Expenses Athletic Dept Total Revenues
1                     109197920                    109382222
2                     109197920                    109382222
3                     109197920                    109382222
4                     109197920                    109382222
5                     109197920                    109382222
6                     109197920                    109382222
7                     109197920                    109382222
8                     114264848                    115737022
9                     114264848                    115737022
10                    114264848                    115737022
11                    114264848                    115737022
12                    114264848                    115737022
13                    114264848                    115737022
14                    114264848                    115737022
15                    119859608                    119711581
16                    119859608                    119711581
17                    119859608                    119711581
18                    119859608                    119711581
19                    119859608                    119711581
20                    119859608                    119711581
21                    119859608                    119711581
22                    122739754                    123174176
23                    122739754                    123174176
24                    122739754                    123174176
25                    122739754                    123174176
26                    122739754                    123174176
27                    122739754                    123174176
28                    122739754                    123174176
29                    122739754                    123174176
30                    122286869                    131815821
31                    122286869                    131815821
32                    122286869                    131815821
33                    122286869                    131815821
34                    122286869                    131815821
35                    122286869                    131815821
36                    122286869                    131815821
37                    124419412                    142043057
38                    124419412                    142043057
39                    124419412                    142043057
40                    124419412                    142043057
41                    124419412                    142043057
42                    124419412                    142043057
43                    124419412                    142043057
44                    116026329                    139639307
45                    116026329                    139639307
46                    116026329                    139639307
47                    116026329                    139639307
48                    116026329                    139639307
49                    116026329                    139639307
50                    113937001                    145232681
51                    113937001                    145232681
52                    113937001                    145232681
53                    113937001                    145232681
54                    113937001                    145232681
55                    113937001                    145232681
56                    113937001                    145232681
57                    156969195                    167166065
58                    156969195                    167166065
59                    156969195                    167166065
60                    156969195                    167166065
61                    156969195                    167166065
62                    156969195                    167166065
63                    156969195                    167166065
64                    169075013                    170789765
65                    169075013                    170789765
66                    169075013                    170789765
67                    169075013                    170789765
68                    169075013                    170789765
69                    169075013                    170789765
70                    169075013                    170789765
71                    175743681                    185409602
72                    175743681                    185409602
73                    175743681                    185409602
74                    175743681                    185409602
75                    175743681                    185409602
76                    175743681                    185409602
77                    175743681                    185409602
78                    206472651                    205556663
79                    206472651                    205556663
80                    206472651                    205556663
81                    206472651                    205556663
82                    206472651                    205556663
83                    206472651                    205556663
84                    206472651                    205556663

Attendance

Attendance_Missing <- subset(data_clean, is.na(`Attendance`)) ## This one is cancelled
print.data.frame (Attendance_Missing)

  Conference School Area Classification (0-Rural; 1-Urban) Year Tenure Year
1        SEC    LSU                                      1 2015           1
  In-Season_Game S_Diversion Attendance Game Time Game result (Win=1; Loss=0)
1              1   0.2034806         NA     19:30                        <NA>
  Athletic Dept Profit Athletic Dept Total Expenses
1             12009860                    126632377
  Athletic Dept Total Revenues
1                    138642237

Game result (Win=1; Loss=0)

Game_result_Missing <- subset(data_clean, is.na(`Game result (Win=1; Loss=0)`))
print.data.frame (Game_result_Missing)

  Conference     School Area Classification (0-Rural; 1-Urban) Year Tenure Year
1        SEC        LSU                                      1 2015           1
2      Big10 Penn State                                      1 2021          13
3      Big10 Penn State                                      1 2021          13
4      Big10 Penn State                                      1 2021          13
5      Big10 Penn State                                      1 2021          13
6        SEC  Tennessee                                      1 2007           2
  In-Season_Game S_Diversion Attendance Game Time Game result (Win=1; Loss=0)
1              1  0.20348059         NA     19:30                        <NA>
2              1  0.09746261     105323     15:30                        <NA>
3              2  0.09761236     109958     19:30                        <NA>
4              3  0.09776430     105790     12:00                        <NA>
5              4  0.10214860     105951     19:30                        <NA>
6              7  0.10614525     105077     14:00                        <NA>
  Athletic Dept Profit Athletic Dept Total Expenses
1             12009860                    126632377
2            -23890987                    130050505
3            -23890987                    130050505
4            -23890987                    130050505
5            -23890987                    130050505
6              2844343                     94445270
  Athletic Dept Total Revenues
1                    138642237
2                    106159518
3                    106159518
4                    106159518
5                    106159518
6                     97289613

Athletic Dept Total Expenses

Athletic_Dept_Total_Expenses_Missing <- subset(data_clean, is.na(`Athletic Dept Total Expenses`))
print.data.frame (Athletic_Dept_Total_Expenses_Missing)

    Conference     School Area Classification (0-Rural; 1-Urban) Year
1          ACC       Duke                                      1 2014
2          ACC       Duke                                      1 2014
3          ACC       Duke                                      1 2014
4          ACC       Duke                                      1 2014
5          ACC       Duke                                      1 2014
6          ACC       Duke                                      1 2014
7          ACC       Duke                                      1 2014
8          ACC       Duke                                      1 2015
9          ACC       Duke                                      1 2015
10         ACC       Duke                                      1 2015
11         ACC       Duke                                      1 2015
12         ACC       Duke                                      1 2015
13         ACC       Duke                                      1 2015
14         ACC       Duke                                      1 2016
15         ACC       Duke                                      1 2016
16         ACC       Duke                                      1 2016
17         ACC       Duke                                      1 2016
18         ACC       Duke                                      1 2016
19         ACC       Duke                                      1 2016
20         ACC       Duke                                      1 2017
21         ACC       Duke                                      1 2017
22         ACC       Duke                                      1 2017
23         ACC       Duke                                      1 2017
24         ACC       Duke                                      1 2017
25         ACC       Duke                                      1 2017
26         ACC       Duke                                      1 2017
27         ACC       Duke                                      1 2018
28         ACC       Duke                                      1 2018
29         ACC       Duke                                      1 2018
30         ACC       Duke                                      1 2018
31         ACC       Duke                                      1 2018
32         ACC       Duke                                      1 2018
33         ACC       Duke                                      1 2019
34         ACC       Duke                                      1 2019
35         ACC       Duke                                      1 2019
36         ACC       Duke                                      1 2019
37         ACC       Duke                                      1 2019
38         ACC       Duke                                      1 2019
39       Big10   Michigan                                      1 2004
40       Big10   Michigan                                      1 2004
41       Big10   Michigan                                      1 2004
42       Big10   Michigan                                      1 2004
43       Big10   Michigan                                      1 2004
44       Big10   Michigan                                      1 2004
45       Big10 Penn State                                      1 2009
46       Big10 Penn State                                      1 2009
47       Big10 Penn State                                      1 2009
48       Big10 Penn State                                      1 2009
49       Big10 Penn State                                      1 2009
50       Big10 Penn State                                      1 2009
51       Big10 Penn State                                      1 2009
52       Big10 Penn State                                      1 2009
53       Big10 Penn State                                      1 2010
54       Big10 Penn State                                      1 2010
55       Big10 Penn State                                      1 2010
56       Big10 Penn State                                      1 2010
57       Big10 Penn State                                      1 2010
58       Big10 Penn State                                      1 2010
59       Big10 Penn State                                      1 2010
60       Pac12   Stanford                                      0 2015
61       Pac12   Stanford                                      0 2015
62       Pac12   Stanford                                      0 2015
63       Pac12   Stanford                                      0 2015
64       Pac12   Stanford                                      0 2015
65       Pac12   Stanford                                      0 2015
66       Pac12   Stanford                                      0 2016
67       Pac12   Stanford                                      0 2016
68       Pac12   Stanford                                      0 2016
69       Pac12   Stanford                                      0 2016
70       Pac12   Stanford                                      0 2016
71       Pac12   Stanford                                      0 2016
72       Pac12   Stanford                                      0 2015
73       Pac12   Stanford                                      0 2017
74       Pac12   Stanford                                      0 2017
75       Pac12   Stanford                                      0 2017
76       Pac12   Stanford                                      0 2017
77       Pac12   Stanford                                      0 2017
78       Pac12   Stanford                                      0 2017
79       Pac12   Stanford                                      0 2018
80       Pac12   Stanford                                      0 2018
81       Pac12   Stanford                                      0 2018
82       Pac12   Stanford                                      0 2018
83       Pac12   Stanford                                      0 2018
84       Pac12   Stanford                                      0 2018
85       Pac12   Stanford                                      0 2019
86       Pac12   Stanford                                      0 2019
87       Pac12   Stanford                                      0 2019
88       Pac12   Stanford                                      0 2019
89       Pac12   Stanford                                      0 2019
90       Pac12   Stanford                                      0 2019
91       Pac12   Stanford                                      0 2019
92         ACC        UNC                                      1 2004
93         ACC        UNC                                      1 2004
94         ACC        UNC                                      1 2004
95         ACC        UNC                                      1 2004
96         ACC        UNC                                      1 2004
97         ACC        UNC                                      1 2004
98       Pac12        USC                                      1 2015
99       Pac12        USC                                      1 2015
100      Pac12        USC                                      1 2015
101      Pac12        USC                                      1 2015
102      Pac12        USC                                      1 2015
103      Pac12        USC                                      1 2015
104      Pac12        USC                                      1 2015
105      Pac12        USC                                      1 2019
106      Pac12        USC                                      1 2019
107      Pac12        USC                                      1 2019
108      Pac12        USC                                      1 2019
109      Pac12        USC                                      1 2019
110      Pac12        USC                                      1 2019
111      Pac12        USC                                      1 2020
112      Pac12        USC                                      1 2020
113      Pac12        USC                                      1 2020
114      Pac12 Washington                                      1 2003
115      Pac12 Washington                                      1 2003
116      Pac12 Washington                                      1 2003
117      Pac12 Washington                                      1 2003
118      Pac12 Washington                                      1 2003
119      Pac12 Washington                                      1 2003
120      Pac12 Washington                                      1 2003
121      Pac12 Washington                                      1 2004
122      Pac12 Washington                                      1 2004
123      Pac12 Washington                                      1 2004
124      Pac12 Washington                                      1 2004
125      Pac12 Washington                                      1 2004
126      Pac12 Washington                                      1 2004
127      Pac12 Washington                                      1 2005
128      Pac12 Washington                                      1 2005
129      Pac12 Washington                                      1 2005
130      Pac12 Washington                                      1 2005
131      Pac12 Washington                                      1 2005
132      Pac12 Washington                                      1 2005
133      Pac12 Washington                                      1 2006
134      Pac12 Washington                                      1 2006
135      Pac12 Washington                                      1 2006
136      Pac12 Washington                                      1 2006
137      Pac12 Washington                                      1 2006
138      Pac12 Washington                                      1 2006
139      Pac12 Washington                                      1 2007
140      Pac12 Washington                                      1 2007
141      Pac12 Washington                                      1 2007
142      Pac12 Washington                                      1 2007
143      Pac12 Washington                                      1 2007
144      Pac12 Washington                                      1 2007
145      Pac12 Washington                                      1 2007
    Tenure Year In-Season_Game S_Diversion Attendance Game Time
1             1              1  0.45965770      31213     18:00
2             1              2  0.55328798      25203     15:00
3             1              3  0.38927098      20197     12:30
4             1              4  0.44155844      28131     12:30
5             1              5  0.44279661      30107     12:00
6             1              6  0.65346535      33941     19:30
7             1              7  0.41448382      22246     19:00
8             2              1  0.35403727      33941     18:00
9             2              2  0.23130435      24127     12:30
10            2              3  0.45177665      20101     12:00
11            2              4  0.47011309      20009     15:00
12            2              5  0.71062547      30143     19:00
13            2              6  0.93586498      30241     12:00
14            3              1  0.78947368      35049     18:00
15            3              2  0.92653673      21077     15:00
16            3              3  0.78240741      25201     12:30
17            3              4  0.67702936      20613     15:30
18            3              5  0.79058824      38217     15:30
19            3              6  0.73416507      39212     19:30
20            4              1  0.68011958      30477     18:00
21            4              2  0.73101266      20241     12:00
22            4              3  0.78539493      26714     12:30
23            4              4  0.68818381      36314     19:00
24            4              5  0.76634214      31073     12:00
25            4              6  0.76619633      22621     12:20
26            4              7  0.83745583      20141     15:30
27            5              1  0.84955534      26017     19:00
28            5              2  0.69892580      30477     15:30
29            5              3  0.28565683      32177     19:00
30            5              4  0.82361005      20277     12:30
31            5              5  0.84183364      35493     12:20
32            5              6  0.76399322      20782     12:30
33            6              1  0.79851028      38313     18:00
34            6              2  0.86444975      22610     20:00
35            6              3  0.81692195      21741     12:30
36            6              4  0.79744735      40004     19:30
37            6              5  0.80054485      16286     16:00
38            6              6  0.69823789      15913     15:30
39            1              1  0.22668452     110815     12:00
40            1              2  0.22724735     109432     15:30
41            1              3  0.27982408     111428     15:30
42            1              4  0.20168067     111518     12:00
43            1              5  0.19452391     111609     15:30
44            1              6  0.16226979     111347     12:10
45            1              1  0.20416814     104968     12:00
46            1              2  0.14190507     106387     12:00
47            1              3  0.22660885     105514     15:30
48            1              4  0.13633213     109316     20:00
49            1              5  0.17337627     104488     12:00
50            1              6  0.13425000     107981     15:30
51            1              7  0.12309608     110033     15:30
52            1              8  0.14648760     107379     12:00
53            2              1  0.13005902     101213     12:00
54            2              2  0.17207665     100610     12:00
55            2              3  0.22771588     104840     15:30
56            2              4  0.19871122     107638     12:00
57            2              5  0.15857571     108539     20:00
58            2              6  0.17650602     104147     15:30
59            2              7  0.20653477     102649     12:00
60            1              1  0.08315098      51424     19:30
61            1              2  0.06550388      39100     19:30
62            1              3  0.14443885      51424     19:30
63            1              4  0.18003565      50846     19:30
64            1              5  0.10875650      48602     16:30
65            1              6  0.11517672      51424     19:30
66            2              1  0.12537092      46147     18:00
67            2              2  0.19192358      48763     17:00
68            2              3  0.30943026      33529     19:30
69            2              4  0.24571429      44535     12:00
70            2              5  0.28810573      38813     12:00
71            2              6  0.14048780      36171     17:00
72            2              7  0.12976070      51424     16:30
73            3              1  0.29346388      48042     19:30
74            3              2  0.41507510      44422     13:00
75            3              3  0.48589147      48559     20:00
76            3              4  0.56826568      44559     19:30
77            3              5  0.42449726      51424     17:00
78            3              6  0.40105715      47352     17:00
79            4              1  0.57912746      40913     18:00
80            4              2  0.29139073      42856     17:30
81            4              3  0.46209386      31772     11:00
82            4              4  0.65279770      37244     19:30
83            4              5  0.51059322      39596     16:00
84            4              6  0.43333333      34671     18:00
85            5              1  0.42704626      37179     13:00
86            5              2  0.45263158      39249     16:00
87            5              3  0.58174905      33225     19:30
88            5              4  0.41216216      31464     18:00
89            5              5  0.44992526      31711     12:30
90            5              6  0.50000000      48904     13:00
91            5              7  0.44674086      37391     13:00
92            1              1  0.42931937      43500     13:30
93            1              2  0.42303173      46250     18:00
94            1              3  0.44303797      49000     13:30
95            1              4  0.43637847      60000     18:00
96            1              5  0.44019139      58000     19:00
97            1              6  0.40165441      58000     12:00
98            1              1  0.73089564      79809     20:00
99            1              2  0.74991027      72422     17:00
100           1              3  0.85296641      78306     17:00
101           1              4  0.83716421      63623     18:00
102           1              5  0.63879480      73435     16:30
103           1              6  0.78256829      76309     19:30
104           1              7  0.89491992      83602     12:30
105           5              1  0.84638301      48746     19:30
106           5              2  0.83367456      49835     19:30
107           5              3  0.89519024      45218     12:30
108           5              4  0.90120746      43181     18:30
109           5              5  0.92817982      49922     17:00
110           5              6  0.93120393      56710     12:30
111           6              1  0.79287216      54130     09:00
112           6              2  0.66666667      50775     16:30
113           6              3  0.82990991      45928     17:00
114           1              1  0.10252193      71125     13:00
115           1              2  0.11477411      71178     13:00
116           1              3  0.10577390      71875     12:30
117           1              4  0.10441767      70149     12:30
118           1              5  0.14401914      72015     12:30
119           1              6  0.10453118      72450     19:00
120           1              7  0.12658782      74549     15:30
121           2              1  0.15600394      65345     14:30
122           2              2  0.14525433      65235     16:00
123           2              3  0.23240833      65816     12:30
124           2              4  0.12817148      65351     12:30
125           2              5  0.14147910      63225     12:30
126           2              6  0.18232891      65451     12:30
127           3              1  0.14491844      57775     12:30
128           3              2  0.18322763      61183     12:30
129           3              3  0.18818565      71473     12:30
130           3              4  0.17925793      64096     12:30
131           3              5  0.16376663      60717     15:30
132           3              6  0.20824216      70713     12:15
133           4              1  0.23236741      52256     12:30
134           4              2  0.28983764      57012     12:30
135           4              3  0.29229963      58255     12:30
136           4              4  0.27884615      62656     15:30
137           4              5  0.30752334      58822     16:00
138           4              6  0.27132262      55896     12:30
139           5              1  0.29963009      70045     12:30
140           5              2  0.28233749      74927     12:30
141           5              3  0.27479407      68654     17:00
142           5              4  0.26198565      66481     16:30
143           5              5  0.26469160      61124     12:00
144           5              6  0.26849894      60005     12:30
145           5              7  0.22701504      72888     16:00
    Game result (Win=1; Loss=0) Athletic Dept Profit
1                             1                    0
2                             1                    0
3                             1                    0
4                             1                    0
5                             0                    0
6                             0                    0
7                             1                    0
8                             1                    0
9                             0                    0
10                            1                    0
11                            1                    0
12                            0                    0
13                            0                    0
14                            1                    0
15                            0                    0
16                            0                    0
17                            1                    0
18                            0                    0
19                            1                    0
20                            1                    0
21                            1                    0
22                            1                    0
23                            0                    0
24                            0                    0
25                            0                    0
26                            1                    0
27                            1                    0
28                            1                    0
29                            0                    0
30                            0                    0
31                            1                    0
32                            0                    0
33                            1                    0
34                            0                    0
35                            1                    0
36                            0                    0
37                            0                    0
38                            1                    0
39                            1                    0
40                            1                    0
41                            1                    0
42                            1                    0
43                            1                    0
44                            1                    0
45                            1                    0
46                            1                    0
47                            1                    0
48                            0                    0
49                            1                    0
50                            1                    0
51                            0                    0
52                            1                    0
53                            1                    0
54                            1                    0
55                            1                    0
56                            0                    0
57                            1                    0
58                            1                    0
59                            0                    0
60                            1                    0
61                            1                    0
62                            1                    0
63                            1                    0
64                            0                    0
65                            1                    0
66                            1                    0
67                            1                    0
68                            0                    0
69                            0                    0
70                            1                    0
71                            1                    0
72                            1                    0
73                            1                    0
74                            1                    0
75                            1                    0
76                            1                    0
77                            1                    0
78                            1                    0
79                            1                    0
80                            1                    0
81                            1                    0
82                            0                    0
83                            0                    0
84                            1                    0
85                            1                    0
86                            0                    0
87                            1                    0
88                            0                    0
89                            1                    0
90                            0                    0
91                            0                    0
92                            1                    0
93                            1                    0
94                            0                    0
95                            1                    0
96                            1                    0
97                            0                    0
98                            1                    0
99                            1                    0
100                           0                    0
101                           0                    0
102                           1                    0
103                           1                    0
104                           1                    0
105                           1                    0
106                           1                    0
107                           1                    0
108                           1                    0
109                           0                    0
110                           1                    0
111                           1                    0
112                           1                    0
113                           0                    0
114                           1                    0
115                           1                    0
116                           1                    0
117                           0                    0
118                           0                    0
119                           1                    0
120                           1                    0
121                           0                    0
122                           0                    0
123                           1                    0
124                           0                    0
125                           0                    0
126                           0                    0
127                           0                    0
128                           1                    0
129                           0                    0
130                           0                    0
131                           0                    0
132                           0                    0
133                           1                    0
134                           1                    0
135                           1                    0
136                           0                    0
137                           0                    0
138                           0                    0
139                           1                    0
140                           0                    0
141                           0                    0
142                           0                    0
143                           0                    0
144                           1                    0
145                           0                    0
    Athletic Dept Total Expenses Athletic Dept Total Revenues
1                             NA                           NA
2                             NA                           NA
3                             NA                           NA
4                             NA                           NA
5                             NA                           NA
6                             NA                           NA
7                             NA                           NA
8                             NA                           NA
9                             NA                           NA
10                            NA                           NA
11                            NA                           NA
12                            NA                           NA
13                            NA                           NA
14                            NA                           NA
15                            NA                           NA
16                            NA                           NA
17                            NA                           NA
18                            NA                           NA
19                            NA                           NA
20                            NA                           NA
21                            NA                           NA
22                            NA                           NA
23                            NA                           NA
24                            NA                           NA
25                            NA                           NA
26                            NA                           NA
27                            NA                           NA
28                            NA                           NA
29                            NA                           NA
30                            NA                           NA
31                            NA                           NA
32                            NA                           NA
33                            NA                           NA
34                            NA                           NA
35                            NA                           NA
36                            NA                           NA
37                            NA                           NA
38                            NA                           NA
39                            NA                           NA
40                            NA                           NA
41                            NA                           NA
42                            NA                           NA
43                            NA                           NA
44                            NA                           NA
45                            NA                           NA
46                            NA                           NA
47                            NA                           NA
48                            NA                           NA
49                            NA                           NA
50                            NA                           NA
51                            NA                           NA
52                            NA                           NA
53                            NA                           NA
54                            NA                           NA
55                            NA                           NA
56                            NA                           NA
57                            NA                           NA
58                            NA                           NA
59                            NA                           NA
60                            NA                           NA
61                            NA                           NA
62                            NA                           NA
63                            NA                           NA
64                            NA                           NA
65                            NA                           NA
66                            NA                           NA
67                            NA                           NA
68                            NA                           NA
69                            NA                           NA
70                            NA                           NA
71                            NA                           NA
72                            NA                           NA
73                            NA                           NA
74                            NA                           NA
75                            NA                           NA
76                            NA                           NA
77                            NA                           NA
78                            NA                           NA
79                            NA                           NA
80                            NA                           NA
81                            NA                           NA
82                            NA                           NA
83                            NA                           NA
84                            NA                           NA
85                            NA                           NA
86                            NA                           NA
87                            NA                           NA
88                            NA                           NA
89                            NA                           NA
90                            NA                           NA
91                            NA                           NA
92                            NA                           NA
93                            NA                           NA
94                            NA                           NA
95                            NA                           NA
96                            NA                           NA
97                            NA                           NA
98                            NA                           NA
99                            NA                           NA
100                           NA                           NA
101                           NA                           NA
102                           NA                           NA
103                           NA                           NA
104                           NA                           NA
105                           NA                           NA
106                           NA                           NA
107                           NA                           NA
108                           NA                           NA
109                           NA                           NA
110                           NA                           NA
111                           NA                           NA
112                           NA                           NA
113                           NA                           NA
114                           NA                           NA
115                           NA                           NA
116                           NA                           NA
117                           NA                           NA
118                           NA                           NA
119                           NA                           NA
120                           NA                           NA
121                           NA                           NA
122                           NA                           NA
123                           NA                           NA
124                           NA                           NA
125                           NA                           NA
126                           NA                           NA
127                           NA                           NA
128                           NA                           NA
129                           NA                           NA
130                           NA                           NA
131                           NA                           NA
132                           NA                           NA
133                           NA                           NA
134                           NA                           NA
135                           NA                           NA
136                           NA                           NA
137                           NA                           NA
138                           NA                           NA
139                           NA                           NA
140                           NA                           NA
141                           NA                           NA
142                           NA                           NA
143                           NA                           NA
144                           NA                           NA
145                           NA                           NA

Athletic Dept Total Revenues

Athletic_Dept_Total_Revenues_Missing <- subset(data_clean, is.na(`Athletic Dept Total Revenues`))
print.data.frame (Athletic_Dept_Total_Revenues_Missing)

    Conference     School Area Classification (0-Rural; 1-Urban) Year
1          ACC       Duke                                      1 2014
2          ACC       Duke                                      1 2014
3          ACC       Duke                                      1 2014
4          ACC       Duke                                      1 2014
5          ACC       Duke                                      1 2014
6          ACC       Duke                                      1 2014
7          ACC       Duke                                      1 2014
8          ACC       Duke                                      1 2015
9          ACC       Duke                                      1 2015
10         ACC       Duke                                      1 2015
11         ACC       Duke                                      1 2015
12         ACC       Duke                                      1 2015
13         ACC       Duke                                      1 2015
14         ACC       Duke                                      1 2016
15         ACC       Duke                                      1 2016
16         ACC       Duke                                      1 2016
17         ACC       Duke                                      1 2016
18         ACC       Duke                                      1 2016
19         ACC       Duke                                      1 2016
20         ACC       Duke                                      1 2017
21         ACC       Duke                                      1 2017
22         ACC       Duke                                      1 2017
23         ACC       Duke                                      1 2017
24         ACC       Duke                                      1 2017
25         ACC       Duke                                      1 2017
26         ACC       Duke                                      1 2017
27         ACC       Duke                                      1 2018
28         ACC       Duke                                      1 2018
29         ACC       Duke                                      1 2018
30         ACC       Duke                                      1 2018
31         ACC       Duke                                      1 2018
32         ACC       Duke                                      1 2018
33         ACC       Duke                                      1 2019
34         ACC       Duke                                      1 2019
35         ACC       Duke                                      1 2019
36         ACC       Duke                                      1 2019
37         ACC       Duke                                      1 2019
38         ACC       Duke                                      1 2019
39       Big10   Michigan                                      1 2004
40       Big10   Michigan                                      1 2004
41       Big10   Michigan                                      1 2004
42       Big10   Michigan                                      1 2004
43       Big10   Michigan                                      1 2004
44       Big10   Michigan                                      1 2004
45       Big10 Penn State                                      1 2009
46       Big10 Penn State                                      1 2009
47       Big10 Penn State                                      1 2009
48       Big10 Penn State                                      1 2009
49       Big10 Penn State                                      1 2009
50       Big10 Penn State                                      1 2009
51       Big10 Penn State                                      1 2009
52       Big10 Penn State                                      1 2009
53       Big10 Penn State                                      1 2010
54       Big10 Penn State                                      1 2010
55       Big10 Penn State                                      1 2010
56       Big10 Penn State                                      1 2010
57       Big10 Penn State                                      1 2010
58       Big10 Penn State                                      1 2010
59       Big10 Penn State                                      1 2010
60       Pac12   Stanford                                      0 2015
61       Pac12   Stanford                                      0 2015
62       Pac12   Stanford                                      0 2015
63       Pac12   Stanford                                      0 2015
64       Pac12   Stanford                                      0 2015
65       Pac12   Stanford                                      0 2015
66       Pac12   Stanford                                      0 2016
67       Pac12   Stanford                                      0 2016
68       Pac12   Stanford                                      0 2016
69       Pac12   Stanford                                      0 2016
70       Pac12   Stanford                                      0 2016
71       Pac12   Stanford                                      0 2016
72       Pac12   Stanford                                      0 2015
73       Pac12   Stanford                                      0 2017
74       Pac12   Stanford                                      0 2017
75       Pac12   Stanford                                      0 2017
76       Pac12   Stanford                                      0 2017
77       Pac12   Stanford                                      0 2017
78       Pac12   Stanford                                      0 2017
79       Pac12   Stanford                                      0 2018
80       Pac12   Stanford                                      0 2018
81       Pac12   Stanford                                      0 2018
82       Pac12   Stanford                                      0 2018
83       Pac12   Stanford                                      0 2018
84       Pac12   Stanford                                      0 2018
85       Pac12   Stanford                                      0 2019
86       Pac12   Stanford                                      0 2019
87       Pac12   Stanford                                      0 2019
88       Pac12   Stanford                                      0 2019
89       Pac12   Stanford                                      0 2019
90       Pac12   Stanford                                      0 2019
91       Pac12   Stanford                                      0 2019
92         ACC        UNC                                      1 2004
93         ACC        UNC                                      1 2004
94         ACC        UNC                                      1 2004
95         ACC        UNC                                      1 2004
96         ACC        UNC                                      1 2004
97         ACC        UNC                                      1 2004
98       Pac12        USC                                      1 2015
99       Pac12        USC                                      1 2015
100      Pac12        USC                                      1 2015
101      Pac12        USC                                      1 2015
102      Pac12        USC                                      1 2015
103      Pac12        USC                                      1 2015
104      Pac12        USC                                      1 2015
105      Pac12        USC                                      1 2019
106      Pac12        USC                                      1 2019
107      Pac12        USC                                      1 2019
108      Pac12        USC                                      1 2019
109      Pac12        USC                                      1 2019
110      Pac12        USC                                      1 2019
111      Pac12        USC                                      1 2020
112      Pac12        USC                                      1 2020
113      Pac12        USC                                      1 2020
114      Pac12 Washington                                      1 2003
115      Pac12 Washington                                      1 2003
116      Pac12 Washington                                      1 2003
117      Pac12 Washington                                      1 2003
118      Pac12 Washington                                      1 2003
119      Pac12 Washington                                      1 2003
120      Pac12 Washington                                      1 2003
121      Pac12 Washington                                      1 2004
122      Pac12 Washington                                      1 2004
123      Pac12 Washington                                      1 2004
124      Pac12 Washington                                      1 2004
125      Pac12 Washington                                      1 2004
126      Pac12 Washington                                      1 2004
127      Pac12 Washington                                      1 2005
128      Pac12 Washington                                      1 2005
129      Pac12 Washington                                      1 2005
130      Pac12 Washington                                      1 2005
131      Pac12 Washington                                      1 2005
132      Pac12 Washington                                      1 2005
133      Pac12 Washington                                      1 2006
134      Pac12 Washington                                      1 2006
135      Pac12 Washington                                      1 2006
136      Pac12 Washington                                      1 2006
137      Pac12 Washington                                      1 2006
138      Pac12 Washington                                      1 2006
139      Pac12 Washington                                      1 2007
140      Pac12 Washington                                      1 2007
141      Pac12 Washington                                      1 2007
142      Pac12 Washington                                      1 2007
143      Pac12 Washington                                      1 2007
144      Pac12 Washington                                      1 2007
145      Pac12 Washington                                      1 2007
    Tenure Year In-Season_Game S_Diversion Attendance Game Time
1             1              1  0.45965770      31213     18:00
2             1              2  0.55328798      25203     15:00
3             1              3  0.38927098      20197     12:30
4             1              4  0.44155844      28131     12:30
5             1              5  0.44279661      30107     12:00
6             1              6  0.65346535      33941     19:30
7             1              7  0.41448382      22246     19:00
8             2              1  0.35403727      33941     18:00
9             2              2  0.23130435      24127     12:30
10            2              3  0.45177665      20101     12:00
11            2              4  0.47011309      20009     15:00
12            2              5  0.71062547      30143     19:00
13            2              6  0.93586498      30241     12:00
14            3              1  0.78947368      35049     18:00
15            3              2  0.92653673      21077     15:00
16            3              3  0.78240741      25201     12:30
17            3              4  0.67702936      20613     15:30
18            3              5  0.79058824      38217     15:30
19            3              6  0.73416507      39212     19:30
20            4              1  0.68011958      30477     18:00
21            4              2  0.73101266      20241     12:00
22            4              3  0.78539493      26714     12:30
23            4              4  0.68818381      36314     19:00
24            4              5  0.76634214      31073     12:00
25            4              6  0.76619633      22621     12:20
26            4              7  0.83745583      20141     15:30
27            5              1  0.84955534      26017     19:00
28            5              2  0.69892580      30477     15:30
29            5              3  0.28565683      32177     19:00
30            5              4  0.82361005      20277     12:30
31            5              5  0.84183364      35493     12:20
32            5              6  0.76399322      20782     12:30
33            6              1  0.79851028      38313     18:00
34            6              2  0.86444975      22610     20:00
35            6              3  0.81692195      21741     12:30
36            6              4  0.79744735      40004     19:30
37            6              5  0.80054485      16286     16:00
38            6              6  0.69823789      15913     15:30
39            1              1  0.22668452     110815     12:00
40            1              2  0.22724735     109432     15:30
41            1              3  0.27982408     111428     15:30
42            1              4  0.20168067     111518     12:00
43            1              5  0.19452391     111609     15:30
44            1              6  0.16226979     111347     12:10
45            1              1  0.20416814     104968     12:00
46            1              2  0.14190507     106387     12:00
47            1              3  0.22660885     105514     15:30
48            1              4  0.13633213     109316     20:00
49            1              5  0.17337627     104488     12:00
50            1              6  0.13425000     107981     15:30
51            1              7  0.12309608     110033     15:30
52            1              8  0.14648760     107379     12:00
53            2              1  0.13005902     101213     12:00
54            2              2  0.17207665     100610     12:00
55            2              3  0.22771588     104840     15:30
56            2              4  0.19871122     107638     12:00
57            2              5  0.15857571     108539     20:00
58            2              6  0.17650602     104147     15:30
59            2              7  0.20653477     102649     12:00
60            1              1  0.08315098      51424     19:30
61            1              2  0.06550388      39100     19:30
62            1              3  0.14443885      51424     19:30
63            1              4  0.18003565      50846     19:30
64            1              5  0.10875650      48602     16:30
65            1              6  0.11517672      51424     19:30
66            2              1  0.12537092      46147     18:00
67            2              2  0.19192358      48763     17:00
68            2              3  0.30943026      33529     19:30
69            2              4  0.24571429      44535     12:00
70            2              5  0.28810573      38813     12:00
71            2              6  0.14048780      36171     17:00
72            2              7  0.12976070      51424     16:30
73            3              1  0.29346388      48042     19:30
74            3              2  0.41507510      44422     13:00
75            3              3  0.48589147      48559     20:00
76            3              4  0.56826568      44559     19:30
77            3              5  0.42449726      51424     17:00
78            3              6  0.40105715      47352     17:00
79            4              1  0.57912746      40913     18:00
80            4              2  0.29139073      42856     17:30
81            4              3  0.46209386      31772     11:00
82            4              4  0.65279770      37244     19:30
83            4              5  0.51059322      39596     16:00
84            4              6  0.43333333      34671     18:00
85            5              1  0.42704626      37179     13:00
86            5              2  0.45263158      39249     16:00
87            5              3  0.58174905      33225     19:30
88            5              4  0.41216216      31464     18:00
89            5              5  0.44992526      31711     12:30
90            5              6  0.50000000      48904     13:00
91            5              7  0.44674086      37391     13:00
92            1              1  0.42931937      43500     13:30
93            1              2  0.42303173      46250     18:00
94            1              3  0.44303797      49000     13:30
95            1              4  0.43637847      60000     18:00
96            1              5  0.44019139      58000     19:00
97            1              6  0.40165441      58000     12:00
98            1              1  0.73089564      79809     20:00
99            1              2  0.74991027      72422     17:00
100           1              3  0.85296641      78306     17:00
101           1              4  0.83716421      63623     18:00
102           1              5  0.63879480      73435     16:30
103           1              6  0.78256829      76309     19:30
104           1              7  0.89491992      83602     12:30
105           5              1  0.84638301      48746     19:30
106           5              2  0.83367456      49835     19:30
107           5              3  0.89519024      45218     12:30
108           5              4  0.90120746      43181     18:30
109           5              5  0.92817982      49922     17:00
110           5              6  0.93120393      56710     12:30
111           6              1  0.79287216      54130     09:00
112           6              2  0.66666667      50775     16:30
113           6              3  0.82990991      45928     17:00
114           1              1  0.10252193      71125     13:00
115           1              2  0.11477411      71178     13:00
116           1              3  0.10577390      71875     12:30
117           1              4  0.10441767      70149     12:30
118           1              5  0.14401914      72015     12:30
119           1              6  0.10453118      72450     19:00
120           1              7  0.12658782      74549     15:30
121           2              1  0.15600394      65345     14:30
122           2              2  0.14525433      65235     16:00
123           2              3  0.23240833      65816     12:30
124           2              4  0.12817148      65351     12:30
125           2              5  0.14147910      63225     12:30
126           2              6  0.18232891      65451     12:30
127           3              1  0.14491844      57775     12:30
128           3              2  0.18322763      61183     12:30
129           3              3  0.18818565      71473     12:30
130           3              4  0.17925793      64096     12:30
131           3              5  0.16376663      60717     15:30
132           3              6  0.20824216      70713     12:15
133           4              1  0.23236741      52256     12:30
134           4              2  0.28983764      57012     12:30
135           4              3  0.29229963      58255     12:30
136           4              4  0.27884615      62656     15:30
137           4              5  0.30752334      58822     16:00
138           4              6  0.27132262      55896     12:30
139           5              1  0.29963009      70045     12:30
140           5              2  0.28233749      74927     12:30
141           5              3  0.27479407      68654     17:00
142           5              4  0.26198565      66481     16:30
143           5              5  0.26469160      61124     12:00
144           5              6  0.26849894      60005     12:30
145           5              7  0.22701504      72888     16:00
    Game result (Win=1; Loss=0) Athletic Dept Profit
1                             1                    0
2                             1                    0
3                             1                    0
4                             1                    0
5                             0                    0
6                             0                    0
7                             1                    0
8                             1                    0
9                             0                    0
10                            1                    0
11                            1                    0
12                            0                    0
13                            0                    0
14                            1                    0
15                            0                    0
16                            0                    0
17                            1                    0
18                            0                    0
19                            1                    0
20                            1                    0
21                            1                    0
22                            1                    0
23                            0                    0
24                            0                    0
25                            0                    0
26                            1                    0
27                            1                    0
28                            1                    0
29                            0                    0
30                            0                    0
31                            1                    0
32                            0                    0
33                            1                    0
34                            0                    0
35                            1                    0
36                            0                    0
37                            0                    0
38                            1                    0
39                            1                    0
40                            1                    0
41                            1                    0
42                            1                    0
43                            1                    0
44                            1                    0
45                            1                    0
46                            1                    0
47                            1                    0
48                            0                    0
49                            1                    0
50                            1                    0
51                            0                    0
52                            1                    0
53                            1                    0
54                            1                    0
55                            1                    0
56                            0                    0
57                            1                    0
58                            1                    0
59                            0                    0
60                            1                    0
61                            1                    0
62                            1                    0
63                            1                    0
64                            0                    0
65                            1                    0
66                            1                    0
67                            1                    0
68                            0                    0
69                            0                    0
70                            1                    0
71                            1                    0
72                            1                    0
73                            1                    0
74                            1                    0
75                            1                    0
76                            1                    0
77                            1                    0
78                            1                    0
79                            1                    0
80                            1                    0
81                            1                    0
82                            0                    0
83                            0                    0
84                            1                    0
85                            1                    0
86                            0                    0
87                            1                    0
88                            0                    0
89                            1                    0
90                            0                    0
91                            0                    0
92                            1                    0
93                            1                    0
94                            0                    0
95                            1                    0
96                            1                    0
97                            0                    0
98                            1                    0
99                            1                    0
100                           0                    0
101                           0                    0
102                           1                    0
103                           1                    0
104                           1                    0
105                           1                    0
106                           1                    0
107                           1                    0
108                           1                    0
109                           0                    0
110                           1                    0
111                           1                    0
112                           1                    0
113                           0                    0
114                           1                    0
115                           1                    0
116                           1                    0
117                           0                    0
118                           0                    0
119                           1                    0
120                           1                    0
121                           0                    0
122                           0                    0
123                           1                    0
124                           0                    0
125                           0                    0
126                           0                    0
127                           0                    0
128                           1                    0
129                           0                    0
130                           0                    0
131                           0                    0
132                           0                    0
133                           1                    0
134                           1                    0
135                           1                    0
136                           0                    0
137                           0                    0
138                           0                    0
139                           1                    0
140                           0                    0
141                           0                    0
142                           0                    0
143                           0                    0
144                           1                    0
145                           0                    0
    Athletic Dept Total Expenses Athletic Dept Total Revenues
1                             NA                           NA
2                             NA                           NA
3                             NA                           NA
4                             NA                           NA
5                             NA                           NA
6                             NA                           NA
7                             NA                           NA
8                             NA                           NA
9                             NA                           NA
10                            NA                           NA
11                            NA                           NA
12                            NA                           NA
13                            NA                           NA
14                            NA                           NA
15                            NA                           NA
16                            NA                           NA
17                            NA                           NA
18                            NA                           NA
19                            NA                           NA
20                            NA                           NA
21                            NA                           NA
22                            NA                           NA
23                            NA                           NA
24                            NA                           NA
25                            NA                           NA
26                            NA                           NA
27                            NA                           NA
28                            NA                           NA
29                            NA                           NA
30                            NA                           NA
31                            NA                           NA
32                            NA                           NA
33                            NA                           NA
34                            NA                           NA
35                            NA                           NA
36                            NA                           NA
37                            NA                           NA
38                            NA                           NA
39                            NA                           NA
40                            NA                           NA
41                            NA                           NA
42                            NA                           NA
43                            NA                           NA
44                            NA                           NA
45                            NA                           NA
46                            NA                           NA
47                            NA                           NA
48                            NA                           NA
49                            NA                           NA
50                            NA                           NA
51                            NA                           NA
52                            NA                           NA
53                            NA                           NA
54                            NA                           NA
55                            NA                           NA
56                            NA                           NA
57                            NA                           NA
58                            NA                           NA
59                            NA                           NA
60                            NA                           NA
61                            NA                           NA
62                            NA                           NA
63                            NA                           NA
64                            NA                           NA
65                            NA                           NA
66                            NA                           NA
67                            NA                           NA
68                            NA                           NA
69                            NA                           NA
70                            NA                           NA
71                            NA                           NA
72                            NA                           NA
73                            NA                           NA
74                            NA                           NA
75                            NA                           NA
76                            NA                           NA
77                            NA                           NA
78                            NA                           NA
79                            NA                           NA
80                            NA                           NA
81                            NA                           NA
82                            NA                           NA
83                            NA                           NA
84                            NA                           NA
85                            NA                           NA
86                            NA                           NA
87                            NA                           NA
88                            NA                           NA
89                            NA                           NA
90                            NA                           NA
91                            NA                           NA
92                            NA                           NA
93                            NA                           NA
94                            NA                           NA
95                            NA                           NA
96                            NA                           NA
97                            NA                           NA
98                            NA                           NA
99                            NA                           NA
100                           NA                           NA
101                           NA                           NA
102                           NA                           NA
103                           NA                           NA
104                           NA                           NA
105                           NA                           NA
106                           NA                           NA
107                           NA                           NA
108                           NA                           NA
109                           NA                           NA
110                           NA                           NA
111                           NA                           NA
112                           NA                           NA
113                           NA                           NA
114                           NA                           NA
115                           NA                           NA
116                           NA                           NA
117                           NA                           NA
118                           NA                           NA
119                           NA                           NA
120                           NA                           NA
121                           NA                           NA
122                           NA                           NA
123                           NA                           NA
124                           NA                           NA
125                           NA                           NA
126                           NA                           NA
127                           NA                           NA
128                           NA                           NA
129                           NA                           NA
130                           NA                           NA
131                           NA                           NA
132                           NA                           NA
133                           NA                           NA
134                           NA                           NA
135                           NA                           NA
136                           NA                           NA
137                           NA                           NA
138                           NA                           NA
139                           NA                           NA
140                           NA                           NA
141                           NA                           NA
142                           NA                           NA
143                           NA                           NA
144                           NA                           NA
145                           NA                           NA

More detail Analysis

Character Variables

Conference

frequency_table_conference <- table(data_clean$Conference) %>% data.frame()
frequency_table_conference

   Var1 Freq
1   ACC  230
2 Big10  594
3 Big12   77
4 Pac12  221
5   SEC  269

ggplot(frequency_table_conference, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for Conference Categories",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(hjust = 1, size = 8))

School

frequency_table_school <- table(data_clean$School) %>% data.frame()
frequency_table_school

                  Var1 Freq
1        Arizona State   33
2             Arkansas    6
3               Auburn   36
4              Clemson   28
5  Colorado University   59
6                 Duke   38
7              Florida   43
8              Georgia   36
9         Georgia Tech   33
10            Illinois   28
11                Iowa   16
12            Kentucky   34
13                 LSU   37
14            Maryland   29
15            Michigan  143
16      Michigan State   21
17           Minnesota   42
18            NC State   31
19          Ohio State  123
20            Oklahoma   23
21          Penn State   82
22              Purdue   55
23            Stanford   32
24           Tennessee   77
25                UCLA    7
26                 UNC  100
27             UoTexas   54
28                 USC   16
29          Washington   32
30    Washington State   42
31           Wisconsin   55

ggplot(frequency_table_school, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for School Categories",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(angle = 90, hjust = 1, size = 8))

Area Classification (0-Rural; 1-Urban)

frequency_table_Area_Classification <- table(data_clean$`Area Classification (0-Rural; 1-Urban)`) %>% data.frame()
frequency_table_Area_Classification

  Var1 Freq
1    0  149
2    1 1221

ggplot(frequency_table_Area_Classification, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for Area Classification (0-Rural; 1-Urban)",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(hjust = 1, size = 8))

Game time

frequency_table_game_time <- table(data_clean$`Game Time`) %>% data.frame()
frequency_table_game_time

    Var1 Freq
1  09:00    1
2  10:00    2
3  11:00   58
4  11:05    2
5  11:30    7
6  12:00  357
7  12:05    1
8  12:10    2
9  12:15    1
10 12:20   17
11 12:30   71
12 12:45    1
13 13:00   17
14 13:20    1
15 13:30   16
16 13:45    1
17 14:00    8
18 14:30   52
19 14:35    3
20 14:40    1
21 15:00   24
22 15:15    1
23 15:30  248
24 15:41    1
25 15:45    3
26 16:00   52
27 16:05    1
28 16:15    1
29 16:20    1
30 16:30   12
31 17:00   21
32 17:30    8
33 17:40    1
34 17:51    1
35 18:00   55
36 18:02    1
37 18:05    1
38 18:06    1
39 18:15    1
40 18:30   18
41 18:40    1
42 18:45    1
43 18:50    2
44 19:00  101
45 19:15    3
46 19:30  131
47 19:45    9
48 19:49    1
49 20:00   62
50 20:10    1
51 20:20    2
52 20:30    2
53 21:00    3
54 21:15    1

ggplot(frequency_table_game_time, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for Categories",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(angle = 90, hjust = 1, size = 8))

Numerical Variables

Year

hist(data_clean$Year, main = "Histogram of Year", xlab = "Variable Value", ylab = "Frequency" )

frequency_table_year <- table(data_clean$Year) %>% data.frame()
frequency_table_year

   Var1 Freq
1  2003    7
2  2004   18
3  2005   19
4  2006   35
5  2007   35
6  2008   29
7  2009   43
8  2010   27
9  2011   28
10 2012   53
11 2013   58
12 2014   78
13 2015  134
14 2016  144
15 2017  149
16 2018  155
17 2019  138
18 2020   17
19 2021   31
20 2022   37
21 2023   33
22 2024   39

ggplot(frequency_table_year, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for Bar Plot of Year",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(angle = 90, hjust = 1, size = 8))

Tenure Year

hist(data_clean$`Tenure Year`, main = "Barplot for Tenure Year", xlab = "Categories", ylab = "Frequency")

frequency_table_Tenure_Year <-table(data_clean$`Tenure Year`) %>% as.data.frame()

frequency_table_Tenure_Year

   Var1 Freq
1     1  197
2     2  172
3     3  169
4     4  160
5     5  137
6     6   88
7     7   65
8     8   54
9     9   44
10   10   47
11   11   46
12   12   40
13   13   42
14   14   30
15   15   25
16   16   24
17   17   19
18   18   17
19   19    7
20   20    8

ggplot(frequency_table_Tenure_Year, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for Tenure Year",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(hjust = 1, size = 8))

In-Season_Game

hist(data_clean$`In-Season_Game`, main = "Barplot for In-Season_Game",  xlab = "Categories", ylab = "Frequency")

frequency_table_In_Season_Game  <- table(data_clean$`In-Season_Game`) %>% data.frame()
frequency_table_In_Season_Game 

  Var1 Freq
1    1  209
2    2  212
3    3  210
4    4  206
5    5  204
6    6  199
7    7  131
8    8   19
9    9    1

ggplot(frequency_table_In_Season_Game, aes(x = Var1, y = Freq)) +
  geom_bar(stat = "identity", fill = "black") +
  labs(title = "Barplot for In-Season_Game",
       x = "Categories",
       y = "Frequency") +
  theme_classic()+
  theme(axis.text.x = element_text(hjust = 1, size = 8))

Stadium Waste Diversion

hist(data_clean$S_Diversion, xlab="Variable Value", ylab ="Frequency",main = "Histogram of Stadium Waste Diversion" )

ggplot(data = data_clean, aes(x =S_Diversion)) +
geom_histogram(bins = 100, fill = "black", color = "black") +
          labs(title = "Histogram of Stadium Waste Diversion", x = "Variable Value", y = "Frequency")+
  theme_classic()

frequency_table_S_Diversion <- table(data_clean$S_Diversion) %>%data_frame()

Warning: `data_frame()` was deprecated in tibble 1.1.0.
ℹ Please use `tibble()` instead.

frequency_table_S_Diversion

# A tibble: 1,301 × 1
   .          
   <table[1d]>
 1 27         
 2  1         
 3  1         
 4  1         
 5  1         
 6  1         
 7  1         
 8  1         
 9  1         
10  1         
# ℹ 1,291 more rows

There are 27 observations equal to 0.

ggplot(data = data_clean, aes(x =S_Diversion)) +
geom_histogram(bins = 100, fill = "black", color = "black") +
          labs(title = "Histogram of Stadium Waste Diversion", x = "Variable Value", y = "Frequency")+
  theme_classic()+scale_x_continuous(limits = c(0,1) )

Warning: Removed 2 rows containing missing values or values outside the scale range
(`geom_bar()`).

Attendance

hist(data_clean$Attendance, main = "Histogram of Attendance", xlab = "Variable Value", ylab = "Frequency")

Athletic Dept Profit

options(scipen = 999)

hist(data_clean$`Athletic Dept Profit`, main = "Histogram of Athletic Dept Profit", xlab = "Variable Value", ylab = "Frequency")

Athletic Dept Total Expenses

hist(data_clean$`Athletic Dept Total Expenses`, main = "Athletic Dept Total Expenses", xlab = "Variable Value", ylab = "Frequency")

Athletic Dept Total Revenues

hist(data_clean$`Athletic Dept Total Revenues`, main = "Athletic Dept Total Revenues", xlab = "Variable Value", ylab = "Frequency")