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

Integrated marketing, #question.Explain its nature and how it influences th...

#question.Explain its nature and how it influences the integrated marketing communications mix and distinguish between tactical and strategic use of integrated marketing communicat

Example of 3-d coordinate system, Example of 3-D Coordinate System Exam...

Example of 3-D Coordinate System Example: Graph x = 3 in R, R 2 and R 3 .   Solution In R we consist of a single coordinate system and thus x=3 is a point in a 1-D co

Determine the probability, Determine the Probability From a pack of pl...

Determine the Probability From a pack of playing cards what is the probability of; (i)  Picking either a 'Diamond' or a 'Heart' → mutually exclusive (ii) Picking either

Relations, test is tomorrow, don''t know anything lol, please help

test is tomorrow, don''t know anything lol, please help

Powerball odds., I need to know how to get the power ball odds. the first o...

I need to know how to get the power ball odds. the first one 5 out of 59 plus 1 out of 35 I got .I did combination formula and it came out right. how do you get 5 out 0f 59 and get

Matrices, Ask qudefination of empty matrixestion #Minimum 100 words accepte...

Ask qudefination of empty matrixestion #Minimum 100 words accepted#

What is the smallest possible number 3, What is the smallest possible numbe...

What is the smallest possible number in which can be created along with four decimal places using the numbers 3, 5, 6, and 8? Place the smallest number in the largest place val

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