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 ad1c9bdddf
Please see the attached files.
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 = ...
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.