Find the correlation relationship for the data. Use Microsoft Excel. Create a scatter plot.
The data shown in the table were collected by surveying 100 employees with five years’ experience. Find the correlation relationship for the data. Use Microsoft Excel. Create a scatter plot. Identify and discuss the type of correlation, and whether it is negative or positive, strong or weak. Create a regression line and analyze the coefficients for significance. Predict the estimated salary with 20 years of schooling.
Years of schooling |
Total annual salary |
10 |
$32 K |
12 |
$33 K |
13 |
$44.3 K |
15 |
$55.7 K |
18 |
$60 K |