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

Graphs, How do I graph a round robin pool tournment with 6 players using gr...

How do I graph a round robin pool tournment with 6 players using graph theory

What are the properties of normal distribution, What are the properties of ...

What are the properties of Normal distribution? The normal curve is symmetrical when p=q or p≈q The normal curve is a single peaked curve The normal curve is asymptotic t

QUANITATIVE METHODS, COMMENT ON QUANTITATIVE TECHNIQUES IS A SCIENTIFIC AND...

COMMENT ON QUANTITATIVE TECHNIQUES IS A SCIENTIFIC AND FOR ENHANCING CREATIVE AND JUDICIOUS CAPABILITIES OF A DECISION MAKER

Poisson mathematical properties, Poisson Mathematical Properties 1. Th...

Poisson Mathematical Properties 1. The expected or mean value = np = λ Whereas; n = Sample Size p = Probability of success 2. The variance = np = ? 3. Standard dev

Example of circle graphs, Q. Example of circle graphs? Ans. The Un...

Q. Example of circle graphs? Ans. The United States Government pays obligations annually, called "outlays". Medicare contributes to the health and well being of aged an

Matrix, find the value of x for which [1 0] [0 x-8]

find the value of x for which [1 0] [0 x-8]

Calculate the limit of f (-4), Let's take a look at one more example to ens...

Let's take a look at one more example to ensure that we've got all the ideas about limits down that we've looked at in the last couple of sections. Example: Given the below gr

How many cubic yards of concrete are required, A concrete retaining wall is...

A concrete retaining wall is 120 feet long with ends shaped as given. How many cubic yards of concrete are required to construct the wall? a. 217.8 yd 3 b. 5,880 yd 3

Comparison test for improper integrals - integration, Comparison Test for I...

Comparison Test for Improper Integrals Here now that we've seen how to actually calculate improper integrals we should to address one more topic about them.  Frequently we ar

Find the distance of the journey, A train covered a certain distance at a u...

A train covered a certain distance at a uniform speed.  If the train would have been 6km/hr faster, it would have taken 4hours less than the scheduled time.   And if the train were

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