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