-------------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.
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). |
Get Answers For Free
Most questions answered within 1 hours.