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

Find out the tangent line to the parametric curve, Find out the tangent lin...

Find out the tangent line(s) to the parametric curve specified by X = t5 - 4t3 Y = t2 At (0,4) Solution Note that there is actually the potential for more than on

Who made clothes for, on april 26, jonh dough wrote a check#374 to Miller P...

on april 26, jonh dough wrote a check#374 to Miller Pharmacy for $16.00 , is this a deposit or withdrawal

Algebra, find the value of A and B if the following polynomials are perfect...

find the value of A and B if the following polynomials are perfect square:

Management, An investment manager at TD Ameritrade is making a decision abo...

An investment manager at TD Ameritrade is making a decision about a $10,000,000 investment. There are four portfolio options available and she is looking at annual return of these

Find the surface-radius of earth, a) The distance d that can be seen fro...

a) The distance d that can be seen from horizon to horizon from an airplane varies directly as the square root of the altitude h of the airplane. If d = 213 km for h = 3950

Concurrent deviation method, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE

Definition of higher order derivatives, Higher Order Derivatives : Le...

Higher Order Derivatives : Let's begin this section with the given function.                            f ( x ) = 5x 3 - 3x 2 + 10 x - 5 By this point we have to be a

Algebra, (x+15)/y=10 where y=5

(x+15)/y=10 where y=5

Integers, Whats some negative integers that equal 36

Whats some negative integers that equal 36

Factors in denominator and partial fraction decomposition, Factors in Denom...

Factors in Denominator and Partial Fraction Decomposition Factor in denominator Term in partial  fraction decomposition   ax + b

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