Question

Q.3. Actual monthly sales for 6 months are 1800, 2100, 2000, 2200, 2300 and 2500. Calculate the errors for the 3-monthly simple moving averages on the given actual data​

Answer 1

Answer:

2700

Step-by-step explanation:

2700,2600,2800,2900,2700

Answer 2

GIVEN.

Monthly sales for 6 months are 1800, 2100, 2000, 2200, 2300 and 2500.

TO FIND,

3-monthly simple moving averages

SOLUTION,

we are given the monthly sales for six months 1800, 2100, 2000, 2200, 2300, and 2500.

so we will calculate each 3- months moving average-

• 3- months moving average- $\frac{1800+2100+2000}{3}$  

                                                     =$\frac{5900}{3}$

                                                     = 1966.7

• 3- months moving average- $\frac{2100+2000+2200}{3}$

                                                     = 2100

• 3- months moving average- $\frac{2000+2200+2300}{3}$

                                                      = 2166.7

• 3- months moving average- $\frac{2200+2300+2500}{3}$

                                                      = 2333.3

HENCE THE 3-MONTHS MOVING AVERAGE ARE CALCULATED AND ARE 1966.7, 2100, 2166.7 AND 2333.3.