A large school district is reevaluating its teachers salaries. They have decided to use regression analysis to predict mean teacher salaries at each high school. The researcher uses years of experience and subject matter (Math, science, English, Other) to predict Salary. The raw data is given in the table below;
Salary Years Experience Subject
24,265 8 English
27,140 5 English
22,195 2 Math
37,950 15 Science
32,890 11 Other
40,250 14 Math
36,800 9 Math
30,820 6 Science
44,390 21 Math
24,955 2 Science
18,055 1 English
23,690 7 English
48,070 20 Science
42,205 16 Math
24,265 6 Other
27,140 8 Other
36,875 7 Math
37,950 9 Math
32,890 1 English
40,280 4 Science
Use excel to analyze the data.
Use the following; Y=Dependent Variable; X1= Years of Experience; X2=Math; X3= Science; X4= English
A) What is the prediction equation?
b) What is the correlation coefficient
C) Is the overall model significant? Why?
D) What is the coefficient of determination?
E) What is the MSE?
F) List the P-Value of each independent variable and say whether it is significant to the model or not. Use a 0.05 level of significance.
G) What is the predicted mean salary for a gym teacher with 10 years experience?