Question
Professional athletes in North America are paid very well for their ability to play games. To determine the factors that influence a team to pay
Professional athletes in North America are paid very well for their ability to play games. To determine the factors that influence a team to pay a hockey player's salary, 50 hockey players were selected randomly. The salaries at the end of the season, as well as the following performance measures for the season were recorded for each player: games played, goals scored, assists, plus/minus score, and penalty minutes. The data is given in the data file below.
Data Set.xls
Perform a regression analysis and provide the answers to the following questions in an MS Excel file, then upload the MS Excel file.
Questions:
1. Is the regression model valid? Provide a brief explanation.
2. Would you recommend any independent variables be removed from the model, and explain why? (Do not re-run the model, simply identify which variable(s) you would remove and analyze further.)
| Games Played | Goals Scored | Assists | Plus/Minus Score | Penalty minutes | Salary |
| 84 | 58 | 79 | 33 | 44 | 3,214,520 |
| 78 | 19 | 63 | 38 | 40 | 2,500,000 |
| 80 | 54 | 47 | -27 | 41 | 2,200,000 |
| 82 | 41 | 56 | 12 | 81 | 1,400,000 |
| 84 | 36 | 29 | -4 | 148 | 1,150,000 |
| 81 | 25 | 41 | 15 | 169 | 900,000 |
| 60 | 3 | 31 | 22 | 22 | 800,000 |
| 64 | 31 | 35 | 29 | 28 | 725,000 |
| 60 | 1 | 14 | 21 | 71 | 700,000 |
| 77 | 4 | 15 | 3 | 55 | 685,000 |
| 80 | 13 | 47 | 5 | 63 | 600,000 |
| 63 | 23 | 21 | 10 | 43 | 600,000 |
| 45 | 3 | 10 | 17 | 28 | 600,000 |
| 77 | 25 | 52 | -1 | 32 | 570,000 |
| 80 | 22 | 35 | 3 | 66 | 525,000 |
| 61 | 20 | 19 | -6 | 76 | 481,586 |
| 77 | 10 | 14 | 10 | 108 | 450,000 |
| 67 | 6 | 15 | -21 | 71 | 450,000 |
| 55 | 6 | 14 | -9 | 39 | 450,000 |
| 83 | 2 | 14 | 35 | 205 | 314,500 |
| 74 | 3 | 7 | 0 | 66 | 414,000 |
| 64 | 3 | 6 | -10 | 202 | 400,000 |
| 53 | 1 | 9 | -2 | 107 | 400,000 |
| 68 | 10 | 11 | -12 | 49 | 392,500 |
| 78 | 17 | 39 | -12 | 69 | 385,000 |
| 22 | 0 | 2 | -3 | 18 | 375,000 |
| 61 | 5 | 10 | 1 | 344 | 375,000 |
| 47 | 10 | 15 | 13 | 19 | 270,100 |
| 77 | 4 | 8 | -6 | 209 | 360,000 |
| 70 | 10 | 21 | 6 | 79 | 259,000 |
| 84 | 8 | 18 | -1 | 131 | 259,000 |
| 41 | 4 | 15 | 1 | 61 | 240,500 |
| 48 | 6 | 9 | 1 | 49 | 325,000 |
| 41 | 5 | 3 | -5 | 90 | 315,000 |
| 69 | 11 | 35 | -8 | 74 | 307,311 |
| 77 | 7 | 29 | -25 | 30 | 300,000 |
| 36 | 1 | 5 | 0 | 14 | 300,000 |
| 65 | 5 | 12 | 23 | 105 | 300,000 |
| 69 | 3 | 13 | -24 | 61 | 222,000 |
| 31 | 4 | 11 | 4 | 18 | 275,000 |
| 6 | 0 | 3 | 4 | 2 | 275,000 |
| 32 | 1 | 2 | 0 | 32 | 265,000 |
| 55 | 10 | 17 | 3 | 32 | 250,000 |
| 49 | 8 | 23 | -1 | 4 | 250,000 |
| 26 | 0 | 2 | 3 | 10 | 230,000 |
| 10 | 0 | 0 | 1 | 20 | 225,000 |
| 27 | 3 | 4 | -6 | 8 | 225,000 |
| 70 | 22 | 30 | 34 | 82 | 200,000 |
| 5 | 0 | 1 | -3 | 0 | 200,000 |
| 11 | 0 | 5 | -3 | 2 | 165,000 |
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 Unlocking The Power Of Data
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock
1st Edition
9780470601877
