Explore BrainMass

Explore BrainMass

    Regression Analysis for Pro Football Player Salary

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Seeking a regression analysis on the two pro football team player salaries....

    Arizona Cardinals

    Year Median salary Total Payroll
    2006
    $ 710,000
    $ 105,685,931

    2005
    $ 455,070
    $ 76,539,161

    2004
    $ 621,424
    $ 78,961,345

    2003
    $ 652,800
    $ 81,034,928

    2002
    $ 383,165
    $ 66,967,535

    2001
    $ 512,000
    $ 74,891,809

    2000
    $ 455,050
    $ 58,610,500

    New Orleans Saints

    Year Median salary Total Payroll
    2006
    $ 721,000
    $ 91,021,286

    2005
    $ 692,090
    $ 96,027,339

    2004
    $ 762,800
    $ 73,324,022

    2003
    $ 662,500
    $ 95,103,350

    2002
    $ 597,059
    $ 54,263,868

    2001
    $ 516,000
    $ 67,326,988

    2000
    $ 475,200
    $ 55,914,000

    New Orleans Saints
    Player Pos Base salary Bonuses Total Pay
    Tom Ackerman OL 429,000 3,400 432,400
    Ink Aleaga LB 325,000 3,400 328,400
    Ashley Ambrose CB 725,000 487,000 1,212,000
    Tom Barnhardt P/ K 400,000 33,000 433,000
    Brett Bech WR 325,000 3,400 328,400
    Chris Bordano LB 250,000 22,400 272,400
    Doug Brien P/ K 400,000 76,300 476,300
    Cuncho Brown TE 62,000 0 62,000
    Justin Burroughs OL 101,000 4,000 105,000
    Je'Rod Cherry CB 453,000 3,400 456,400
    Phil Clarke LB 175,000 0 175,000
    Willie Clay S 400,000 200,000 600,000
    Cameron Cleeland TE 287,000 306,000 593,000
    Aaron Craver RB 400,000 137,000 537,000
    Troy Davis RB 325,000 134,000 459,000
    Lawrence Dawsey WR 400,000 2,100 402,100
    Jake Delhomme QB 250,000 0 250,000
    Tyronne Drakeford CB 805,000 600,000 1,405,000
    John Farquhar TE 429,000 3,400 432,400
    Mark Fields LB 400,000 2,247,500 2,647,500
    Jerry Fontenot OL 700,000 362,000 1,062,000
    P. J. Franklin WR 175,000 0 175,000
    Kendall Gammon OL 400,000 40,000 440,000
    La'Roi Glover DT 1,600,000 690,000 2,290,000
    Mike Halapin DT 325,000 200 325,200
    Uhuru Hamiter DE 250,000 0 250,000
    Corey Harris CB 175,000 0 175,000
    Andre Hastings WR 1,210,000 583,000 1,793,000
    Chris Hewitt S 325,000 3,400 328,400
    Billy Joe Hobert QB 1,000,000 250,000 1,250,000
    Robert Hunt OL 175,000 0 175,000
    Joe Johnson DE 2,900,000 2,700,000 5,600,000
    Rob Kelly S 370,000 263,000 633,000
    Eddie Kennison WR 842,000 50,000 892,000
    Sammy Knight S 325,000 428,400 753,400
    Bryan LaBelle OL 101,000 0 101,000
    Marc Lillibridge LB 101,000 3,400 104,400
    Wayne Martin DT 540,000 2,153,000 2,693,000
    Keith Mitchell LB 325,000 408,200 733,200
    Kevin Mitchell LB 400,000 300,000 700,000
    Alex Molden CB 875,000 545,400 1,420,400
    Chris Naeole OL 864,000 722,400 1,586,400
    Robert Newkirk DT 175,000 10,000 185,000
    Wilmont Perry RB 250,000 37,200 287,200
    Dino Philyaw RB 325,000 10,000 335,000
    Keith Poole WR 325,000 474,200 799,200
    Marvin Powell RB 175,000 0 175,000
    William Roaf OL 2,350,000 1,087,000 3,437,000
    Austin Robbins DT 400,000 195,000 595,000
    Thomas Schau OL 62,000 0 62,000
    Scott Slutzker TE 429,000 2,800 431,800
    Brady Smith DE 429,000 3,400 432,400
    Lamar Smith RB 1,650,000 433,000 2,083,000
    Vinson Smith LB 400,000 15,000 415,000
    Donnie Spragan LB 101,000 7,000 108,000
    Leander K Stevens WR 62,000 0 62,000
    Daryl Terrell OL 175,000 200 175,200
    Billy Joe Tolliver QB 400,000 210,000 610,000
    Jared Tomich DE 325,000 281,400 606,400
    Joe Tuipala LB 175,000 0 175,000
    Kyle Turley OL 727,000 1,060,000 1,787,000
    Fred Weary CB 250,000 88,200 338,200
    Willie Whitehead DE 175,000 0 175,000
    Josh Wilcox TE 250,000 3,400 253,400
    Ricky Williams RB 175,000 1,263,000 1,438,000
    Robert Williams CB 250,000 0 250,000
    Wally Williams OL 400,000 1,500,000 1,900,000
    Danny Wuerffel QB 325,000 85,200 410,200
    2006 / New Orleans Saints

    Player
    Base Salary
    Sign Bonus
    Other Bonus
    Total Salary
    Cap Value
    Position

    Allen, James D. (LB)
    $ 585,000 $ 100,000 $ 25,000 $ 710,000 $ 710,000 LB
    Bellamy, Jay
    $ 850,000 $ 0 $ 0 $ 600,000 $ 8,300,000 S
    Berger, Mitch
    $ 810,000 $ 0 $ 880 $ 810,880 $ 960,880 K
    Brees, Drew
    $ 1,900,000 $ 8,000,000 $ 12,100,000 $ 22,000,000 $ 6,000,000 QB
    Brown, Jammal
    $ 350,000 $ 0 $ 5,964,840 $ 6,314,840 $ 1,546,840 OL
    Bullocks, Josh
    $ 350,000 $ 0 $ 1,014,620 $ 1,364,620 $ 757,120 S
    Bush, Reggie
    $ 275,000 $ 0 $ 2,425,000 $ 2,700,000 $ 2,700,000 RB
    Campbell, Mark
    $ 600,000 $ 800,000 $ 50,000 $ 1,450,000 $ 916,666 TE
    Carney, John
    $ 810,000 $ 0 $ 1,210 $ 811,210 $ 911,210 K
    Clark, Danny
    $ 585,000 $ 40,000 $ 0 $ 625,000 $ 625,000 LB
    Colston, Marques
    $ 275,000 $ 24,600 $ 0 $ 299,600 $ 283,200 TE
    Conwell, Ernie
    $ 1,600,000 $ 0 $ 75,000 $ 1,675,000 $ 2,095,000 TE
    Copper, Terrance
    $ 425,000 $ 0 $ 4,840 $ 425,000 $ 425,000 WR
    Craft, Jason
    $ 1,000,000 $ 0 $ 450,000 $ 1,450,000 $ 1,987,500 CB
    Deloatch, Curtis
    $ 425,000 $ 0 $ 0 $ 425,000 $ 425,000 CB
    Evans, Jahri
    $ 275,000 $ 346,300 $ 0 $ 621,300 $ 390,433 OL
    Faine, Jeff
    $ 538,750 $ 0 $ 2,200 $ 540,950 $ 540,950 OL
    Fincher, Alfred
    $ 350,000 $ 0 $ 4,730 $ 354,730 $ 528,730 LB
    Fujita, Scott
    $ 1,000,000 $ 4,000,000 $ 4,400 $ 5,004,400 $ 2,004,400 LB
    Gleason, Steve
    $ 585,000 $ 0 $ 5,280 $ 590,280 $ 673,613 S
    Goodwin, Jonathan
    $ 800,000 $ 600,000 $ 50,000 $ 1,450,000 $ 1,150,000 OL
    Grant, Charles
    $ 2,187,500 $ 0 $ 50,000 $ 2,237,500 $ 2,922,500 DE
    Groce, DeJuan
    $ 721,600 $ 0 $ 0 $ 721,600 $ 721,600 CB
    Harper, Roman
    $ 275,000 $ 880,000 $ 109,000 $ 1,264,000 $ 604,000 S
    Henderson, Devery
    $ 425,000 $ 0 $ 4,950 $ 429,950 $ 783,700 WR
    Hoffmann, Augie
    $ 275,000 $ 0 $ 1,320 $ 181,320 $ 181,320 OL
    Holland, Montrae
    $ 721,600 $ 0 $ 4,180 $ 725,780 $ 725,780 OL
    Horn, Joe
    $ 1,635,000 $ 0 $ 1,700,000 $ 3,335,000 $ 4,735,000 WR
    Houser, Kevin
    $ 585,000 $ 0 $ 10,000 $ 595,000 $ 635,000 TE
    Jones, Jamal
    $ 275,000 $ 0 $ 1,760 $ 276,760 $ 276,760 WR
    Joseph, Keith
    $ 275,000 $ 0 $ 4,840 $ 190,428 $ 190,428 RB
    Karney, Mike
    $ 425,000 $ 1,200,000 $ 4,180 $ 1,629,180 $ 707,180 RB
    Lake, Antwan
    $ 721,600 $ 0 $ 5,830 $ 721,600 $ 721,600 DT
    Leisle, Rodney
    $ 425,000 $ 0 $ 5,280 $ 430,280 $ 472,281 DT
    Lewis, Michael (WR)
    $ 600,000 $ 500,000 $ 100,000 $ 1,200,000 $ 866,666 WR
    Martin, Jamie
    $ 810,000 $ 200,000 $ 2,420 $ 1,012,420 $ 912,420 QB
    McAllister, Deuce
    $ 1,450,000 $ 0 $ 5,600,000 $ 7,050,000 $ 5,855,000 RB
    McKenzie, Mike
    $ 1,500,000 $ 0 $ 1,125,000 $ 2,625,000 $ 4,025,000 CB
    Melton, Terrence
    $ 425,000 $ 0 $ 5,170 $ 430,170 $ 430,170 LB
    Miller, Billy
    $ 585,000 $ 0 $ 0 $ 344,118 $ 250,000 TE
    Nesbit, Jamar
    $ 710,000 $ 400,000 $ 25,000 $ 1,135,000 $ 1,035,000 OL
    Ninkovich, Rob
    $ 275,000 $ 144,280 $ 0 $ 341,045 $ 244,858 DE
    Owens, John
    $ 500,000 $ 0 $ 0 $ 235,294 $ 235,294 TE
    Petitti, Rob
    $ 350,000 $ 0 $ 4,840 $ 350,000 $ 350,000 OL
    Polley, Tommy
    $ 585,000 $ 0 $ 880 $ 275,880 $ 210,880 LB
    Scott, Bryan
    $ 500,000 $ 0 $ 3,410 $ 503,410 $ 503,410 S
    Setterstrom, Chad
    $ 275,000 $ 0 $ 5,280 $ 185,280 $ 185,280 OL
    Shanle, Scott
    $ 721,600 $ 0 $ 5,280 $ 721,600 $ 721,600 LB
    Simoneau, Mark
    $ 1,100,000 $ 0 $ 6,160 $ 1,100,000 $ 1,100,000 LB
    Smith, Will
    $ 500,000 $ 0 $ 0 $ 500,000 $ 1,922,500 DE
    Stecker, Aaron
    $ 1,000,000 $ 0 $ 25,000 $ 1,025,000 $ 1,187,500 RB
    Stinchcomb, Jon
    $ 460,000 $ 0 $ 5,170 $ 465,170 $ 926,420 OL
    Stoutmire, Omar
    $ 710,000 $ 40,000 $ 4,730 $ 754,730 $ 469,730 S
    Strief, Zach
    $ 275,000 $ 45,930 $ 0 $ 320,930 $ 290,310 OL
    Thomas, Fred
    $ 1,900,000 $ 0 $ 1,000,000 $ 2,900,000 $ 4,150,000 CB
    Thomas, Hollis
    $ 710,000 $ 0 $ 2,090 $ 545,031 $ 545,031 DT
    Weatherford, Steve
    $ 275,000 $ 0 $ 0 $ 275,000 $ 275,000 K
    Whitehead, Willie
    $ 965,000 $ 750,000 $ 50,000 $ 1,765,000 $ 1,265,000 DT
    Young, Brian
    $ 1,950,000 $ 0 $ 50,000 $ 2,000,000 $ 2,900,000 DT

    2006 / Arizona Cardinals

    Player
    Base Salary
    Sign Bonus
    Other Bonus
    Total Salary
    Cap Value
    Position

    Arrington, J.J.
    $ 350,000 $ 0 $ 1,210 $ 351,210 $ 887,147 RB
    Ayanbadejo, Obafemi
    $ 710,000 $ 260,000 $ 1,650 $ 971,650 $ 841,650 RB
    Beisel, Monty
    $ 585,000 $ 0 $ 0 $ 275,294 $ 200,000 LB
    Bergen, Adam
    $ 350,000 $ 0 $ 6,050 $ 337,815 $ 344,315 TE
    Berry, Bertrand
    $ 4,000,000 $ 0 $ 1,650 $ 4,001,650 $ 5,001,650 DE
    Blackstock, Darryl
    $ 350,000 $ 0 $ 4,290 $ 354,290 $ 500,623 LB
    Boldin, Anquan
    $ 1,750,000 $ 0 $ 5,001,210 $ 6,751,210 $ 4,053,710 WR
    Brewer, Jack
    $ 585,000 $ 0 $ 1,210 $ 276,210 $ 211,210 S
    Brown, Elton
    $ 350,000 $ 0 $ 3,410 $ 353,410 $ 467,576 OL
    Brown, Milford
    $ 2,000,000 $ 3,000,000 $ 1,650 $ 5,001,650 $ 2,751,650 OL
    Cantu, Rolando
    $ 275,000 $ 0 $ 6,493 $ 186,493 $ 186,493 OL
    Clancy, Kendrick
    $ 1,500,000 $ 2,000,000 $ 1,650 $ 3,501,650 $ 2,001,650 DT
    Cooper, Chris
    $ 585,000 $ 0 $ 0 $ 481,765 $ 350,000 DT
    Dansby, Karlos
    $ 425,000 $ 0 $ 2,530 $ 427,530 $ 1,040,030 LB
    Darling, James
    $ 850,000 $ 0 $ 4,730 $ 854,730 $ 1,042,230 LB
    Davis, Leonard
    $ 9,169,000 $ 0 $ 150,000 $ 9,319,000 $ 10,079,418 OL
    Dockett, Darnell
    $ 5,383,333 $ 0 $ 1,210 $ 3,926,210 $ 4,116,210 DT
    Fitzgerald, Larry
    $ 3,317,500 $ 0 $ 1,210 $ 3,318,710 $ 6,122,460 WR
    Francisco, Aaron
    $ 350,000 $ 0 $ 4,290 $ 354,290 $ 354,290 CB
    Gorin, Brandon
    $ 585,000 $ 0 $ 6,160 $ 585,000 $ 585,000 OL
    Green, Eric
    $ 350,000 $ 0 $ 4,290 $ 354,290 $ 539,956 CB
    Griffith, Robert
    $ 1,175,000 $ 0 $ 770 $ 1,175,770 $ 1,500,770 S
    Hayes, Gerald
    $ 8,159,100 $ 0 $ 2,530 $ 4,224,130 $ 4,224,130 LB
    Hodel, Nathan
    $ 585,000 $ 0 $ 1,650 $ 586,650 $ 586,650 OL
    Huff, Orlando
    $ 800,000 $ 0 $ 1,210 $ 801,210 $ 1,001,210 LB
    James, Edgerrin
    $ 3,250,000 $ 7,000,000 $ 4,500,770 $ 14,750,770 $ 9,500,770 RB
    Johnson, Brandon
    $ 275,000 $ 132,450 $ 0 $ 407,450 $ 319,150 LB
    Johnson, Bryant
    $ 602,500 $ 0 $ 3,410 $ 605,910 $ 1,549,453 WR
    Leckey, Nick
    $ 425,000 $ 0 $ 6,050 $ 431,050 $ 458,884 OL
    Leinart, Matt
    $ 275,000 $ 0 $ 1,225,000 $ 1,500,000 $ 1,500,000 QB
    Lewis, Jon
    $ 275,000 $ 81,200 $ 0 $ 356,200 $ 302,066 DT
    Liwienski, Chris
    $ 710,000 $ 0 $ 0 $ 710,000 $ 425,000 OL
    Lutui, Deuce
    $ 275,000 $ 1,985,000 $ 0 $ 2,260,000 $ 771,250 OL
    Macklin, David
    $ 2,000,000 $ 0 $ 3,850 $ 2,003,850 $ 2,603,850 CB
    McCoy, LeRon
    $ 350,000 $ 0 $ 3,850 $ 198,850 $ 212,183 WR
    Milligan, Hanik
    $ 460,000 $ 0 $ 0 $ 460,000 $ 460,000 S
    Navarre, John
    $ 425,000 $ 0 $ 5,170 $ 430,170 $ 445,004 QB
    Okeafor, Chike
    $ 3,500,000 $ 0 $ 1,210 $ 3,501,210 $ 4,401,210 DE
    Pace, Calvin
    $ 642,500 $ 0 $ 2,970 $ 645,470 $ 1,957,970 DE
    Player, Scott
    $ 750,000 $ 0 $ 1,210 $ 751,210 $ 875,795 K
    Pope, Leonard
    $ 275,000 $ 578,000 $ 0 $ 853,000 $ 467,666 TE
    Rackers, Neil
    $ 1,800,000 $ 0 $ 4,290 $ 1,804,290 $ 1,804,290 K
    Robinson, Roger
    $ 275,000 $ 0 $ 2,200 $ 182,200 $ 182,200 RB
    Rolle, Antrel
    $ 6,725,000 $ 0 $ 1,210 $ 3,351,210 $ 4,903,210 CB
    Ross, Oliver
    $ 2,800,000 $ 0 $ 1,210 $ 2,801,210 $ 3,501,210 OL
    Schable, A.J.
    $ 275,000 $ 5,000 $ 0 $ 280,000 $ 277,500 DE
    Shipp, Marcel
    $ 1,425,000 $ 0 $ 1,650 $ 1,426,650 $ 1,776,650 RB
    Smith, Antonio
    $ 425,000 $ 0 $ 3,410 $ 428,410 $ 428,410 DE
    Stepanovich, Alex
    $ 425,000 $ 0 $ 6,050 $ 431,050 $ 546,884 OL
    Tate, Robert
    $ 710,000 $ 0 $ 5,170 $ 715,170 $ 430,170 CB
    Wakefield, Fred
    $ 750,000 $ 0 $ 2,970 $ 752,970 $ 872,970 OL
    Walters, Troy
    $ 585,000 $ 0 $ 4,290 $ 571,055 $ 416,643 WR
    Ware, Matt
    $ 425,000 $ 0 $ 6,160 $ 425,000 $ 425,000 CB
    Warner, Kurt
    $ 4,000,000 $ 3,000,000 $ 1,650 $ 7,001,650 $ 5,001,650 QB
    Watson, Gabe
    $ 275,000 $ 347,500 $ 0 $ 622,500 $ 390,833 DT
    Wells, Reggie
    $ 750,000 $ 3,000,000 $ 4,400 $ 3,754,400 $ 1,354,400 OL
    Wilson, Adrian
    $ 2,500,000 $ 0 $ 1,210 $ 2,501,210 $ 3,240,709 S

    Year / Median Salary
    2006

    Team Median Salary
    San Diego Chargers
    $ 1,066,500
    Washington Redskins
    $ 904,730
    New York Giants
    $ 854,250
    Detroit Lions
    $ 852,420
    Pittsburgh Steelers
    $ 804,840
    Baltimore Ravens
    $ 786,390
    Tampa Bay Buccaneers
    $ 783,080
    Philadelphia Eagles
    $ 775,390
    Carolina Panthers
    $ 762,200
    New York Jets
    $ 757,740
    Minnesota Vikings
    $ 751,430
    Cleveland Browns
    $ 750,000
    St. Louis Rams
    $ 741,000
    Buffalo Bills
    $ 736,320
    New Orleans Saints
    $ 721,000
    Jacksonville Jaguars
    $ 720,200
    Chicago Bears
    $ 714,290
    Houston Texans
    $ 712,530
    Arizona Cardinals
    $ 710,000
    Kansas City Chiefs
    $ 710,000
    Seattle Seahawks
    $ 692,500
    Denver Broncos
    $ 674,000
    New England Patriots
    $ 650,580
    Oakland Raiders
    $ 640,000
    San Francisco 49ers
    $ 630,250
    Cincinnati Bengals
    $ 629,070
    Miami Dolphins
    $ 622,635
    Atlanta Falcons
    $ 600,000
    Dallas Cowboys
    $ 589,840
    Indianapolis Colts
    $ 527,285
    Green Bay Packers
    $ 438,420
    Tennessee Titans
    $ 430,445

    © BrainMass Inc. brainmass.com June 3, 2020, 8:30 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/regression-analysis-for-pro-football-player-salary-140981

    Attachments

    Solution Summary

    This Solution provides the coded position as shown in the table and coded teams as 1 (=New Orleans) and 2 (=Arizona), and then regresses different salaries on both the position and the team.

    The results are shown in the attached excel sheet.

    $2.19

    ADVERTISEMENT