a) Calculate SS×, SSyy, and SSxy (Leave no cells blank - be certain to enter ''0'' wherever required. Round your answers to 2 decimal places.)CollegeStudentWeeklyEarningsDollars(n=5)Hourse Worked (X)Weekly Pay (Y)(xi−x¯)2(yi−y¯)2(x1−x¯)(yi−y¯)1110316187162161615732262x¯y¯SSxxSSyySSxyb) )Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). (Round your answer to 4 decimal places.)

Question

a) Calculate SS×, SSyy, and SSxy (Leave no cells blank - be certain to enter &#039;&#039;0&#039;&#039; wherever required. Round your answers to 2 decimal places.)CollegeStudentWeeklyEarningsDollars(n=5)Hourse Worked (X)Weekly Pay (Y)(xi−x¯)2(yi−y¯)2(x1−x¯)(yi−y¯)1110316187162161615732262x¯y¯SSxxSSyySSxyb) )Calculate the sample correlation coefficient. Check your work by using Excel&#039;s function =CORREL(array1,array2). (Round your answer to 4 decimal places.)

Paineow · Accepted Answer

Step 1  Given data of College student weekly earnings  Hours Worked (X)Weekly Pay (Y)1110316187162161615732262  The average hours worked and average weekly pay are calculated as shown below  X―=∑Xn  X―=11+16+16+16+325=18.2  Y―=∑Yn  Y―=103+187+216+157+2625  Using the average values the missing values in table are calculated as shown below  CollegeStudentWeeklyEarningsDollars(n=5)Hourse Worked (X)Weekly Pay (Y)(xi−x¯)2(yi−y¯)2(x1−x¯)(yi−y¯)11103(11−18.2)2=51.84(103−185)2=6724(11−18.2)(103−185)=590.416187(16−18.2)2=4.84(187−185)2=4(16−18.2)(187−185)=−4.416216(16−18.2)2=4.84(216−185)2=961(16−18.2)(216−185)=−68.216157(16−18.2)2=4.84(157−185)2=784(16−18.2)(157−185)=61.632262(32−18.2)2(262−185)2=5929(32−18.2)(262−185)=1062.6x¯=18.2y¯=185Sxx=256.8Syy=14402Sxy=1642x¯y¯SSxxSSyySSxy  Step 2  b) The correlation coefficient is calculated using the below mentioned formula  r=SxyS×Syy  r=1642256.8×14402=0.853816  using the excel function CORREL(X data,Y data)  we get the sample correlation coefficient as 0.853815903  Rounding to 4 decimal places we get same value of r in both methods. r=0.8538

Raymond Foley · Accepted Answer

Could you describe the solution to this problem in more detail? The answers were not found anywhere else. Thanks.

a) Calculate SS_{xx},\ SS_{yy}, and SS_{xy} (Lea

Answered question

Answer & Explanation

New Questions in High school statistics