Question
Homework Case Study (Football Coach Salary) : The reports of Footballscoop released the salaries of university football coaches around the United States. In order to
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:
- Provide the numerical and graphical summaries of the data (e.g., averages, sample size, etc.) using the descriptive statistics technique. Describe the average salary.
- 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.
- What conclusion and recommendations can you provide to the university from your analysis of this data set?
- 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Statistics For Engineers And Scientists
Authors: William Navidi
3rd Edition
9780073376332
