This question has two related parts, (a) and (b).
(a) Use the daily yields in the table below to compute a daily standard deviation of yields. Next annualize the daily standard deviation just calculated first using 365 calendar days, then using 250 trading days in a year. Finally, construct a 4 -day moving average equal weight volatility forecast for each day in the period from Day 5 to Day 24, assuming that the expected value of the daily change in yield is zero. Please show your calculations, including formulas used. Please note: for this question 1) if you use Excel please attach your Excel worksheet to your assignment and 2) keep at least 6 decimal places in both your calculations and your final answers.
(b) Plot in the same graph for each day between Day 5 and Day 24 (inclusive) the computed daily standard deviation of yields and volatility forecast obtained in part (a) above. Please briefly comment on the volatility forecasting method in light of the graph.