Use the given data in Microsoft Excel to find the best predi

Use the given data in Microsoft Excel to find the best predicted value of the response variable. The regression equation relating attitude rating (x) and job performance rating (y) for the employees of a company is y=11.7 + 1.02x Ten pairs of data were used to obtain the equation. The same data yield r = 0.863 and y = 80.1 What is the best predicted job performance rating for a person whose attitude rating is 77? (Points : 4)

Solution

We simply plug in x = 77 to the equation, so we get

y^ = 11.7 + 1.02x

y^ = 11.7 + 1.02*77 = 90.24 [ANSWER]