Trend, $163$

Question $3(8$ points$)$

You are trying to decide whether to buy energy futures based on your anticipated electricity bill. The attached sreadsheet contains electricity bill amounts for the past $7$ periods. Use exponential smoothing $($smoothing constant $=\mathrm{.}2)$ to determine the forecast for period $8.$ Spreadsheet

$$1,298$

$$1429$

$$1,451$

$$1403$

Question $4(8$ points$)$

A small theme park uses the following trend model for forecasting demand: daily$\_$passengers $=1054+88t,$ where $t=0$ was Q$1$ of last year. Using the attached

$\backslash$table$[[,A,,B$