Question

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 1

Answer:

There is a significant linear correlation between the two variables.

Step-by-step explanation:

Given that part time weekly earnings are

x y

 

10 93

15 171

20 204

20 156

35 261

 

 

 

Correlation 0.9199

H0: r=correlatin =0

Ha: r ≠0

(two tailed test)

r difference = 0.9199

t = $r*\sqrt{(n-2)/(1-r^2)} \\=4.063$

p value < 0.0001

Since p <0.05 we reject null hypothesis

There is a significant linear correlation between the two variables.