Use Excel\'s function =T.DIST.2T(t,deg_freedom) to calculate the two-tail p -val
ID: 3062251 • Letter: U
Question
Use Excel's function =T.DIST.2T(t,deg_freedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.)
(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.)
(a) Calculate SS SSy, and SSy (Leave no cells blank- be certain to enter "O" wherever required Round your answers to 2 decimal places.) College Student Weekly Eanings in Dollars (n 5) Hours Worked xWeekly Pay (Y) (yi_ 103 173 216 153 260 9 14 18 36 SSxx xy (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 to.025 for a two-tailed test for zero correlation at a-0.0b. (Round your answer to 3 decimal places.) t,025 ± (d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.)Explanation / Answer
here i have completed the table below
SSxx = 420.8
SSyy = 14398
SSxy = 2296
(b) Sample correlation coefficient r= SSxy/ sqrt [SSxx * SSyy] = 2296/ sqrt(14398 * 420.8) = 0.9328
(c) t0.025 = 3.1824
(c) Here test statistic
t = r sqrt [(n-2)/ (1 - r2)]
t = 0.9328 * sqrt [(5-2)/ (1 - 0.93282)]
t = 4.4826
(e) p- value = 0.0207
x y (xi - xbar)^2 (yi - ybar)^2 (xi-xbar)(yi - ybar) 9 103 116.64 6084 842.4 14 173 33.64 64 46.4 22 216 4.84 1225 77 18 153 3.24 784 50.4 36 260 262.44 6241 1279.8 Sum 19.8 181 420.8 14398 2296