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

Order of Operations with Fractions, 1.)3 3/8 divided by 4 7/8 plus 3 2.)4 ...

1.)3 3/8 divided by 4 7/8 plus 3 2.)4 1/2 minus 3/4 divided by 2 3/8

Determine the general solution reduction of order, Determine the general so...

Determine the general solution to 2t 2 y'' + ty' - 3y = 0 It given that y (t) = t -1 is a solution.  Solution Reduction of order needs that a solution already be iden

What is the distance this car will travel in (3x - 8) hours, A car travels ...

A car travels at a rate of (4x2 - 2). What is the distance this car will travel in (3x - 8) hours? Use the formula distance = rate × time. Through substitution, distance = (4x2

Maths question, if the numerator of a fraction is decreased by 40% and the ...

if the numerator of a fraction is decreased by 40% and the denominator is increased by 100% the new value is 1. what was the original factor

1, 5 hockey pucks and three hockey sticks cost $23. 5 hockey pucks and 1 ho...

5 hockey pucks and three hockey sticks cost $23. 5 hockey pucks and 1 hockey stick cost $20. How much does 1 hockey puck cost?

Symmetric and anti-symmetric relation on a set, 1. Let A = {1,2, 3,..., n} ...

1. Let A = {1,2, 3,..., n} (a) How many relations on A are both symmetric and anti-symmetric? (b) If R is a relation on A that is anti-symmetric, what is the maximum number o

Sum of a number of terms in g.p., We know that the terms in G.P. are:...

We know that the terms in G.P. are: a, ar, ar 2 , ar 3 , ar 4 , ................, ar n-1 Let s be the sum of these terms, then s = a + ar + ar 2

Sum of a number of terms in a.p., We know that the terms in an ...

We know that the terms in an A.P. are given by a, a + d, a + 2d, a + 3d, ........ a + (n - 2)d, a + (n -  1)d The sum of all t

the speed of the motor boat, A motor boat takes Six hours to cover 100 km ...

A motor boat takes Six hours to cover 100 km downstream and 30 km  upstream. If the motor boat goes 75 km downstream and returns  back to its starting point in 8 hours, find the sp

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