Interval Estimation and Hypothesis Testing in Regression Analysis

Do students with higher college grade point averages (GPAs) earn more than those graduates with lower GPAs? Consider the college GPA and salary data (10 years after graduation). Use these data to answer the following questions:

GPA	Salary
2.21	71000
2.28	49000
2.56	71000
2.58	63000
2.76	87000
2.85	97000
3.11	134000
3.35	130000
3.67	156000
3.69	161000

A) Using appropriate software (e.g., MS Excel), develop the regression equation (y= 0+1x) that could be used to measure the impact of GPA (: independent variable) on Salary (: dependent variable).

How do you interpret the slope coefficient value 1?

B) Utilizing appropriate software (e.g., MS Excel), develop a 99% confidence interval for the slope coefficient value 1.

How do you interpret this 99% confidence interval?

C) Set up the null hypothesis (H0) and the alternative hypothesis (Ha) for testing the slope coefficient value 1interpret each in terms of the business application.

D) Utilizing appropriate software (e.g., MS Excel), use the "p-value" approach to test at the 99% confidence level whether impact the of GPA (: independent variable) on Salary (: dependent variable) is statistically significant. What is your conclusion?

Thank you for your help!