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

Interpolation and extrapolation, Interpolation is a method of s...

Interpolation is a method of statistical estimation and the word literally means 'making insertions'. Let us consider a well-known situation whi

Linear equation, The sum of the digit number is 7. If the digits are revers...

The sum of the digit number is 7. If the digits are reversed , the number formed is less than the original number. find the number

Pharmacy technician, Tetracycline 500 mg capsules Sig: 1 cap po bid for 14...

Tetracycline 500 mg capsules Sig: 1 cap po bid for 14 days. Refills: 2 What is the dose of this medication:____________________ (0.5 point) How many doses are given per day:______

Right- and left-handed limits , Right- and left-handed limits : Next, let'...

Right- and left-handed limits : Next, let's see precise definitions for the right- & left-handed limits. Definition   For the right-hand limit we say that, if for eve

Find out the maximum number of ounces she can ship for $10, The cost of shi...

The cost of shipping a package by Shipping Express is $4.85 plus $2 per ounce of the weight of the package. Sally only has $10 to spend on shipping costs. Which of the subsequent c

Stakeholders, what is the benefit for stakeholders or disadvantage in a mon...

what is the benefit for stakeholders or disadvantage in a monoply

Example of cartesian coordinate graph, Example of Cartesian coordinate Grap...

Example of Cartesian coordinate Graph: Example:   The temperature of water flowing in a high pressure line was measured at regular intervals.  Plot the subsequent recorded da

Managment Science, Classify models based on the degree of their abstraction...

Classify models based on the degree of their abstraction, and provide some examples of such models.

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