Excel

File

Edit

View insert

Format

Tools

Data

Window

Help

AutoSave

$$

$$

$$

$$

$...$

$$ Stokes OM Excel Assignnent $1($Forecasti

Home

Insert

Draw

Page Layout

Formulas

Data

Review

View

Acrobat

Paste

Calibri

$11$

General

B $I$

$U_{?}$

r

$1$A$^($n$)$A$^(**)$D$10$fxABCDEFGH$1$$ $-\%,$lig$\_(40)$rarr$001$ Problem $1(15$ points$)$: Moving average

$2$ a $(6$ pts$)$ Use a $2-$year moving average to forecast the number of surgeries from year $3$ to year $6.$

$3$ b $(9$ pts$)$ Compute MAD, MSE, and MAPE.

$4$

$5$ Demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years,

$6$

as shown below. The director of medical services wants to choose a forecast method to predict the demand in year $6$