(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required.) Picture Click here for the Excel Data File College Student Weekly Earnings in Dollars (n = 5) Hours Worked (X) Weekly Pay (Y) (xi−x¯)2 (yi−y¯)2 (xi−x¯)(yi−y¯) 10 93 100 7056 840 15 171 25 36 30 20 204 0 729 0 20 156 0 441 0 35 261 225 7056 1260 20 177 350 15318 2130 x¯ y¯ SSXX SSyy SSxy (b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (Round your answer to 4 decimal places.) r (c) Find t.025 for a two-tailed test for zero correlation at α=.05. (Round your answer to 3 decimal places.) t.025 ± (d-1) Calculate the t test statistic.(Round your answer to 3 decimal places.) tcalc (d-2) 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.) p-value
Get Answers For Free
Most questions answered within 1 hours.