(a) Calculate SS_xx, SS_yy and SS_xy. (Leave no cells blank - be certain to ente
ID: 3231877 • Letter: #
Question
(a) Calculate SS_xx, SS_yy and SS_xy. (Leave no cells blank - be certain to enter "0" wherever required Round your answers to 2 decimal places.) (b) Calculate the sample correlation coefficient. Check your work by using Excel's function = CORREL(array1, array2). (Round your answer to 4 decimal places.) (c) Find t_0.025 for a two-tailed test for zero correlation at alpha = 0.05. (Round your answer to 3 decimal 0.025 places.) Calculate the t test statistic. (Round your answer to 3 decimal places.) Should we reject the null hypothesis of zero correlation? Yes, No (e) Use Excel's function = T.DIST.2T(t, deg_freedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.)Explanation / Answer
(a)
(b) r = 0.8101
(c) 3.182
(d-1) 2.393
(d-2) No
(3) 0.0965
x y (x - x-bar)^2 (y - y-bar)^2 (x - x-bar)(y - y-bar) 13 90 70.56 8836 789.6 18 181 11.56 9 10.2 17 216 19.36 1024 -140.8 22 157 0.36 729 -16.2 37 276 243.36 8464 1435.2 21.4 184 345.2 19062 2078Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.