College Students' Part-Time Weekly Earnings (n = 5)       Hours Worked (X) Weekly Pay (Y)   9 103   15 174   19 209   16 152   35 277   ​​​​​​​a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) (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 t.025 for a two-tailed test for zero correlation at α=0.05α=0.05 . (Round your answer to 3 decimal places.)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
College Students' Part-Time Weekly Earnings (n = 5)
     
Hours Worked (X) Weekly Pay (Y)  
9 103  
15 174  
19 209  
16 152  
35 277

 

​​​​​​​a) Calculate SSxxSSyy, and SSxy(Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

(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 t.025 for a two-tailed test for zero correlation at α=0.05α=0.05 . (Round your answer to 3 decimal places.)

(d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.)

(d-2) Should we reject the null hypothesis of zero correlation?

(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.)

Expert Solution
Step 1

“Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts for you. To get the remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.”

Given:

n = 5

Formula Used:

SSxx = X2-X2n

SSyy = Y2-Y2n

SSxy = XY-XYn

Correlation coefficient r = nXY-XYnX2-X2nY2-Y2

steps

Step by step

Solved in 6 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman