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
Brewery has 12 oz bottle filling machines.  Amount poured by machine is normal distribution mean 12.39 oz  SD 0.04 oz. Company is interested in in reducing the amount of extra beer

For the given function recognize the intervals where the function is increasing and decreasing and the intervals where the function is concave up & concave down. Utilizes this info

If A, B are acute angles and sinA= cosB, then find the value of A+B. Ans:    A + B = 90 o


is this free for LIFE that means forever never ever going to pay

From top of a tower a stone is thrown up and it reaches the ground in time t1. A second stone is thrown down with the same speed and it reaches the ground in t2. A third stone is r

Solve -10 cos(3t )= 7 on [-2,5]. Solution Let's first get the inverse cosine portion of this problem taken care of. cos(3 t )= -  7/10            ⇒     3t = cos -1 ( - 7

Sharon needs to make 25 half-cup servings of soup. How many ounces of soup does she required? One cup is 8 ounces, so half a cup is 4 ounces. Multiply 25 by 4 ounces to find ou

Ask question #suppose that components of a contravariant vector A^i (for n=3)in the coordinate system (x^1,x^2,...,x^n) are A=x,A=y,A=z.Find the components A^p of the vector in the

Hi, this is EBADULLA its about math assignment. 1 application of complex analysis used in thermodynamics. . what all uses are there in that... plz let mee know this answer.