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
1.   The length of a rectangle is 2 times its width.  The area of the rectangle is 72          square inches. Find the dimensions of the rectangle.   2.   The length of a rec

who discovered unitary method

if a circles diameter is 42 mm its radius is _________________ because ________________________.

Jessica has a picture in a frame with a total area of 288 in2. The dimension of the picture without the frame is 12 in through 14 in. What is the larger dimension, in inches, of th

I have a simple right angle triangle. All I am given is h (the hypotenuse) and that ratio of x:y is 2:3. What is the formula to find x and y in terms of h?


a) Determine the distance traveled among t = 0 and  t =∏/2 by a particle P(x, y) whose position at time t is given by Also check your result geometrically.  (5) b) D

Graph     ( x - 2) 2 /9+4(y + 2) 2  = 1 Solution It is an ellipse. The standard form of the ellipse is                                                         ( x - h

How to Find the range of a function ? Sigh. Students ask me this all the time. They don't want an explanation, they want a procedure. "Tell me the steps!" Unfortunately, th

The operator of an amusement park game remain track of how many tries it took participants to win the game. The subsequent is the data from the ?rst ten people: 2, 6, 3, 4, 6, 2, 8