Stats Solutions

(Solution Library) (10) Using Excel, prepare a linear regression equation for the following data and use it for prediction. A random sample of study times for 12

Question: (10) Using Excel, prepare a linear regression equation for the following data and use it for prediction.

A random sample of study times for 12 students tracks hours of study for their advanced tax exam and the percentage grades they subsequently earned on their tax exam. Assume that study times have been compiled over a weekend.

Hours 10 16 12 11 9 15 14 13 9 10 11 12
Grade 98 90 85 92 75 95 90 85 70 85 80 93
  1. (3) Paste your printout here, or attach it to this assignment.
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 63.92775 11.70144 5.463239 0.000276 37.85532 90.00017
Hours 1.907514 0.97231 1.961837 0.078197 -0.25893 4.073957

(b) (4) Compose the prediction equation.

(c) (3) Use the regression equation to predict the grade of a student who takes the same exam the following semester after having studied 12 hours for it.

Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in