Determine the relationship between the volatility of the yield curve and the level of the yield curve. Specifically, for each five year time period (70-74, 75-79, 80-84, etc.) calculate the variance and the average level of the time series of: (i) one-month yields, (ii) five-year yields, (iii) fifteen-year yields, and (iv) thirty-year yields. Use Excel's VAR and AVERAGE functions to calculate the variance and the average of five-year ranges of the yields in columns T, AA, AD, and AG. For example:

o The 70-74 time series of one-month yields is in the range T11-T69.

o The 75-79 time series of one-month yields is in the range T70-T129.

o The 80-84 time series of one-month yields is in the range T130-T189.

o And so on.

Summarize what you have learned from this analysis.