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

We can handle this paper for you

We Guarantee ZERO Plagiarism ZERO AI

Done by Professional writers from scratch