please use phstat from excel ty School Conference Head Coach School Pay Other Pa
ID: 2338871 • Letter: P
Question
please use phstat from excel ty
School Conference Head Coach School Pay Other Pay Total Pay Max Bonus Athletic Department Total Revenue Air Force Mt. West Troy Calhoun 866250 26500 892750 247500 39031348 Akron MAC Terry Bowden 406000 #N/A 406000 255000 27954164 Alabama SEC Nick Saban 6950203 209984 7160187 700000 143776550 Alabama at Birmingham CUSA Bill Clark 500000 #N/A 500000 430000 28159249 Appalachian State Sun Belt Scott Satterfield 225000 #N/A 225000 25000 19775727 Arizona PAC-12 Rich Rodriguez 2898500 400000 3298500 2125000 68510915 Arizona State PAC-12 Todd Graham 2700000 2960 2702960 3491000 65673955 Arkansas SEC Bret Bielema 3200000 14000 3214000 700000 99770840 Arkansas State Sun Belt Blake Anderson 700000 #N/A 700000 235000 16281038 Army Ind. Jeff Monken 834667 #N/A 834667 256000 37289204 Auburn SEC Gus Malzahn 3850000 4500 3854500 1400000 103680609 Ball State MAC Pete Lembo 500000 3500 503500 450000 21315999 Boise State Mt. West Bryan Harsin 1000004 #N/A 1000004 400000 43166257 Bowling Green MAC Dino Babers 405000 0 405000 130000 23611448 Buffalo MAC Jeff Quinn 380210 0 380210 470000 28964050 California PAC-12 Sonny Dykes 1800000 8000 1808000 304000 94487380 Central Florida AAC George O'Leary 1800000 0 1800000 750000 41222301 Central Michigan MAC Dan Enos 360000 0 360000 305000 27680624 Cincinnati AAC Tommy Tuberville 2200000 0 2200000 565000 61915431 Clemson ACC Dabo Swinney 3150000 25100 3175100 1200000 69061398 Colorado PAC-12 Mike MacIntyre 2008500 1650 2010150 1500000 58334345 Colorado State Mt. West Jim McElwain 1500000 #N/A 1500000 150000 34791926 Connecticut AAC Bob Diaco 1500000 #N/A 1500000 450000 63336022 East Carolina AAC Ruffin McNeill 1250000 2500 1252500 550000 35805232 Eastern Michigan MAC Chris Creighton 425000 #N/A 425000 310000 27797656 Florida SEC Will Muschamp 2724500 6500 2731000 454000 130011244 Florida Atlantic CUSA Charlie Partridge 500000 #N/A 500000 100000 24538411 Florida International CUSA Ron Turner 550000 1000 551000 150000 28332261 Florida State ACC Jimbo Fisher 3591667 0 3591667 1275000 91382441 Fresno State Mt. West Tim DeRuyter 1400000 35000 1435000 1685000 33734773 Georgia SEC Mark Richt 3200000 114000 3314000 1000000 98120889 Georgia Southern Sun Belt Willie Fritz 400000 #N/A 400000 42500 13200750 Georgia State Sun Belt Trent Miles 510000 #N/A 510000 381500 26721964 Georgia Tech ACC Paul Johnson 2588000 2500 2590500 1275000 61780812 Hawaii Mt. West Norm Chow 550000 70500 620500 1180000 37017100 Houston AAC Tony Levine 1025000 300 1025300 422500 42024887 Idaho Sun Belt Paul Petrino 400011 0 400011 152000 19593192 Illinois Big Ten Tim Beckman 1950000 250 1950250 80000 79725521 Indiana Big Ten Kevin Wilson 1301644 #N/A 1301644 1130000 76660265 Iowa Big Ten Kirk Ferentz 4075000 0 4075000 1750000 107153782 Iowa State Big 12 Paul Rhoads 1800000 8025 1808025 1050000 62357761 Kansas Big 12 Charlie Weis 2500000 0 2500000 765000 93114168 Kansas State Big 12 Bill Snyder 2900000 0 2900000 580000 70457283 Kent State MAC Paul Haynes 382500 1200 383700 336000 26557674 Kentucky SEC Mark Stoops 2700000 1600 2701600 1475000 95720724 LSU SEC Les Miles 4300000 69582 4369582 700000 117457398 Louisiana Tech CUSA Skip Holtz 500000 10000 510000 295000 18570493 Louisiana-Lafayette Sun Belt Mark Hudspeth 1000000 3156 1003156 155000 18114361 Louisiana-Monroe Sun Belt Todd Berry 357000 1250 358250 47500 11231311 Louisville ACC Bobby Petrino 3000000 #N/A 3000000 1266667 96193330 Marshall CUSA Doc Holliday 607070 2750 609820 115000 27587274 Maryland Big Ten Randy Edsall 2033680 200 2033880 950000 63714470 Massachusetts MAC Mark Whipple 450000 #N/A 450000 200000 30060635 Memphis AAC Justin Fuente 1006779 0 1006779 725000 46346285 Miami (Ohio) MAC Chuck Martin 450000 #N/A 450000 462243 28705691 Michigan Big Ten Brady Hoke 2854000 2000 2856000 575000 143514125 Michigan State Big Ten Mark Dantonio 5611845 24300 5636145 650000 97942726 Middle Tennessee State CUSA Rick Stockstill 801504 1625 803129 126142 27667552 Minnesota Big Ten Jerry Kill 2100000 #N/A 2100000 1150000 98286669 Mississippi SEC Hugh Freeze 3000000 18000 3018000 825000 73390050 Mississippi State SEC Dan Mullen 3000000 0 3000000 710000 62764025 Missouri SEC Gary Pinkel 3400000 0 3400000 1825000 76306889 Nebraska Big Ten Bo Pelini 3077646 #N/A 3077646 1000000 86916001 Nevada Mt. West Brian Polian 575000 0 575000 250000 26627415 Nevada-Las Vegas Mt. West Bobby Hauck 850000 0 850000 285000 64513044 New Mexico Mt. West Bob Davie 772690 11000 783690 480000 44345840 New Mexico State Sun Belt Doug Martin 376044 1000 377044 185000 30105460 North Carolina ACC Larry Fedora 1830000 #N/A 1830000 345835 82792342 North Texas CUSA Dan McCarney 710000 1600 711600 945000 28800436 Northern Illinois MAC Rod Carey 400000 1500 401500 205000 26259284 Northwestern Big Ten Pat Fitzgerald 2480967 #N/A 2480967 #N/A 11767380 Ohio MAC Frank Solich 553000 1500 554500 327000 27265061 Ohio State Big Ten Urban Meyer 4486640 50000 4536640 550000 139639307 Oklahoma Big 12 Bob Stoops 5058333 0 5058333 819500 123805661 Oklahoma State Big 12 Mike Gundy 3500000 #N/A 3500000 550000 93664337 Old Dominion CUSA Bobby Wilder 475000 11010 486010 503333 36929483 Oregon PAC-12 Mark Helfrich 2000000 #N/A 2000000 1135000 115241070 Oregon State PAC-12 Mike Riley 1510008 #N/A 1510008 369000 65467970 Penn State Big Ten James Franklin 4300000 #N/A 4300000 1000000 104751464 Purdue Big Ten Darrell Hazell 2090000 #N/A 2090000 1545000 72379392 Rutgers Big Ten Kyle Flood 975000 12000 987000 350000 78989475 San Diego State Mt. West Rocky Long 800000 2000 802000 855000 39211827 San Jose State Mt. West Ron Caragher 525000 0 525000 195000 25854038 South Alabama Sun Belt Joey Jones 435000 36000 471000 171000 21115562 South Carolina SEC Steve Spurrier 4000000 16900 4016900 1700000 90484422 South Florida AAC Willie Taggart 1150000 32000 1182000 650000 45066258 Southern Mississippi CUSA Todd Monken 700000 0 700000 125000 22776416 Tennessee SEC Butch Jones 2960000 0 2960000 1000000 111579779 Texas Big 12 Charlie Strong 5000000 270 5000270 1000000 165691486 Texas A&M SEC Kevin Sumlin 5000000 6000 5006000 750000 93957906 Texas State Sun Belt Dennis Franchione 400000 1200 401200 232500 29764777 Texas Tech Big 12 Kliff Kingsbury 2605000 300 2605300 1500000 72917990 Texas-El Paso CUSA Sean Kugler 503864 4500 508364 478481 29017848 Texas-San Antonio CUSA Larry Coker 400000 2150 402150 230000 23807953 Toledo MAC Matt Campbell 470500 12037 482537 450000 23054218 Troy Sun Belt Larry Blakeney 518788 0 518788 77500 19505723 UCLA PAC-12 Jim Mora 3250000 0 3250000 930000 83926720 Utah PAC-12 Kyle Whittingham 2200000 #N/A 2200000 740000 46855283 Utah State Mt. West Matt Wells 575000 1434 576434 765000 23684266 Virginia ACC Mike London 2298413 5186 2303599 715000 84402710 Virginia Tech ACC Frank Beamer 2420913 240000 2660913 382500 70030484 Washington PAC-12 Chris Petersen 3681720 0 3681720 1175000 85072886 Washington State PAC-12 Mike Leach 2750000 0 2750000 625000 47191240 West Virginia Big 12 Dana Holgorsen 3080000 0 3080000 600000 77706698 Western Kentucky CUSA Jeff Brohm 600000 #N/A 600000 550000 27606401 Western Michigan MAC P.J. Fleck 392500 #N/A 392500 236000 28624348 Wisconsin Big Ten Gary Andersen 2200000 85000 2285000 440000 149141405 Wyoming Mt. West Craig Bohl 832000 0 832000 330000 29647103 College football is big business, with coaches' pay in mil-lions of dollars. The info above contains the 2013 totalathletic department revenue and 2014 football coaches' total payfor 108 schools. (Data extracted from usat.ly/luws90v and usat.ly/1DOIOv3.)a. Compute the covariance.b. Compute the coefficient of correlation.c. Based on (a) and (b), what conclusions can you reach about therelationship between coaches' total pay and athletic departmentrevenues?please use phstat from excel ty
Explanation / Answer
School School Pay Other Pay Total Pay Athletic Department Total Revenue Air Force 866250 26500 892750 39031348 Akron 406000 #N/A 406000 27954164 Alabama 6950203 209984 7160187 143776550 Alabama at Birmingham 500000 #N/A 500000 28159249 Appalachian State 225000 #N/A 225000 19775727 Arizona 2898500 400000 3298500 68510915 Arizona State 2700000 2960 2702960 65673955 Arkansas 3200000 14000 3214000 99770840 Arkansas State 700000 #N/A 700000 16281038 Army 834667 #N/A 834667 37289204 Auburn 3850000 4500 3854500 103680609 Ball State 500000 3500 503500 21315999 Boise State 1000004 #N/A 1000004 43166257 Bowling Green 405000 0 405000 23611448 Buffalo 380210 0 380210 28964050 California 1800000 8000 1808000 94487380 Central Florida 1800000 0 1800000 41222301 Central Michigan 360000 0 360000 27680624 Cincinnati 2200000 0 2200000 61915431 Clemson 3150000 25100 3175100 69061398 Colorado 2008500 1650 2010150 58334345 Colorado State 1500000 #N/A 1500000 34791926 Connecticut 1500000 #N/A 1500000 63336022 East Carolina 1250000 2500 1252500 35805232 Eastern Michigan 425000 #N/A 425000 27797656 Florida 2724500 6500 2731000 130011244 Florida Atlantic 500000 #N/A 500000 24538411 Florida International 550000 1000 551000 28332261 Florida State 3591667 0 3591667 91382441 Fresno State 1400000 35000 1435000 33734773 Georgia 3200000 114000 3314000 98120889 Georgia Southern 400000 #N/A 400000 13200750 Georgia State 510000 #N/A 510000 26721964 Georgia Tech 2588000 2500 2590500 61780812 Hawaii 550000 70500 620500 37017100 Houston 1025000 300 1025300 42024887 Idaho 400011 0 400011 19593192 Illinois 1950000 250 1950250 79725521 Indiana 1301644 #N/A 1301644 76660265 Iowa 4075000 0 4075000 107153782 Iowa State 1800000 8025 1808025 62357761 Kansas 2500000 0 2500000 93114168 Kansas State 2900000 0 2900000 70457283 Kent State 382500 1200 383700 26557674 Kentucky 2700000 1600 2701600 95720724 LSU 4300000 69582 4369582 117457398 Louisiana Tech 500000 10000 510000 18570493 Louisiana-Lafayette 1000000 3156 1003156 18114361 Louisiana-Monroe 357000 1250 358250 11231311 Louisville 3000000 #N/A 3000000 96193330 Marshall 607070 2750 609820 27587274 Maryland 2033680 200 2033880 63714470 Massachusetts 450000 #N/A 450000 30060635 Memphis 1006779 0 1006779 46346285 Miami (Ohio) 450000 #N/A 450000 28705691 Michigan 2854000 2000 2856000 143514125 Michigan State 5611845 24300 5636145 97942726 Middle Tennessee State 801504 1625 803129 27667552 Minnesota 2100000 #N/A 2100000 98286669 Mississippi 3000000 18000 3018000 73390050 Mississippi State 3000000 0 3000000 62764025 Missouri 3400000 0 3400000 76306889 Nebraska 3077646 #N/A 3077646 86916001 Nevada 575000 0 575000 26627415 Nevada-Las Vegas 850000 0 850000 64513044 New Mexico 772690 11000 783690 44345840 New Mexico State 376044 1000 377044 30105460 North Carolina 1830000 #N/A 1830000 82792342 North Texas 710000 1600 711600 28800436 Northern Illinois 400000 1500 401500 26259284 Northwestern 2480967 #N/A 2480967 11767380 Ohio 553000 1500 554500 27265061 Ohio State 4486640 50000 4536640 139639307 Oklahoma 5058333 0 5058333 123805661 Oklahoma State 3500000 #N/A 3500000 93664337 Old Dominion 475000 11010 486010 36929483 Oregon 2000000 #N/A 2000000 115241070 Oregon State 1510008 #N/A 1510008 65467970 Penn State 4300000 #N/A 4300000 104751464 Purdue 2090000 #N/A 2090000 72379392 Rutgers 975000 12000 987000 78989475 San Diego State 800000 2000 802000 39211827 San Jose State 525000 0 525000 25854038 South Alabama 435000 36000 471000 21115562 South Carolina 4000000 16900 4016900 90484422 South Florida 1150000 32000 1182000 45066258 Southern Mississippi 700000 0 700000 22776416 Tennessee 2960000 0 2960000 111579779 Texas 5000000 270 5000270 165691486 Texas A&M 5000000 6000 5006000 93957906 Texas State 400000 1200 401200 29764777 Texas Tech 2605000 300 2605300 72917990 Texas-El Paso 503864 4500 508364 29017848 Texas-San Antonio 400000 2150 402150 23807953 Toledo 470500 12037 482537 23054218 Troy 518788 0 518788 19505723 UCLA 3250000 0 3250000 83926720 Utah 2200000 #N/A 2200000 46855283 Utah State 575000 1434 576434 23684266 Virginia 2298413 5186 2303599 84402710 Virginia Tech 2420913 240000 2660913 70030484 Washington 3681720 0 3681720 85072886 Washington State 2750000 0 2750000 47191240 West Virginia 3080000 0 3080000 77706698 Western Kentucky 600000 #N/A 600000 27606401 Western Michigan 392500 #N/A 392500 28624348 Wisconsin 2200000 85000 2285000 149141405 Wyoming 832000 0 832000 29647103 A Standard Deviation of Coaches Total pay 1460188 (Using STDEV function of excel ) B Standard Deviation of Coaches Total pay 36432424 (Using STDEV function of excel ) C Correlation Coefficient 0.838831028 (Using CORREL function of excel) D=C*A*B COVARIANCE= 4.46243*(10^13) 1.460188 3.643242355 4.46243E+13 Coaches total pay and athaletic department Revenue are reasonably positively correlated A positive covariance indicates coaches total pay and athaletic department revenue moves together If Athaletic department revenue increases , coaches pay also increases Correlation gives the strength of the relationship. 0.8388 correlation coefficient means these two factors are strongly related Coefficient of determination =R square=(0.838831028^2)= 0.703637493 This means 70% variations in coaches pay can be explained by variation in athaletic revenue
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.