Share
Explore BrainMass

Develop a Regression Model

Student 1 2 3 4 5 6 7 8 9
1st grade 98 77 88 80 96 61 66 95 69
final Grade 93 78 84 73 84 64 64 95 76

A. Develop a regression model that could be used to predict the final average in the course based on the first test grade.

B. Predict the final average of a student who made an 83 on the first grade.

C. Give the values r and r2 for this model. Interpret the value of r2 in the context of this problem.

Solution Preview

Please see the attached files.

Solution
a. You can do this by plotting final grade vs. first grade in Excel (see file attached):

Then use the Fit trendline facility, we have the following regression relationship:
Final grade = ...

Solution Summary

The solution provides detailed explanations and discussion on development of a regression model that could be used to predict the final average in the course based on the first test grade.

$2.19