|
Method and examples
|
Method
|
|
Weighted Moving Average
|
|
|
- 3 year Weighted Moving Average
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Sales | 5.2 | 4.9 | 5.5 | 4.9 | 5.2 | 5.7 | 5.4 | 5.8 | 5.9 | 6 | 5.2 | 4.8 | Calculate 3 year Weighted Moving Average with weight=1,2,1
- 5 year Weighted Moving Average
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Sales | 5.2 | 4.9 | 5.5 | 4.9 | 5.2 | 5.7 | 5.4 | 5.8 | 5.9 | 6 | 5.2 | 4.8 | Calculate 5 year Weighted Moving Average with weight=1,2,1,2,1
- 4 year Weighted Moving Average
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sales | 20 | 21 | 23 | 22 | 25 | 24 | 27 | 26 | 28 | 30 | Calculate 4 year Weighted Moving Average with weight=1,2,2,1
- 3 year Weighted Moving Average
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Sales | 2 | 4 | 5 | 7 | 8 | 10 | 13 | Calculate 3 year Weighted Moving Average with weight=1,2,1
- 3 year Weighted Moving Average
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sales | 30 | 25 | 35 | 25 | 20 | 30 | 35 | 40 | 30 | 45 | Calculate 3 year Weighted Moving Average with weight=1,2,1
- 3 year Weighted Moving Average
year | 1 | 2 | 3 | 4 | 5 | 6 | Sales | 650 | 700 | 810 | 800 | 900 | 700 | Calculate 3 year Weighted Moving Average with weight=0.2,0.3,0.5
|
Decimal Place =
|
|
|
Solution
|
Solution provided by AtoZmath.com
|
|
Weighted Moving Average calculator
|
1. Calculate 3 year Weighted Moving Average calculator
with weight=1,2,1
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Sales | 5.2 | 4.9 | 5.5 | 4.9 | 5.2 | 5.7 | 5.4 | 5.8 | 5.9 | 6 | 5.2 | 4.8 |
2. Calculate 5 year Weighted Moving Average calculator
with weight=1,2,1,2,1
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Sales | 5.2 | 4.9 | 5.5 | 4.9 | 5.2 | 5.7 | 5.4 | 5.8 | 5.9 | 6 | 5.2 | 4.8 |
3. Calculate 4 year Weighted Moving Average calculator
with weight=1,2,2,1
year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sales | 20 | 21 | 23 | 22 | 25 | 24 | 27 | 26 | 28 | 30 |
|
|
|
|
|
|