Given by teacher: 1) Open finance.yahoo.com in your browser, and enter the stock symbol (one company at a time!) for Apple (AAPL), Walmart (WMT), and Bank of America (BAC). Then click the yellow Get Quotes bar. 2) On the page for the company (this example is for Apple), click on Historical Prices. 3) Change the reporting from daily to weekly, and change the start date to April 15, 2016. That will return about six months of weekly data when you click Get Prices. 4) The result of your work should be a table like this one. Note that the weekly return measure is on Mondays. Use the Adj Close column for data to transfer to excel. Ignore the dividend rows and in excel compute a Percent change from week to week over the six month period. Find the average of those changes (weekly returns!) as well as the standard deviation. Do this for Apple, Walmart, and Bank of America. The tickers are AAPL, WMT, and BAC.

1. What is the weekly average return for each of the stocks over the past six months? Submit your answers as:

AAPL avg = 101.28

WMT avg =

BAC avg = 14.49

**I think I computed the 2 averages right, but I could be wrong. Correct me if I'm wrong.

2. What is the standard deviation of weekly returns for each of the stocks? Submit your answer as Std Dev AAPL = Std Dev WMT = Std Dev BAC =

**I don't know know to find the standard deviation of the weekly returns..

3. Briefly discuss your results. That is, how did the three companies' stocks behave over the time period? Were their "performances" similar or different? To the extent that their volatilities (standard deviations) were different, why do you think that is so? You should be brief but clear. Don't just say "Company X went up but companies Y and Z went down."

**Please help & please show your work! Thank you!