Question: Solve and explain how to enter in excel Forecasting Models for Time Series with a Linear Trend 2. (40 points) Consider the data in the

Forecasting Models for Time Series with a Linear Trend 2. (40 points) Consider the data in the Excel file Consumer Price Index. a. Use double exponential smoothing to find forecasts for the next two years. b. Use simple linear regression to find forecasts for the next two years. \begin{tabular}{cr} Year & Annual CPI \\ \hline 2003 & 184.0 \\ 2004 & 188.9 \\ 2005 & 195.3 \\ 2006 & 201.6 \\ 2007 & 207.342 \\ 2008 & 215.303 \\ 2009 & 214.537 \\ 2010 & 218.056 \\ 2011 & 224.939 \\ 2012 & 229.594 \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
