# 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.

© BrainMass Inc. brainmass.com June 3, 2020, 7:23 pm ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/develop-a-regression-model-96429

#### 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.