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 |
How useful was this post?
Click on a star to rate it!
Average rating 0 / 5. Vote count: 0
No votes so far! Be the first to rate this post.