(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.

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.

### Recently Asked Questions

- What are advantages of submitting contract disputes to arbitration instead of to litigation in courts? with references please

- what is the best free tool to decipher a ciphertext message and vise versa?

- 1. Does Asia have special population issues that are not present in other developing countries? If so, what are they?