1. In the Excel file Treasury Yield Rates , develop spreadsheet models for forec

1. In the Excel file Treasury Yield Rates , develop spreadsheet models for forecasting the one month treasury yield. Use simple moving average models with k = 2 and k = 3, and compare them on the basis of the usual error metrics. 2. Consider the data in the Excel file Consumer Price Index . a. Use simple linear regression to forecast the data. What would be the forecasts for the next two months? b. Are the data autocorrelated? Construct first- and second-order autoregressive models and compare the results to part (a).

You may also like