(6.25 Points) FOR THE FOLLOWING QUESTION, DO NOT USE EXISTING DATA USED IN CLASS
ID: 3059894 • Letter: #
Question
(6.25 Points)
FOR THE FOLLOWING QUESTION, DO NOT USE EXISTING DATA USED IN CLASS. POINTS WILL BE DEDUCTED FOR USING THE SAME DATA. In Microsoft Excel, compute the table below:
XBar (Mean)
YBar (Mean)
(X-XBar)2
(Y-YBar)2
(X-XBar)(Y-YBar)
n-1
Covariance
SX
SY
R
Use the following data to complete your analysis: (HINT* you need to complete the table before completing certain parts of the above)
Stock Price
Book Value
(X-XBar)
(Y-YBar)
400
162
210
185
269
670
108
438
423
210
474
648
180
190
490
702
340
461
166
587
385
535
309
499
389
453
375
243
469
419
471
513
66
647
224
695
376
24
469
382
229
398
142
566
27
320
397
204
362
616
289
298
24
87
XBar (Mean)
YBar (Mean)
(X-XBar)2
(Y-YBar)2
(X-XBar)(Y-YBar)
n-1
Covariance
SX
SY
R
Explanation / Answer
XBar =298.6296
Ybar =413.0370
(X-XBar)2 =538942.2963
(Y-YBar)2 =1029974..9630
(X-XBar)(Y-YBar) =53760.3704
n-1 =27-1 =26
Covariance =(X-XBar)(Y-YBar)/(n-1) =2067.7066
SX =((X-XBar)2 /(n-1))1/2 =143.9741
Sy =((Y-YBar)2 /(n-1))1/2 =199.0337
R =Covariance/(Sx*Sy) =0.0722
S.No X Y (x-x)2 (y-y)2 (x-x)(y-y) 1 400.000 162.00 10275.9520 63019.5940 -25447.7174 2 210.000 185.00 7855.2112 52000.8903 20210.8381 3 269.000 670.00 877.9150 66029.9643 -7613.7174 4 108.000 438.00 36339.6557 623.1495 -4758.6804 5 423.000 210.00 15467.9890 41224.0384 -25251.7915 6 474.000 648.00 30754.7668 55207.5940 41205.5418 7 180.000 190.00 14072.9890 49745.5199 26458.8011 8 490.000 702.00 36622.6187 83499.5940 55298.9492 9 340.000 461.00 1711.5075 2300.4458 1984.2455 10 166.000 587.00 17590.6187 30263.1125 -23072.6433 11 385.000 535.00 7459.8409 14874.9643 10533.9863 12 309.000 499.00 107.5446 7389.6310 891.4678 13 389.000 453.00 8166.8038 1597.0384 3611.4678 14 375.000 243.00 5832.4335 28912.5940 -12985.7915 15 469.000 419.00 29026.0631 35.5569 1015.9122 16 471.000 513.00 29711.5446 9992.5940 17230.6529 17 66.000 647.00 54116.5446 54738.6680 -54426.7174 18 224.000 695.00 5569.5816 79503.1125 -21042.7915 19 376.000 24.00 5986.1742 151349.8162 -30099.9396 20 469.000 382.00 29026.0631 963.2977 -5287.7915 21 229.000 398.00 4848.2853 226.1125 1047.0233 22 142.000 566.00 24532.8409 23397.6680 -23958.5322 23 27.000 320.00 73782.6557 8655.8903 25271.6159 24 397.000 204.00 9676.7298 43696.4829 -20563.0508 25 362.000 616.00 4015.8038 41193.9643 12861.8381 26 289.000 298.00 92.7298 13233.5199 1107.7641 27 24.000 87.00 75421.4335 106300.1495 89539.4307 Total 8063 11152 538942.2963 1029974.9630 53760.3704 Mean 298.6296 413.0370 SSX SSY SXYRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.