Explore BrainMass
Share

Linear Regression Relationship Analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com October 17, 2018, 11:25 am ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/linear-regression-relationship-analysis-538606

Solution Summary

Linear regression relationship analysis is examined.

$2.19
Similar Posting

Simple Linear Regression Analysis

One of the editors of a major automobile publication has collected data on 30 of the best-selling cars in the United States. The editor is particularly interested in the relationship between highway mileage and curb weight of the vehicles.

a. Develop a scatter plot for these data. Discuss what the plot implies about the relationship between two variables. Assume that you wish to predict highway mileage by using vehicle curb weight.

b. Compute the correlation coefficient for the two variables and test to determine whether there is a linear relationship between the curb weight and the highway mileages of automobiles.

c. (1) Compute the linear regression equation based on the sample data (2) Cadillac's 1999 Sedan DeVille weight approximately 4,012 pounds. Provide an estimate of the average highway mileage you would expect to obtain from this model

[See automobile information attached in solution.]

View Full Posting Details