Question

Given the following historical data, what is the moving-average forecast for period 6 based on the last three periods?

Period Value

1 33

2 28

3 25

4 32

5 27

Did is solve correctly I tried it in excel is 29.5 correct

or do avg(25+32+27)/3 =29

Please advise?

Step 1

**Calculation of moving average forecast for period 6 based on the last three periods:**

The formula for calculating moving average forecast is:

Get expertly curated answers to your homework questions for just $9.99/month

Get As ASAPTagged in

Sorry about that. What wasn’t helpful?