Download Bloomberg stock price data from a selected stock's GP screen (right-click your mouse in the graph area; click "Send Data to Clipboard" to download data to Excel). In Excel:

a. Calculate columns for stock price relatives \(\left(S_{t} / S_{t-1}\right)\) and logarithmic returns \(\left(\ln \left(S_{t} / S_{t-1}\right)\right)\).

b. Use Excel Average and Variance functions to calculate the historical mean and variance.

c. Annualize the historical mean and variance.

d. Determine the annualized standard deviation. Compare your historical annualized standard deviation to those calculated in HVG.