Question: How can I solve this using excel? (a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter 0 wherever required.)

How can I solve this using excel?

How can I solve this using excel? (a) Calculate SSxx, SSyy, and

(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required.) Click here for the Excel Data File College Student Weekly Earnings in Dollars (n = 5) Hours Worked (X) Weekly Pay (Y) (xi - * ) 2 ( v: - 7) 2 ( xi - ) ( vi - 5) 10 93 15 171 20 204 20 156 35 261 I 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.) (c) Find to25 for a two-tailed test for zero correlation at a = .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? O No Yes (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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!