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

Determine the relative global error, Consider the differential equation giv...

Consider the differential equation give by y′ = -10(y - sin t) (a) Derive by hand exact solution that satis?es the initial condition y(0) = 1. (b) Numerically obtain the s

#titlealgebra.., help solve these type equations.-4.1x=-4x+4.5

help solve these type equations.-4.1x=-4x+4.5

Patrice has worked a certain how many hours has she worked, Patrice has wor...

Patrice has worked a certain amount of hours so far this week. Tomorrow she will work four more hours to finish out the week along with a total of 10 hours. How many hours has she

Complementary addition-word problems related to subtraction, Complementary ...

Complementary addition -what number how many things should be added to one number or group to get the other. (e.g., a classroom can seat 50 children, and 20 children are already s

Find a maximum flow and a minimum cut, Use the maximum flow algorithm to fi...

Use the maximum flow algorithm to find a maximum flow and a minimum cut in the given network, where the capacities of arc CF, EC , DE and BD are w = 13, x = 7, y =1, a

Radius of rhim, how long is the radius of car tyre?

how long is the radius of car tyre?

Sums and differences of cubes and other odd powers, Sums and Differences of...

Sums and Differences of Cubes (and other odd powers)? You can factor a sum or difference of cubes using the formulas a 3 - b 3 = (a - b )(a 2 + ab + b 2 ) and a 3 + b 3 =

Trigonmetry, How do I find a bearring using trig?

How do I find a bearring using trig?

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