Share
Explore BrainMass

Linear Regression Relationship Analysis

Ten students in a graduate program were randomly selected. Their grade point averages (GPAs) when they entered the program were between 3.5 and 4.0.
The following data were obtained regarding their GPAs on entering the program versus their current GPAs:
Entering GPA
3.5
3.8
3.9
3.7
4
4
3.6
3.9
3.7
4
Current GPA
3.5
3.6
3.5
3.9
3.5
3.7
3.6
3.6
4
3.9

a.     Determine the linear regression equation for the data.
b.     Graph the regression equation
c.       Describe the apparent relationship between the entering GPAs and current GPAs for students in this graduate program.
d.      What does the slope for the regression line represent in terms of current GPAs?
e.     Use the regression equation to predict the current GPA of a student with an entering GPA of 3.6
Hi Tony, I need this question to be ansered in an excel format including formulas. I had another expert do it but I need more input on it, thanks

Solution Summary

Linear regression relationship analysis is examined.

$2.19