Stock-Valuation-erika (1).xlsx - Ford Motor Company Date Adj Close Return 9.72-0.018262 9.900813-0.093044 10.916534-0.041558 11.38988 0.041367 10.937431

Stock-Valuation-erika (1).xlsx - Ford Motor Company Date...

This preview shows page 1 out of 1 page.

Ford Motor Company IBM Date Adj Close Return Date Adj Close Return diff_sq variance 8/1/2018 9.72 -0.018262 8/1/2018 144.9441 0.010902 0.000539 0.000926 7/1/2018 9.900813 -0.093044 7/1/2018 143.381 0.037437 0.002476 6/1/2018 10.916534 -0.041558 6/1/2018 138.2068 -0.000419 0.000142 5/1/2018 11.38988 0.041367 5/1/2018 138.2648 -0.025179 0.000165 4/1/2018 10.937431 0.01444 4/1/2018 141.8361 -0.055204 0.001839 3/1/2018 10.781738 0.044298 3/1/2018 150.1236 -0.005707 4.374E-05 2/1/2018 10.32439 -0.020201 2/1/2018 150.9853 -0.048076 0.001278 1/1/2018 10.537257 1/1/2018 158.6106 0.000152 AVERAGE RETURNS -1.04% -1.23% VARIANCE 0.002035 0.000926 STANDARD DEVIATION 4.51% 4.51% 3.04% 3.04% COAVARIANCE -0.000812050530393 CORRELATION -59.14% -59.14% AT&T Inc. Sprint Corporation
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Spring '14
  • FelishaK.McCaster
  • Standard Deviation, Ford Motor Company, Sprint Corporation, AT&T INC

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes