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

Introducing counting, INTRODUCING COUNTING : From what you studied previou...

INTRODUCING COUNTING : From what you studied previous study, you know what it means to count. You would also agree that rote learning of number names does not always mean that the

Linear algebra, i have question like proof, can you please help me on it?

i have question like proof, can you please help me on it?

Show that the function f is one-one but not onto, Consider the function f: ...

Consider the function f: N → N, where N is the set of natural numbers, defined by f(n) = n 2 +n+1. Show that the function f is one-one but not onto. Ans: To prove that f is one

Numerical method, The Stefan-Boltzmann law can be employed to estimate the ...

The Stefan-Boltzmann law can be employed to estimate the rate of radiation of energy H from a surface of copper sphere with radius = 0.15 ±0.01 m, as in H=AesT^4 where H is in watt

Calculus, what is a domain of a function?

what is a domain of a function?

Define regression, Define regression. The main reason of curve fitting ...

Define regression. The main reason of curve fitting is to estimate one of the variables (the dependent variable) from the other (the independent variable). The procedure of est

Determine the inverse function f ( x ), Given f ( x ) = 3x - 2 determine ...

Given f ( x ) = 3x - 2 determine     f -1 ( x ) . Solution Now, already we know what the inverse to this function is as already we've done some work with it.  Though, it

Find the rate at which its tip is moving, If the minute hand of a big clock...

If the minute hand of a big clock is 1.05 m long, find the rate at which its tip is moving in cm per minute.

Prime ideals, Excuse me, would you give me main points on prime ideals to d...

Excuse me, would you give me main points on prime ideals to do project

Quadratic equation, What do we mean by the roots of a quadratic equation ?

What do we mean by the roots of a quadratic equation ?

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