Question

-------------How would part b and c be calculated in excel ? --------------

The following data are the monthly salaries y and the grade point averages x for students who obtained a bachelor's degree in business administration.

GPA	Monthly Salary ($)
2.6	3,500
3.4	3,800
3.6	4,300
3.1	3,700
3.5	4,100
3	2,500

The estimated regression equation for these data is ŷ = 267.1 + 1,057.1x and MSE =303,179.

a. Develop a point estimate of the starting salary for a student with a GPA of 3.0 (to 1 decimal).
$

b. Develop a 95% confidence interval for the mean starting salary for all students with a 3.0 GPA (to 2 decimals).
$ (  ,  )

c. Develop a 95% prediction interval for Ryan Dailey, a student with a GPA of 3.0 (to 2 decimals).
$ (  ,  )

Answer 1