Calculate moving average, Mathematics

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.

Posted Date: 2/16/2013 7:32:42 AM | Location : United States







Related Discussions:- Calculate moving average, Assignment Help, Ask Question on Calculate moving average, Get Answer, Expert's Help, Calculate moving average Discussions

Write discussion on Calculate moving average
Your posts are moderated
Related Questions
Provide the vector for each of the following. (a) The vector from (2, -7, 0) -  (1, - 3, - 5 ) (b) The vector from (1,-3,-5) - (2, - 7, 0) (c) The position vector for ( -

Is there any class in expertsmind for second year english.?

The length of Kara's rectangular patio can be expressed as 2x - 1 and the width can be expressed as x + 6. In the terms of x, what is the area of her patio? Since the area of a

Newton's Second Law of motion, which recall from the earlier section that can be written as: m(dv/dt) = F (t,v) Here F(t,v) is the sum of forces which act on the object and m

Equation of line joining(0,0)and point of intersection of X2+Y2+2XY=4 , 3x2+5y2-xy=7 is solution) The two equations above represent pair of straight lines. We can complete the sq

From a sheet of cardboard in the shape of a square of side 14 cm, a piece in the shape of letter B is cut off. The curved side of the letter consists of two equal semicircles & the

The equation ax2 + 2hxy + by2 =0 represents a pair of straight lines passing through the origin and its angle is tan q = ±2root under h2-ab/(a+b) and even the eqn ax2+2hxy+by2+2gx+

Complex numbers from the eigenvector and the eigenvalue. Example1 : Solve the following IVP. We first require the eigenvalues and eigenvectors for the given matrix.