View the step-by-step solution to:

(a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y?

(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 . Use these sums to calculate the sample correlation coefficient. Check your work by using Excel’s
function =CORREL(array1,array2). (c) Use Appendix D to find t.05 for a two-tailed test for zero correlation.
(d) Calculate the t test statistic. Can you reject ρ = 0? (e) Use Excel’s function =TDIST(t,deg_freedom,tails)
to calculate the two-tail p-value.

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents