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
58	24	58	11	36	3,214,520
72	20	71	26	58	2,500,000
81	57	40	-3	38	2,200,000
66	28	29	10	73	1,400,000
84	52	27	27	127	1,150,000
79	15	43	16	163	900,000
44	4	20	16	8	800,000
83	29	29	-2	73	725,000
65	1	5	-7	72	700,000
82	3	27	-5	115	685,000
64	12	30	12	40	600,000
56	16	14	1	26	600,000
65	2	2	-4	22	600,000
78	15	40	5	30	570,000
67	13	15	-21	64	525,000
70	13	20	28	72	481,586
55	1	9	-11	85	450,000
64	3	18	-14	135	450,000
27	2	4	-4	8	450,000
79	11	29	8	276	314,500
77	1	11	5	52	414,000
71	3	5	-7	146	400,000
79	2	7	4	110	400,000
76	17	14	0	31	392,500
66	17	23	9	28	385,000
60	1	9	-11	67	375,000
81	8	11	-8	347	375,000
71	10	20	14	20	270,100
84	7	7	-4	305	360,000
53	2	21	5	63	259,000
73	4	8	-20	96	259,000
49	2	8	-3	63	240,500
33	4	3	-1	28	325,000
17	1	1	-2	49	315,000
64	6	28	9	36	307,311
29	1	11	4	22	300,000
62	2	17	20	36	300,000
59	1	6	-13	40	300,000
70	6	9	-50	116	222,000
16	2	2	-8	2	275,000
6	1	0	-1	2	275,000
60	2	6	-7	58	265,000
81	12	38	-12	16	250,000
78	12	77	20	39	250,000
10	1	2	2	4	230,000
9	0	0	-4	12	225,000
81	18	13	-1	48	225,000
67	12	3	-22	82	200,000
20	1	3	-1	8	200,000
32	9	10	7	10	165,000