Question

# -------------How would part b and c be calculated in excel ? -------------- The following data are...

-------------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

Know the answer?
Your Answer:

#### Post as a guest

Your Name:

What's your source?

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Not the answer you're looking for?
Ask your own homework help question