Researcher's Salaries (15 marks) Download the Assignment #5 data fileand then answer the following questions. 1) Clearly identify the dependent & independent variable(s) (1) 2) Run the Excel regression at a 5% level of significance, leave output on same worksheet. (2) 3) Clearly state the regression equation. (1) 4) Estimate a researcher's salary if they four (4) years of experience, a supervisory rating of 65 and a Master's degree. (1) 5) Assess the model's fit by: a. State the Coefficient of Determination for entire model. (1) i. State whether or not you believe R^2 can be trusted. (1) b. F-Test: State whether or not the model is valid. (1) i. Show all your work for hypothesis test. (3) c. P-Value: i. State whether or not each of the independent variables is significantly related to the dependent variable (6) ii. State whether or not you would consider deleting any of the independent variables and state your reasoning why. (2) iii. IF you choose to delete any variables, re-run the regression again and compare the results to the first trial. What conclusions can you draw. (3) 1

Salary ($000)	Years of Experience	Supervisor's Rating	Master's Degree*
85.8	26	84	0
77.2	20	65	0
77.1	25	82	1
66.8	23	62	1
77.1	20	72	0
58.4	15	46	1
78.5	28	76	0
65	11	59	1
75.6	18	66	1
65.9	16	47	1
66	25	63	0
53.6	1	42	0
78.6	14	73	1
58.8	9	40	0
82	30	79	1
79.6	24	82	0
			*1 = yes, 0 = no

please answer for this question.