Phone Hold Time for Concert Tickets in Seconds

(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.025 for a two-tailed test for zero correlation at α =.05.
(d) Calculate the t test statistic. Can you reject ρ = 0?
(e) Use Excel's function = T.DIST.2T (t,deg_freedom) to calculate the two-tail p-value.

Transcribed Image Text:

Operators CX) Wait Time (Y) 385 335 383 288