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

Shares and dividend, a man in rested rupee 800 is buying rupee 5 shares and...

a man in rested rupee 800 is buying rupee 5 shares and then are selling at premium of rupee 1.15. He sells all the shares.find profit

Numerical integration - simpson rule, (1)Derive, algebraically, the 2nd ord...

(1)Derive, algebraically, the 2nd order (Simpson's Rule) integration formula using 3 equally spaced sample points, f 0 ,f 1 ,f 2 with an increment of h. (2) Using software such

Algorithm for division, Also, their inability to apply the algorithm for di...

Also, their inability to apply the algorithm for division becomes quite evident. The reason for these difficulties may be many. We have listed some of them below. 1) There are n

An amortization, Ahmad borrowed $450000.00 at 3% compounded semi-annually f...

Ahmad borrowed $450000.00 at 3% compounded semi-annually for ten years to buy an apartment. Equal payments are made at the end of every six months. a) Determine the size of the se

Definition of minimum and maximum values, Definition 1.   We say that f...

Definition 1.   We say that f(x) consist an absolute (or global) maximum at x = c if f ( x ) ≤ f (c ) for every x in the domain we are working on. 2.  We say that at x = c ,

Upper limit of normal , Frequently, tests that yield abnormal results are r...

Frequently, tests that yield abnormal results are repeated for confirmation.  What is the probability that for a usual person a test will be at least 1.5 times as high as the upper

What is factoring of polynomials, What is Factoring of Polynomials? Fac...

What is Factoring of Polynomials? Factoring means much the same thing for polynomials as it does for integers. When you multiply several polynomials together, The polyn

Slope, One of the more significant ideas that we'll be discussing in this s...

One of the more significant ideas that we'll be discussing in this section is slope. The slope of a line is a measure of the steepness of any particular line and it can also be uti

Basic statistics, #questio Study A Stu...

#questio Study A Study B Study C x2 = 1.683 F = 7.357 r = .83 df = 4

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