• Create a scatterplot of Payrate and Age in Excel. Paste your graph below. Make sure your graph has a proper title and axes labels.
• Find the correlation coefficient of Payrate and Age. Paste your correlation coefficient below. Interpret the direction and strength of the correlation coefficient in 2-3 sentences.
• Using your answers from part B and part D, is employee satisfaction or age more strongly correlated with Payrate?Explain in 2-3 sentences.

1. Complete a regression analysis using Age (x variable) to predict Payrate (y variable).

• Paste your regression analysis output from Excel below.
• Using the output in part a, write out the linear equation to predict payrate based on your data set.
• Use your regression equation in part B to estimate the payrate of a 45-year-old and a 55-year-old employee. Make sure to show your calculations for full credit.