Obtain the last five years $($ending in December October $31,2023)$ of weekly stock prices for

symbols SPY $($S&P$500$ 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.