Question
3. Obtain the last five years (ending in December 31, 2022) of weekly stock prices for symbols SPY (S&P500 tracking stock) and SHY (short government
3. Obtain the last five years (ending in December 31, 2022) of weekly stock prices for symbols SPY (S&P500 tracking stock) and SHY (short government bonds index tracking stock) and two other stock of your choice (pick large companies, for example Dow Jones Industrial Average components). In Excel, using the prices adjusted for dividends compute the stock weekly returns. A. Using Excel function (Average(..), VAR.S(..), STDEV.S()) report on a separate sheet report the weekly average return, variance and standard deviation. b. For each stock create a Histogram (make the histogram with at least 20 or more bins (make the same bins for all securities, make sure the bin wide enough for all securities. If you make all bins the same, the histogram will show risk very clearly). Compare and discuss briefly, the results for SPY and SHY.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started