Question 352117: Part-time weekly earnings ($) by college students.
hours worked (x) weekly pay (y)
10 93
15 171
20 204
20 156
35 261
this is the question: a) make an excel scatter plot. what does it suggest about the population correlation between X and Y? b) make an excel worksheet to calculate SSxx,SSyy, and SSxy c) use appendix D to find t.05 for a two-tailored test for zero correlation. d) calculate the t test statistics. can you reject p=0? Answer by Fombitz(32388) (Show Source):
You can put this solution on YOUR website! a)
.
.
.
b) From my EXCEL spreadsheet,
.
.
.
.
.
.
Regression line plotted with the data.
.
.
.
