10.4 Obtain at least 5 years worth of daily or weekly stock price data for a stock of your choice.

a. Compute annual volatility using all the data.

b.Compute annual volatility for each calendar year in your data. How does

volatility vary over time?

c.Compute annual volatility for the first and second half of each year in your

data. How much variation is there in your estimate?

how do I do these in excel?