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

Numerical method, find the newton raphson iterative formula for a reciproca...

find the newton raphson iterative formula for a reciprocal of a number N and hence find the value of 1/23

Calculus, What is the slope of the line tangent to f(x)=3-2 ln(2x^2+4) at t...

What is the slope of the line tangent to f(x)=3-2 ln(2x^2+4) at the point (4, f(4))

Find out primes of each denominator, Find out primes of each denominator: ...

Find out primes of each denominator: Add 1/15 and 7/10 Solution: Step 1:             Find out primes of each denominator. 15 = 5 x 3 10 = 5 x 2 Step 2:

Volume, a data set has a mean of 3, a median of 4, and a mode of 5.which nu...

a data set has a mean of 3, a median of 4, and a mode of 5.which number must be in the data set-3,4,5?

Design a diagram by transformation, On a graph, design a diagram by transfo...

On a graph, design a diagram by transformation the given graph of f (x), -2 ≤ x ≤ 2. Briefly Define the other graphs in terms of f (x) and specify their domains. The diagram n

What is the measure of its width if its length is 3 inches, The perimeter o...

The perimeter of a rectangle is 21 inches. What is the measure of its width if its length is 3 inches greater than its width? Let x = the width of the rectangle. Let x + 3 = th

Decision-making under conditions of uncertainty, Decision-Making Under Cond...

Decision-Making Under Conditions of Uncertainty With decision making under uncertainty, the decision maker is aware of different possible states of nature, but has insufficient

Progressions, We will look at three types of progressions called Ar...

We will look at three types of progressions called Arithmetic, Geometric and Harmonic Progression. Before we start looking at the intricacies of these let us unders

Triangles, The sides of a triangle are x^(2 )+x+1, 2x+1,x^2-1, prove that t...

The sides of a triangle are x^(2 )+x+1, 2x+1,x^2-1, prove that the largest angle is 120 degrees, and find range of x. Ans) The biggest side is x^(2) + x + 1 so findout the angl

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