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
Question: Let f be a quartic polynomial (ie. a polynomial of degree 4). Suppose that f has zeros at -2; 1; 3; 4 and that f(0) = 4. Sketch a graph of f. If f(x) is

Question A 22 kW, 3-phase, 415 V, 40 A, 50 Hz, 960 rpm, 0.88 PF squirrel cage induction motor drives a pump. The total inertia of the drives system is 1.2 kg-m2. Determine th

How to find total no. of unordered pairs of disjoint subsets of a finite set? Solution) Suppose A and B are two such disjoint subsets of the set S. Then every element can go into

Determine the second derivative for following functions.                             Q (t ) = sec (5t ) Solution : Following is the first derivative.              Q′ (t

Katie's school has a rectangular courtyard whose area can be expressed as 3x 2 - 7x + 2. Which of the following could be the dimensions of the courtyard in terms of x? Since t

Ut=Uxx+A exp(-bx) u(x,0)=A/b^2(1-exp(-bx)) u(0,t)=0 u(1,t)=-A/b^2 exp(-b)

A box contains 12 balls out of which x are black. If one ball is drawn at random from the box, what is the probability that it will be a black ball? If 6 more black balls are put i

TRIGONOMETRY : "The  mathematician  is  fascinated  with  the  marvelous  beauty  of the forms  he  constructs,  and  in their  beauty  he  finds  everlasting  truth." Example:

Ten is decreased through four times the quantity of eight minus three. One is then added to in which result. What is the final answer? The area of a square whose side measures

Consider the following parlor game to be played between two players. Each player begins with three chips: one red, one white, and one blue. Each chip can be used only once. To beg