Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Amazon Stock Price 2015-2020 Date Adj Close % Return 8/1/15 512.89 9/1/15 511.89 10/1/15 625.90 11/1/15 664.80 12/1/15 675.89 1/1/16 587.00 2/1/16 552.52 3/1/16 593.64

image text in transcribedimage text in transcribed

Amazon Stock Price 2015-2020 Date Adj Close % Return 8/1/15 512.89 9/1/15 511.89 10/1/15 625.90 11/1/15 664.80 12/1/15 675.89 1/1/16 587.00 2/1/16 552.52 3/1/16 593.64 4/1/16 659.59 5/1/16 722.79 6/1/16 715.62 7/1/16 758.81 8/1/16 769.16 9/1/16 837.31 10/1/16 789.82 11/1/16 750.57 12/1/16 768.66 1/1/17 823.48 2/1/17 845.04 3/1/17 886.54 4/1/17 924.99 5/1/17 994.62 6/1/17 968.00 7/1/17 987.78 8/1/17 980.60 9/1/17 961.35 10/1/17 1105.28 11/1/17 1176.75 12/1/17 1169.47 1/1/18 1450.89 2/1/18 1512.45 3/1/18 1447.34 4/1/18 1566.13 5/1/18 1629.62 6/1/18 1699.80 7/1/18 1777.44 8/1/18 2012.71 9/1/18 2003.00 10/1/18 1598.01 11/1/18 1690.17 12/1/18 1501.97 1/1/19 1718.73 2/1/19 1639.83 3/1/19 1780.75 4/1/19 1926.52 5/1/19 1775.07 6/1/19 1893.63 7/1/19 1866.78 8/1/19 1776.29 9/1/19 1735.91 10/1/19 1776.66 11/1/19 1800.80 12/1/19 1847.84 1/1/20 2008.72 2/1/20 1883.75 3/1/20 1949.72 4/1/20 2474.00 5/1/20 2442.37 6/1/20 2758.82 7/1/20 3164.68 8/1/20 3450.96 Go to assignment2 sheet in the Chapter 3 Excel file. Compute the 60 monthly log returns of Amazon and S&P 500 using their 61 monthly adjusted prices/indices from August 2015 to August 2020, and then report the beta of Amazon using the computed log retums

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

Statistics Informed Decisions Using Data

Authors: Michael Sullivan III

5th Edition

978-0134135373, 134133536, 134135377, 978-0134133539

More Books

Students also viewed these Finance questions

Question

=+What conclusions about the additive and car types do you draw?

Answered: 1 week ago

Question

It would have become a big deal.

Answered: 1 week ago