Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra Foundations Prealgebra, Algebra & Intermediate Algebra (subscription)

Authors: Elayn Martin Gay

2nd Edition

0135257506, 9780135257500

More Books

Students also viewed these Mathematics questions

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago