# Given the following historical data, what is the moving-average forecast for period 6 based on the last three periods?Period Value1 332 283 254 325 27Did is solve correctly I tried it in excel is 29.5 corrector do avg(25+32+27)/3 =29Please advise?

Question
326 views

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

check_circle

Step 1

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

The formula for calculating moving average forecast is:

Step 2

Calculation of moving average forecast:

The moving average calculated for period 3 will become the forecast for period 4. The moving average calculated for period 4 will become the forecast for period 5. The moving average calculated for period 5 will become the forecast for period 6 and so on.

Calculation of moving average for period 3:

Step 3

Calculation of moving average for perio...

See Solution

### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in 