Obtain the last five years $($ending on December $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 stocks 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 briefly discuss the

results for SPY and SHY. Your work should be like the one on the following page.

Submit your Excel file.