The following data shows the average interest rate (%) for a 30-year fixed-rate mortgage over a ten-year
Question:
The following data shows the average interest rate (%) for a 30-year fixed-rate mortgage over a ten-year period (FreddieMac website).
a. Construct a time series plot. Do you think a linear trend or a quadratic trend will provide a better fit for this time series? Why?
b. Develop the linear trend equation for this time series. Using this linear trend equation, forecast the average interest rate for period 11.
c. Develop the quadratic trend equation for this time series. Using this quadratic trend equation, forecast the average interest rate for period 11.
d. Compare your answers to parts (b) and (c). Which model would you recommend? Why?
Step by Step Answer:
Modern Business Statistics With Microsoft Excel
ISBN: 9781337115186
6th Edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran