Use Excel\'s function =T.DIST.2T(t,deg_freedom) to calculate the two-tail p -val

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

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.