Use the given data in Microsoft Excel to find the best predicted value of the response variable.

Question

The regression equation relating dexterity scores x and productivity scores y for the employees of a company is y=5.50+1.91x. Ten pairs of data were used to obtain the equation. The same data yield r=0.986 and y= 56.3. What is the best predicted productivity score for a person whose dexterity score is 21?

Answer 1

If the regression equation is y = 5.50 + 1.91x then that means:

(productivity score) = 5.50 + 1.91(dexterity score)

So for a dexterity score of 21:

(productivity score) = 5.50 + 1.91(21)

(productivity score) = 5.50 + 40.11 = 45.61