Answer:
fill in the blank 1 =20
fill in the blank 2 =20.25
fill in the blank 3 = 19.4
fill in the blank 4 = 19.75
fill in the blank 5 =19.6
fill in the blank 6 = 19.25
fill in the blank 7=19.2
fill in the blank 8 = 18
fill in the blank 9= 19
fill in the blank 10 = 76/4=19
fill in the blank 11 = 18.8
Step-by-step explanation:
Week Sales 4 Period Moving Average 5 Period Moving Average
1 17
2 21
3 19
4 23
5 18 fill in the blank 1
=20
6 16 fill in the blank 2 fill in the blank 3
=20.25 19.4
7 20 fill in the blank 4 fill in the blank 5
19.75 19.6
8 18 fill in the blank 6 fill in the blank 7
19.25 19.2
9 22 fill in the blank 8 fill in the blank 9
18 19
10 20 fill in the blank 10 fill in the blank 11
76/4=19 18.8
11 15 fill in the blank 12 fill in the blank 13
20 19.2
12 22 fill in the blank 14 fill in the blank 15
18.75 19
The formula used for moving average is
a1= 1/4 ( W1+W2+W3+W4)
a2= 1/4 ( W2+W3+W4+ W5)
a3= 1/4( W3+W4+ W5+W6)
and so on
Where W1= week 1, W2= week 2 ,W3= week3
a1= 1st average , a2= 2nd average
The similar process is used for five year moving average
a1= 1/5 ( W1+W2+W3+W4)
a2= 1/5 ( W2+W3+W4+ W5)
a3= 1/5( W3+W4+ W5+W6)
Only it is divided by 5 instead of 4
