Problem $3-31($Algo$)$

The following are sales revenues for a large utility company for years $1$ through $11.$ Forecast revenue for years $12$ through $15.$ Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method.

Note: Enter your answers in millions.

YEAR REVENUE $($MILLIONS$)$

$1$ $$4,873\mathrm{.}8$

$25,059\mathrm{.}9$

$35,522\mathrm{.}1$

$45,732\mathrm{.}3$

$55,493\mathrm{.}0$

$65,188\mathrm{.}0$

$75,088\mathrm{.}8$

$85,109\mathrm{.}7$

$95,550\mathrm{.}0$

$105,743\mathrm{.}3$

$115,861\mathrm{.}8$

Period Forecast

$12$

$13$

$14$

$15$