(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - becertain to enter 0 wherever required....
Question:
(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - becertain to enter "0" wherever required. Round your answers to 2decimal places.) Picture Click here for the Excel Data File CollegeStudent Weekly Earnings in Dollars (n = 5) Hours Worked (X) WeeklyPay (Y) formula56.mml formula57.mml formula58.mml 9 98 81 7022.44754.2 12 186 36 17.64 -25.2 16 203 4 449.44 -42.4 18 159 0 519.84 035 263 289 6593.44 1380.4 410 14602.8 2067 formula253.mmlformula254.mml SSXX SSyy SSxy (b) Calculate the sample correlationcoefficient. Check your work by using Excel's function=CORREL(array1,array2). (Round your answer to 4 decimal places.) r(c) Find t0.025 for a two-tailed test for zero correlation atformula40.mml. (Round your answer to 3 decimal places.) t.025 ±(d-1) Calculate the t test statistic.(Round your answer to 3decimal places.) tcalc (d-2) Should we reject the null hypothesisof zero correlation? Yes No (e) Use Excel's function=T.DIST.2T(t,deg_freedom) to calculate the two-tail p-value. (Roundyour answer to 4 decimal places.) p-value
Applied Statistics In Business And Economics
ISBN: 9780073521480
4th Edition
Authors: David Doane, Lori Seward