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.

(a)Paste your printout here, or attach it to this assignment.

(b) Compose the prediction equation.

(c) 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.