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

Área de un rectangulo, calcula el área de la región sombreada de un rectáng...

calcula el área de la región sombreada de un rectángulo cuya base es 12.6 cm y su altura es 8.4

Fractions, A recipe calls for 2 1/4 teaspoons of salt for every 1 1/8 teasp...

A recipe calls for 2 1/4 teaspoons of salt for every 1 1/8 teaspoons of black pepper used. How many teaspoons of salt are needed for each teaspoon of pepper used ?

Are parrellel meet at infinity?, no the parallel lines do not meet at infin...

no the parallel lines do not meet at infinity because the parallel lines never intersect each other even at infinity.if the intersect then it is called perpendicuar lines

Coin problem, Explain Coin Problem? How to resolve Coin Problem? Explain br...

Explain Coin Problem? How to resolve Coin Problem? Explain brief...

Method for simultaneous equations of two or more variables, Method In ...

Method In this method we eliminate either x or y, get the value of other variable and then substitute that value in either of the original equations to

Define a complete lattice, Define a complete lattice and give one example. ...

Define a complete lattice and give one example. Ans:  A lattice (L, ≤) is said to be a complete lattice if, and only if every non-empty subset S of L has a greatest lower bound

Rewriting percent expressions, i have trouble going through problem in this...

i have trouble going through problem in this lesson. Markdown and Markups are theh ones im stuck in

Example of integration strategy - integration techniques, Evaluate the subs...

Evaluate the subsequent integral. ∫ (tan x/sec 4 x / sec 4 x)  dx Solution This kind of integral approximately falls into the form given in 3c.  It is a quotient of ta

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