(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

- Explain how "hot assets" affect the character of gain when selling a partnership interest Under what circumstances can a stock dividend be a taxable event to

- Barium titanite is a dielectric material with spontaneous polarization Ps=0.21. If we now its dielectric constant = 800, electrostrictive coefficient Q33 =

- What part of the brain controls facial expressions