Question

QUESTION 4 Submit an Excel file with work required The following represents the trend in the number of admissions to our hospital during the past 8 years, 1.Use the 2-years moving average to fill the rest of the table 2. Forecast the number of visits in year 9 and 10 year admissions 111,700 2 11,600 3 11,500 4 11420 11,400 6 11,320 7 11,290 S 11,150 Attach File Browse Dropbox Drowse My C

Answer 1

a)

We have run the 2 year moving averages as the below

Moving admissions 11700 11600 11500 11420 11400 11320 11290 11150 year averages 11650 11550 11460 11410 11360 11305 11220

first moving average is (year1 + year2)/2 = 11650 is placed corresponding on year 2.and go on.

b)

Forecasts

Period Forecast Lower Upper
9 11220 10993.6 11446.4
10 11220 10993.6 11446.4

Moving Average Plot for admissions 11700 11600 -95.0% PI 11500 Moving Average 11400 11300 11200 11100 MAPE MAD 109.2 MSD 13337.5 1.0 11000 109004 1 2 3 45 6 78 910