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

Decimals, how will the decimal point move when 245.398 is multiplied by 10

how will the decimal point move when 245.398 is multiplied by 10

Algebra, prove That J[i] is an euclidean ring

prove That J[i] is an euclidean ring

Prime Ideals, Given a standard 2x3 matrix show the ideal formed by the 2x2 ...

Given a standard 2x3 matrix show the ideal formed by the 2x2 minors is Prime.

Evaluate the slope of the tangent line, Evaluate the given limits, showing ...

Evaluate the given limits, showing all working: Using first principles (i.e. the method used in Example 1, Washington 2009, Using definition to find derivative ) find the

Algebra2;, log6 X + log6 (x-5) = 1

log6 X + log6 (x-5) = 1

Circles, Two tangents TP and TQ are drawn to a circle with center O from an...

Two tangents TP and TQ are drawn to a circle with center O from an external point T.prove that angle PTQ=angle 2 OPQ

Student, What is the slope and y intercept for (6,5) (-3,8)

What is the slope and y intercept for (6,5) (-3,8)

Find relative extrema f ( x ) = x2 on [-2, Recognizes the absolute extrema...

Recognizes the absolute extrema & relative extrema for the given function.  f ( x ) = x 2        on                  [-2, 2] Solution Following is the graph for this fun

Prove that a tree with n vertices has n - 1 edges, Prove that A tree with n...

Prove that A tree with n vertices has (n - 1) edges.    Ans: From the definition of a tree a root comprise indegree zero and all other nodes comprise indegree one. There should

Reason for why limits not existing, Reason for why limits not existing : I...

Reason for why limits not existing : In the previous section we saw two limits that did not.  We saw that did not exist since the function did not settle down to a sing

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