I could use some help with this problem please

Mike Wilde is president of the teachers' union for Otsego School District. In preparing for upcoming negotiations. he is investigating the salary structure of classroom teachers in the district He believes there are three factors that affect a teacher's sala ry: years of experience, a teaching effectiveness rating given by the principal. and whether the teacher has a master's degree. A random sample of 20 teachers resulted in the following data. Salary {$ Years of Principal's Master's thousands). y EXPGFiGI'ICe. X1 Rating; X2 \"HEW-Ga\" X3 31.1 B 3.5 8 33.6 5 43 8 29.3 2 51 1 43.8 15 68 1 38.6 11 1'3 8 45.8 14 88 1 42.8 9 T6 8 36.8 T 54 1 48.6 22 5.5 1 31.1r 3 98 1 25.'.ir 1 30 B 38.6 5 44 8 51.8 23 84 1 48.1r 1? T6 8 38.4 12 68 1 33.6 14 2.5 8 41.8 B 98 1 38.1r 4 62 8 32.8 2 8a 1 42.8 B 22 8 *1 = yes, 0 = no. Click here for the Excel Data File a. Develop a correlation matrix. Which independent variable has the strongest correlation with the dependent variable? Does it appear there will be an)\":r problems with multicollinearity? [Round your answers to 3 decimal places} 9 answer Is complete and correct. Years 0.363 9 Rating 0.54? 9 0.13? 9 Master's 0.311 9 0.203 9 0.453 9 Answer is complete and correct. Years has the strongest correlation with salary. does not appear to be a problem with There multicollinearity. b. Determine the regression equation. What salary would you estimate for a teacher with 5 years' experience, a rating by the principal of 60, and no master's degree? (Negative amount should be indicated by a minus sign. Round salary to nearest whole number, all other answers to 3 decimal places.) The regression equation is: * Answer is not complete. 19.915 0.899 0.154 X (0.667) x3 or c. Conduct a global test of hypothesis to determine whether any of the regression coefficients differ from zero. Use the 0.05 significance level. (Round your answers to 2 decimal places.) * Answer is not complete. HO is rejected if F Computed F = HO is rejected At least one regression coefficient is not zero.d. Conduct a test of hypothesis for the individual regression coefficients. Would you consider deleting any of the independent variables? Use the 0.05 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) A regression coefficient is dropped if computed t is to the left of or right of Keep " " and " "; drop " e. If your conclusion in part (d) was to delete one or more independent variables, run the analysis again without those variables. (Round your answers to 4 decimal places.) Dropping " " we have: Salary = + +f. State true or false. Histogram of Residuals From the graph the residuals appear normally distributed. ' True 0 False 9. Choose the right option from the following graph. 3 The residuals look random. 9 ' The residuals do not look random