Calculate moving average, Mathematics

Assignment Help:

Calculate Moving Average

The table given below represents company sales; calculate 3 and 6 monthly moving averages, for data

Months

Sales

January

1200

February

1280

March

1310

April

1270

May

1190

June

1290

July

1410

August

1360

September

1430

October

1280

November

1410

December

1390

Solution

These are calculated as given below:

April's forecast =  (Jan + Feb + Mar)/3 =  (1200 + 1280 + 1310)/3

May's forecast =  (Feb + Mar + Apr )/3  = (1280 + 1310 + 1270)/3

And so on...

Similarly for 6 monthly moving average

July forecast = (Jan + Feb + Mar + Apr + Jun)/6

= (1200 + 1280 + 1310 + 1270 + 1190 + 1290)/6

And so on...

 

3 months moving average

6 months moving average

April

1263

 

May

1287

 

June

1257

 

July

1250

1257

August

1297

1292

September

1353

1305

October

1400

1325

November

1357

1327

December

1373

1363

Note:

While plotting moving average on graphs the points are plotted as the midpoint of the period of the average, for illustration in our example the forecast for April (1263) is plotted on mid Feb.


Related Discussions:- Calculate moving average

What is the average temperature on the celsius scale, Peggy's town has an a...

Peggy's town has an average temperature of 23° Fahrenheit in the winter. What is the average temperature on the Celsius scale? If the total amount for both is 80, after that th

Differntial equation, (3x+2)^2 d^2y/dx^2+3(3x+2)dy/dx-36y=3x^2+4x+1

(3x+2)^2 d^2y/dx^2+3(3x+2)dy/dx-36y=3x^2+4x+1

Statistics, How do I choose a distribution test for a sample size of 60? Pr...

How do I choose a distribution test for a sample size of 60? Probability of rolling a 4 on a six sided die.

Plus, 236+2344+346=

236+2344+346=

Multiplying fractions involving negative numbers, Q. Multiplying Fractions ...

Q. Multiplying Fractions Involving Negative Numbers? Ans. If you have only one negative sign, the result is still negative: If you have more than one, just remembe

Trigonmetry, On your geometry test you have two triangles: ?ABC and ?MNO. Y...

On your geometry test you have two triangles: ?ABC and ?MNO. You are told that ?A ? ? M and that ?B ? ? N. Which statement is also true?

What distances from the two gates should the pole, A pole has to be erected...

A pole has to be erected at a point on the boundary of a circular park of diameter 13m in such a way that the differences of its distances from two diametrically opposite fixed gat

Repetition need not be boring-ways to aid learning maths, Repetition Need N...

Repetition Need Not Be Boring :  From an early age on, children engage in and learn from repetitive behaviour, such as dropping and picking up things, opening and closing boxes an

#calculus, Ask question #divergent gradient u vector#

Ask question #divergent gradient u vector#

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd