A member of the state legislature has expressed concern about the differences in the mathematics test scores ...

A member of the state legislature has expressed concern about the differences in the mathematics test scores of high school freshmen across the state. She asks her research assistant to conduct a study to investigate what factors could account for the differences. The research assistant looked at a rando sample of school districts across the state and used the factors of percentage of mathematics teachers in each district with a degree in mathematics, the average age of mathematics teachers and the average salary of mathematics teachers
Predictor Coefficient SE Coefficient
Constant 35.178 7.595
Math Dgr 0.22073 0.07131
Age 0.3353 0.1901
Salary 0.0930 0.1675
 

Analysis of Variance
Source DF SS
Regression 3 1053.09
Residual Error 32 1858.50
 

4 parts to question:
a. Write the least squares prediction equation. What is the number of observations in the sample? Based on the multiple regression model given above, estimate the mathematics test score and calculate the value of the residual, if the percentage of teachers with a mathematics degree is 50.0 the average age is 43 and the average salary is 48,300 (48.3). If the actual mathematics test score for these factors is 68.50, what is the error for this observation?
 

b. For the above equation (question a) answer the following: What is the total sum of squares? What is the explained variation? What is the mean square error?
 

c. For the above equation (question a), calculate the Coefficient of Determination and the Adjusted coefficient of Determination and Testt for the overall usefullness of the model using F-Statistic at 5% and 1% significance levels.
 

d. For the Regression (question a), test the usefulness (or significance of the three independent variables using t-test for 5% and 1% significance levels.