3)A member of the state legislature has expressed concern about the differences
ID: 3435692 • Letter: 3
Question
3)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 random 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:
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 45 and the average salary is 48,000. If the actual mathematics test score for these factors is 68.50, what is the error for this observation? What is the total sum of squares? What is the explained variation? What is the mean square error and the standard error of estimate
4) For the results given in question # 3 above, calculate the Coefficient of Determination and the Adjusted coefficient of Determination and Test for the overall usefulness of the model using F-Statistic at 5% and 1% significance levels. Finally, test the usefulness (or significance of the three independent variables using t-test for 5% and 1% significance levels
PLEASE SHOW WORK TO HELP ME UNDERSTAND
regression output: Predictor Coef SE Coef constant 35.17 7.850 math degree (%) 0.30 0.080 age 0.45 0.188 Salary 0.15 0.075 Analysis of variance: Source DF SS Regression 3 1120.5 Residual Error 28 530.8Explanation / Answer
a) the least squares prediction equation is
ybar = 35.17 + 0.3MD + 0.45age + 0.15salary
no.of observations = n = residual d.f + regression d.f. + 1 = 32
b) Maths % = 50 , Age = 45, Salary = 48000
then estimate of mathematical test score = 35.17 + 0.3*50 + 0.45*45 + 0.15*48
= 35.17 + 15 + 20.25 + 72 = 72.7042
Actual Mathematical score = 68.50
error = Actual - predicted = (68.5 - 72.70) = -4.2 = 4.2
c) Total sum of squares = S.S.Reg + S.S.Error = 1120.5 +530. 8 = 1651.3
MEan square error = sse/d.f = 530.8/28 = 18.957
SE = Sqrt (MSE) = 4.354
d) Coeffient of determination = R2 = 1 - (SSRes/ SST)= 1 - (530.8 / 1651.3) = 1 - 0.3214 = 0.6785
Adj Coeffient of determination = Adj.R2 = 1 - (MSRes/ MST) = 1 - (18.957/53.2677) = 1 - 0.3559 = 0.6441
F-statistics = 36.833 / 18.957 = 1.943
Tab F at 3, 28, 0.05 is 2.9467 as Cal F < tab F at 0.05 we fail to reject the null hypothesis
At 0.01 Tab F at 3, 28 is 4.568 again as Cal F < tab F at 0.05 we fail to reject the null hypothesis
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.