|
|
|
|
|
|
|
|
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 |
|
Example1) 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,1Solution:The value of table for `x` and `y` | x | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
|---|
| y | 5.2 | 4.9 | 5.5 | 4.9 | 5.2 | 5.7 | 5.4 | 5.8 | 5.9 | 6 | 5.2 | 4.8 |
|---|
The weights of the 3 years are respectively 1,2,1 and their sum is 4 Calculation of 3 year moving averages of the data (1)
year | (2)
Sales | (3)
3 year weighted moving total | (4)
3 year weighted moving average
`(3)-:4` | | 1 | 5.2 | | | | 2 | 4.9 | `1xx5.2+2xx4.9+1xx5.5=20.5` | `20.5-:4=5.125` | | 3 | 5.5 | `1xx4.9+2xx5.5+1xx4.9=20.8` | `20.8-:4=5.2` | | 4 | 4.9 | `1xx5.5+2xx4.9+1xx5.2=20.5` | `20.5-:4=5.125` | | 5 | 5.2 | `1xx4.9+2xx5.2+1xx5.7=21` | `21-:4=5.25` | | 6 | 5.7 | `1xx5.2+2xx5.7+1xx5.4=22` | `22-:4=5.5` | | 7 | 5.4 | `1xx5.7+2xx5.4+1xx5.8=22.3` | `22.3-:4=5.575` | | 8 | 5.8 | `1xx5.4+2xx5.8+1xx5.9=22.9` | `22.9-:4=5.725` | | 9 | 5.9 | `1xx5.8+2xx5.9+1xx6=23.6` | `23.6-:4=5.9` | | 10 | 6 | `1xx5.9+2xx6+1xx5.2=23.1` | `23.1-:4=5.775` | | 11 | 5.2 | `1xx6+2xx5.2+1xx4.8=21.2` | `21.2-:4=5.3` | | 12 | 4.8 | | |
|
|
|
|
|
|
|
|
