Create a scatter plot.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds