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

Create a scatter plot.

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.

GET STARTED TODAY AND GET A 20% DISCOUNT coupon code DISC20

Leave a Comment