Homework Case Study (Football Coach Salary):

The reports of Footballscoop released the salaries of university football coaches around the United States. In order to find out whether paying coaches high salaries is worth the cost, a university hired a research consulting team to test this possibility using a football coach salary study. The researchers collected salary data of 105 football coaches across the U.S. Please download the data set (College Football).

Please address the following five questions using the data set (College Football) in your managerial report:

1. Provide the numerical and graphical summaries of the data (e.g., averages, sample size, etc.) using the descriptive statistics technique. Describe the average salary.
2. Use the regression analysis technique to investigate the following hypothesis. After running the regression analysis, discuss what hypothesis is supported using the p-value approach at the alpha criteria of .05.

Ho: Head coach school pay does not positively predict football net revenue.

H1: Head coach school pay positively predicts football net revenue.

1. What conclusion and recommendations can you provide to the university from your analysis of this data set?
2. Provide at least one residual plot and discuss whether the data set should be assumed to be normal, or not normal. (Just check one of the residual plots when conducting the regression analysis technique with Excel)

What would be the ethical implications if researchers were to falsify the results of this data set for his or her benefit? From your opinion, why would falsifying the results of this study be perceived to be an unethical use of statistics? Whom might be harmed by lying with statistics in this casestudy problem? Please Explain

Head Coach	School	Head Coach School Pay	Football Net Revenue
Troy Calhoun	Air Force	882000	3496974
Terry Bowden	Akron	375000	-4780737
Nick Saban	Alabama	5316667	46477215
Garrick McGee	Alabama at Birmingham	550000	233838
Rich Rodriguez	Arizona	1500000	7207358
Todd Graham	Arizona State	3000000	11712728
John L. Smith	Arkansas	850000	37072516
Gus Malzahn	Arkansas State	856210	-842442
Rich Ellerson	Army	600000	5538418
Gene Chizik	Auburn	3500000	37158129
Pete Lembo	Ball State	350000	-3870432
Chris Petersen	Boise State	1956333	-501286
Dave Clawson	Bowling Green	363000	-2514183
Jeff Quinn	Buffalo	325000	-1004353
Jeff Tedford	California	2600000	6930135
George O'Leary	Central Florida	1461646	255675
Dan Enos	Central Michigan	325000	-2993669
Butch Jones	Cincinnati	1769648	2227307
Dabo Swinney	Clemson	2040024	15194253
Jon Embree	Colorado	725000	9646592
Jim McElwain	Colorado State	1350000	-5277746
Paul Pasqualoni	Connecticut	1600000	-372296
Ruffin McNeill	East Carolina	950000	1781200
Ron English	Eastern Michigan	360517	1471139
Will Muschamp	Florida	2474500	46543697
Carl Pelini	Florida Atlantic	450000	1603761
Mario Cristobal	Florida International	522183	533137
Jimbo Fisher	Florida State	2750000	18302871
Tim DeRuyter	Fresno State	650000	3019406
Mark Richt	Georgia	2811340	52851837
Paul Johnson	Georgia Tech	2440700	8233717
Norm Chow	Hawaii	550000	-1176056
Tony Levine	Houston	900000	-148093
Robb Akey	Idaho	375797	-406705
Tim Beckman	Illinois	1600000	14207001
Kevin Wilson	Indiana	1260000	8203947
Kirk Ferentz	Iowa	3835000	23996028
Paul Rhoads	Iowa State	1600000	21862535
Charlie Weis	Kansas	2500000	3669260
Bill Snyder	Kansas State	2200000	10451863
Darrell Hazell	Kent State	300000	-348286
Joker Phillips	Kentucky	1700000	19668166
Sonny Dykes	Louisiana Tech	750000	84013
Mark Hudspeth	Louisiana-Lafayette	800000	0
Todd Berry	Louisiana-Monroe	250000	-182817
Charlie Strong	Louisville	2300000	10076493
Les Miles	LSU	3751000	47017400
Doc Holliday	Marshall	600000	2220520
Randy Edsall	Maryland	1600000	-473482
Charley Molnar	Massachusetts	400625	-3740237
Justin Fuente	Memphis	903285	-4940482
Don Treadwell	Miami Ohio	410000	-12902
Brady Hoke	Michigan	3046120	46748443
Mark Dantonio	Michigan State	1934250	26128925
Rick Stockstill	Middle Tennessee State	601504	302193
Jerry Kill	Minnesota	1200000	13539763
Hugh Freeze	Mississippi	1500000	10356484
Dan Mullen	Mississippi State	2600000	10809960
Gary Pinkel	Missouri	2700000	9709465
Bo Pelini	Nebraska	2875000	34600854
Chris Ault	Nevada	493093	260845
Bobby Hauck	Nevada-Las Vegas	500000	1366291
Bob Davie	New Mexico	760000	-4053312
DeWayne Walker	New Mexico State	382260	-2463021
Larry Fedora	North Carolina	2448605	9409117
Tom O'Brien	North Carolina State	936225	11321587
Dan McCarney	North Texas	545000	-3549655
Dave Doeren	Northern Illinois	420000	-3079315
Pat Fitzgerald	Northwestern	1280751	2589180
Frank Solich	Ohio	500000	841212
Urban Meyer	Ohio State	4250000	40121979
Bob Stoops	Oklahoma	4550000	35709374
Mike Gundy	Oklahoma State	3275000	19426125
Chip Kelly	Oregon	3500000	9353407
Mike Riley	Oregon State	1317847	9408573
Bill O'Brien	Penn State	2300000	43843414
Danny Hope	Purdue	970000	5938670
Kyle Flood	Rutgers	750000	0
Rocky Long	San Diego State	800000	1941400
Mike MacIntyre	San Jose State	401820	-2891811
Joey Jones	South Alabama	345125	760183
Steve Spurrier	South Carolina	3550000	23866530
Skip Holtz	South Florida	2000000	4360300
Ellis Johnson	Southern Mississippi	790000	-1674293
Derek Dooley	Tennessee	2000000	39431691
Mack Brown	Texas	5292500	70885526
Kevin Sumlin	Texas A&M	2436000	29853802
Dennis Franchione	Texas State	360500	-2874069
Tommy Tuberville	Texas Tech	2150000	10464208
Mike Price	Texas-El Paso	359206	2642375
Larry Coker	Texas-San Antonio	350000	-2693969
Matt Campbell	Toledo	360000	-4744485
Larry Blakeney	Troy	455000	1196272
Jim Mora	UCLA	1935000	5104253
Kyle Whittingham	Utah	2000000	8526706
Gary Andersen	Utah State	415000	-1252454
Mike London	Virginia	2552760	36284
Frank Beamer	Virginia Tech	2343000	15074143
Steve Sarkisian	Washington	2425000	18098857
Mike Leach	Washington State	2250000	3548145
Dana Holgorsen	West Virginia	2380000	7825134
Willie Taggart	Western Kentucky	475000	0
Bill Cubit	Western Michigan	377250	-2945344
Bret Bielema	Wisconsin	2600000	19633673
Dave Christensen	Wyoming	1200000	2727070