For the two random variables, X and Y, for which data is given in the “ DATA FIL
ID: 3127467 • Letter: F
Question
For the two random variables, X and Y, for which data is given in the “DATA FILE" what is the correlation between those variables?
THE DATA FILE IS BELOW.
*****DATA FILE**************
W
Z
X
Y
9.660065068
17.40832419
19.13735121
-5.478019202
9.507083913
12.17211546
15.32719395
-1.884177301
9.429391901
26.2084044
25.19592198
-11.86276183
9.193973364
20.60748971
21.06963439
-8.069356056
9.202650009
11.97901735
14.97543882
-1.962891709
10.57031441
18.45402829
20.52021029
-5.573785718
10.27425145
16.75339664
19.1085472
-4.580755652
8.207137944
15.1461368
16.51076524
-4.905872192
7.24439021
19.40790513
18.84317281
-8.599605051
8.408049727
14.68757656
16.32860778
-4.439625469
10.54497399
11.99212376
15.93372811
-1.023134888
8.83946935
11.69463608
14.51761254
-2.018602879
6.09864736
9.313224983
10.89619375
-2.272706379
10.63195394
16.23721798
18.99650455
-3.962921675
8.684860342
9.861071335
13.1119737
-0.831581172
10.91826336
14.88636764
18.24387412
-2.805449731
7.053966207
15.83991761
16.18597586
-6.211667642
6.770028945
14.41284726
14.97629348
-5.403472548
10.83865115
9.211039557
14.17513133
1.150721399
13.3920067
17.68019368
21.96804567
-3.031748198
9.770711828
18.23171506
19.79771581
-5.981929284
8.547933811
15.52189068
17.01736591
-4.930587503
11.78333335
16.13786045
19.74028402
-3.07865066
10.33351944
13.31584721
16.72010222
-2.108505734
7.213057881
21.08821541
20.00900021
-9.80973637
11.52459371
16.75025946
19.99032119
-3.694545682
13.60009453
15.30507216
20.43595285
-1.205419185
11.97920532
16.50271519
20.1367178
-3.198121474
10.49258833
19.73840998
21.37331581
-6.536795904
10.45804227
13.30949975
16.8036522
-2.015980441
8.52737517
18.63396666
19.20306867
-7.14536018
6.994446547
21.21292657
19.9426128
-10.05246538
12.13735677
11.17850411
16.48431364
0.677908827
11.92678387
14.73692205
18.85124008
-1.986767689
8.868461761
21.09723733
21.18574926
-8.645744326
8.708947511
15.39672882
17.04271317
-4.728261389
11.63744597
15.66279897
19.30127318
-2.845924571
13.98232513
17.46687443
22.23458409
-2.463576358
10.05267327
17.73934471
19.64895671
-5.434476708
9.124799761
17.90383557
19.10924518
-6.20677832
7.387828352
13.22462957
14.57300775
-4.12661846
6.270336403
17.70644495
16.95158441
-8.085328739
12.33464425
21.13948348
23.66620831
-6.225021331
7.235944304
11.57199418
13.29721251
-3.065587264
9.505035776
11.88171836
15.12043517
-1.680314584
8.521975801
21.90054966
21.5087255
-9.458651721
8.533576803
8.504683482
12.04605002
0.020427578
10.46440946
17.97315858
20.1053606
-5.30868563
13.8555733
9.054517587
16.19743426
3.39434639
7.881810917
19.00577891
19.00952601
-7.864645369
10.92444156
20.14093504
21.96322125
-6.516060889
9.939359964
14.28072531
17.12360029
-3.069345298
7.655560845
10.74144847
13.00668559
-2.181722554
11.32684993
16.72174592
19.83035727
-3.814191464
5.45214115
12.70060115
12.83398881
-5.124661222
9.876635314
23.11701204
23.32650868
-9.360946343
11.40414723
18.92268738
21.44107206
-5.315607886
7.643148841
11.72458001
13.6929843
-2.885571836
6.496699441
14.11773125
14.5744025
-5.388069488
11.07546673
12.55507261
16.70679131
-1.046081353
11.11823212
17.00163372
19.88074515
-4.159564927
9.789590591
14.86972848
17.43413858
-3.591657484
12.52049301
17.27420564
21.06485194
-3.360874827
14.1021691
18.74941254
23.22606822
-3.285601111
9.389363635
8.879893557
12.91636483
0.360195345
11.17637662
10.86602218
15.58397595
0.219420594
11.36959551
15.24578921
18.817077
-2.740468948
9.832159984
23.59313731
23.63168519
-9.729010968
6.485160404
16.27435428
16.09097688
-6.920960067
12.43258211
19.17971774
22.34989599
-4.770224887
10.08811697
18.30248239
20.07215375
-5.807556354
9.847773294
16.26895906
18.46452977
-4.539778333
7.954087638
23.23016831
22.04726895
-10.80018903
10.722027
17.23982692
19.76903072
-4.608084544
10.12418433
15.97444988
18.45173439
-4.136137739
10.19143686
13.33145981
16.63068794
-2.219996229
9.916464289
12.47468172
15.83054023
-1.808659724
11.49283243
7.620671713
13.51324743
2.737617626
9.408631428
18.42105855
19.67559082
-6.371785978
12.20748173
12.39515149
17.39406169
-0.13268252
5.822407822
15.91599133
15.3690482
-7.13616354
9.944591407
19.25551788
20.64447726
-6.582825014
9.144810298
16.67442839
18.25420175
-5.323439991
7.934474228
10.49412502
13.02901967
-1.80967311
11.5234233
9.068606759
14.55856525
1.735555292
8.997196509
12.87193696
15.46147736
-2.739441496
7.879185665
12.3036893
14.2692926
-3.128124069
10.82891422
11.84060304
16.0273487
-0.715263997
9.983498185
15.73061362
18.17987704
-4.06321061
9.864970192
12.22691199
15.6189607
-1.669892851
12.52532518
13.62183405
18.48604157
-0.775231769
10.49806901
18.71784014
20.65564777
-5.811378192
8.353646234
16.0184913
17.23110124
-5.419045463
9.505050925
16.10541491
18.10659934
-4.666457336
9.808620457
10.86396654
14.61551901
-0.746129683
9.678858045
19.01519498
20.28669549
-6.600790215
9.636890001
14.01009673
16.71841962
-3.091857157
8.503155491
18.63750963
19.18845024
-7.164988379
11.40859209
15.45224664
18.99061298
-2.858863764
W
Z
X
Y
9.660065068
17.40832419
19.13735121
-5.478019202
9.507083913
12.17211546
15.32719395
-1.884177301
9.429391901
26.2084044
25.19592198
-11.86276183
9.193973364
20.60748971
21.06963439
-8.069356056
9.202650009
11.97901735
14.97543882
-1.962891709
10.57031441
18.45402829
20.52021029
-5.573785718
10.27425145
16.75339664
19.1085472
-4.580755652
8.207137944
15.1461368
16.51076524
-4.905872192
7.24439021
19.40790513
18.84317281
-8.599605051
8.408049727
14.68757656
16.32860778
-4.439625469
10.54497399
11.99212376
15.93372811
-1.023134888
8.83946935
11.69463608
14.51761254
-2.018602879
6.09864736
9.313224983
10.89619375
-2.272706379
10.63195394
16.23721798
18.99650455
-3.962921675
8.684860342
9.861071335
13.1119737
-0.831581172
10.91826336
14.88636764
18.24387412
-2.805449731
7.053966207
15.83991761
16.18597586
-6.211667642
6.770028945
14.41284726
14.97629348
-5.403472548
10.83865115
9.211039557
14.17513133
1.150721399
13.3920067
17.68019368
21.96804567
-3.031748198
9.770711828
18.23171506
19.79771581
-5.981929284
8.547933811
15.52189068
17.01736591
-4.930587503
11.78333335
16.13786045
19.74028402
-3.07865066
10.33351944
13.31584721
16.72010222
-2.108505734
7.213057881
21.08821541
20.00900021
-9.80973637
11.52459371
16.75025946
19.99032119
-3.694545682
13.60009453
15.30507216
20.43595285
-1.205419185
11.97920532
16.50271519
20.1367178
-3.198121474
10.49258833
19.73840998
21.37331581
-6.536795904
10.45804227
13.30949975
16.8036522
-2.015980441
8.52737517
18.63396666
19.20306867
-7.14536018
6.994446547
21.21292657
19.9426128
-10.05246538
12.13735677
11.17850411
16.48431364
0.677908827
11.92678387
14.73692205
18.85124008
-1.986767689
8.868461761
21.09723733
21.18574926
-8.645744326
8.708947511
15.39672882
17.04271317
-4.728261389
11.63744597
15.66279897
19.30127318
-2.845924571
13.98232513
17.46687443
22.23458409
-2.463576358
10.05267327
17.73934471
19.64895671
-5.434476708
9.124799761
17.90383557
19.10924518
-6.20677832
7.387828352
13.22462957
14.57300775
-4.12661846
6.270336403
17.70644495
16.95158441
-8.085328739
12.33464425
21.13948348
23.66620831
-6.225021331
7.235944304
11.57199418
13.29721251
-3.065587264
9.505035776
11.88171836
15.12043517
-1.680314584
8.521975801
21.90054966
21.5087255
-9.458651721
8.533576803
8.504683482
12.04605002
0.020427578
10.46440946
17.97315858
20.1053606
-5.30868563
13.8555733
9.054517587
16.19743426
3.39434639
7.881810917
19.00577891
19.00952601
-7.864645369
10.92444156
20.14093504
21.96322125
-6.516060889
9.939359964
14.28072531
17.12360029
-3.069345298
7.655560845
10.74144847
13.00668559
-2.181722554
11.32684993
16.72174592
19.83035727
-3.814191464
5.45214115
12.70060115
12.83398881
-5.124661222
9.876635314
23.11701204
23.32650868
-9.360946343
11.40414723
18.92268738
21.44107206
-5.315607886
7.643148841
11.72458001
13.6929843
-2.885571836
6.496699441
14.11773125
14.5744025
-5.388069488
11.07546673
12.55507261
16.70679131
-1.046081353
11.11823212
17.00163372
19.88074515
-4.159564927
9.789590591
14.86972848
17.43413858
-3.591657484
12.52049301
17.27420564
21.06485194
-3.360874827
14.1021691
18.74941254
23.22606822
-3.285601111
9.389363635
8.879893557
12.91636483
0.360195345
11.17637662
10.86602218
15.58397595
0.219420594
11.36959551
15.24578921
18.817077
-2.740468948
9.832159984
23.59313731
23.63168519
-9.729010968
6.485160404
16.27435428
16.09097688
-6.920960067
12.43258211
19.17971774
22.34989599
-4.770224887
10.08811697
18.30248239
20.07215375
-5.807556354
9.847773294
16.26895906
18.46452977
-4.539778333
7.954087638
23.23016831
22.04726895
-10.80018903
10.722027
17.23982692
19.76903072
-4.608084544
10.12418433
15.97444988
18.45173439
-4.136137739
10.19143686
13.33145981
16.63068794
-2.219996229
9.916464289
12.47468172
15.83054023
-1.808659724
11.49283243
7.620671713
13.51324743
2.737617626
9.408631428
18.42105855
19.67559082
-6.371785978
12.20748173
12.39515149
17.39406169
-0.13268252
5.822407822
15.91599133
15.3690482
-7.13616354
9.944591407
19.25551788
20.64447726
-6.582825014
9.144810298
16.67442839
18.25420175
-5.323439991
7.934474228
10.49412502
13.02901967
-1.80967311
11.5234233
9.068606759
14.55856525
1.735555292
8.997196509
12.87193696
15.46147736
-2.739441496
7.879185665
12.3036893
14.2692926
-3.128124069
10.82891422
11.84060304
16.0273487
-0.715263997
9.983498185
15.73061362
18.17987704
-4.06321061
9.864970192
12.22691199
15.6189607
-1.669892851
12.52532518
13.62183405
18.48604157
-0.775231769
10.49806901
18.71784014
20.65564777
-5.811378192
8.353646234
16.0184913
17.23110124
-5.419045463
9.505050925
16.10541491
18.10659934
-4.666457336
9.808620457
10.86396654
14.61551901
-0.746129683
9.678858045
19.01519498
20.28669549
-6.600790215
9.636890001
14.01009673
16.71841962
-3.091857157
8.503155491
18.63750963
19.18845024
-7.164988379
11.40859209
15.45224664
18.99061298
-2.858863764
Explanation / Answer
By using excel function =CORREL(data range of X, data range of Y), the correlation between X and Y is -0.600.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.