Share
Explore BrainMass

Regression Analysis

The following data are the grade point averages x and the monthly salaries y for students who obtained a bachelor's degree in business administration with a major in information systems. The estimated regression for these data is by = 1790:5 + 581:1x.

GPA Monthly Salary

2.6 3300
3.4 3600
3.6 4000
3.2 3500
3.5 3900
2.9 3600

a. Write the regression
b. interpret the regression constant and regression coefficient
c. forecast a value for monthly salary.

Solution Preview

Please see the attachments.

Trying to understand Regression using Excel Please help
The following data are the grade point averages x and the monthly salaries y for students who obtained a bachelor's degree in business administration with a major in information systems. The estimated regression for these data is by = 1790:5 + 581:1x.
GPA Monthly Salary
2.6 3300
3.4 3600
3.6 4000
3.2 3500
3.5 3900
2.9 3600
Answers
a. Write the regression

GPA, X Monthly Salary, ...

Solution Summary

The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.

$2.19