Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed
(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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra

Authors: Jim Hefferon

1st Edition

978-0982406212, 0982406215

More Books

Students also viewed these Mathematics questions