Scribd
Upload
9 views2 pages

Predicting Final Exam Grades from Midterms

The document describes the construction of a scatter chart for midterm versus final exam grades, resulting in a regression model where a midterm score of 70 predicts a final exam grade of 75. Additionally, it outlines the regression statistics for a Home Market Value analysis, including R Square and ANOVA results. The regression coefficients indicate a significant relationship between the independent variable and the dependent variable.

Uploaded by

tanyasiphone6
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

Predicting Final Exam Grades from Midterms

The document describes the construction of a scatter chart for midterm versus final exam grades, resulting in a regression model where a midterm score of 70 predicts a final exam grade of 75. Additionally, it outlines the regression statistics for a Home Market Value analysis, including R Square and ANOVA results. The regression coefficients indicate a significant relationship between the independent variable and the dependent variable.

Uploaded by

tanyasiphone6
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Q1: Using the data in the Excel file Student Grades, construct a scatter chart for midterm

versus final exam grades and add a linear trendline. What is the regression model? If a
student scores 70 on the midterm, what would you predict her grade on the final exam to be?

120

100

80

60

40

20

0
0 10 20 30 40 50 60

Midterm Final Exam

Predict Final Exam Grade for a Midterm Score of 70:

Using the regression model, substitute the midterm score (70) into the equation to
predict the final exam grade.

If, for example, the regression equation is y=0.5x+40y = 0.5x + 40y=0.5x+40, then:
Final Exam Grade=0.5×70+40=35+40=75\text {Final Exam Grade} = 0.5 \times 70 +
40 = 35 + 40 = 75Final Exam Grade=0.5×70+40=35+40=75

So, if a student scores 70 on the midterm, the predicted final exam score would be 75.

Q2: Using the results of fitting the Home Market Value regression line, compute the errors
associated with each observation and construct a histogram.

SUMMARY
OUTPUT

Regression
Statistics
Multiple R 0.731255
R Square 0.534734
Adjusted R Square 0.523103
Standard Error 7287.723
Observations 42

ANOVA
Significance
df SS MS F F
Regression 1 2.44E+09 2.44E+09 45.97236 3.8E-08
Residual 40 2.12E+09 53110902
Total 41 4.57E+09

Standard Lower
Coefficients Error t Stat P-value Lower 95% Upper 95% 95.0% Upper 95.0%
Intercept 32673.22 8831.951 3.699434 0.00065 14823.18 50523.26 14823.18 50523.2
X Variable 1 35.03637 5.167384 6.780292 3.8E-08 24.5927 45.48004 24.5927 45.4800

You might also like