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
- Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table year registrations 1 4 2 6 3 4 4 5 5
- Suppose you take two different samples of size 9 and 16 from same population, which is
- Discuss five ways in which trade unions can be revived.