Ch$.17$: Time$-$Series Forecasting and Trend Analysis, Business Statistics Computer Applications

p$.5$

Corporate triple$-$A bond interest rates for $12$ consecutive months follow.

$\backslash$table$[[9\mathrm{.}6,9\mathrm{.}4,9\mathrm{.}5,9\mathrm{.}6,9\mathrm{.}8,9\mathrm{.}7,9\mathrm{.}8,10\mathrm{.}6,10\mathrm{.}0,9\mathrm{.}8,9\mathrm{.}6,9\mathrm{.}6]]$

$($b$)$ Develop three$-$month and four$-$month moving averages for this time series. $($Round your answers to two decimal places.$)$

$\backslash$table$[[$Month$,\backslash$table$[[$Time Series$],[$Value$]],\backslash$table$[[3-$Month Moving$],[$Average Forecast$]],\backslash$table$[[4-$Month Moving$],[$Average Forecast$]]],[1,9\mathrm{.}6,,],[2,9\mathrm{.}4,,],[3,9\mathrm{.}5,,],[4,9\mathrm{.}6,9\mathrm{.}50,],[5,9\mathrm{.}8,x,x$