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

Find out the x-intercepts, Find out the x-intercepts & y-intercepts for eac...

Find out the x-intercepts & y-intercepts for each of the following equations.                            y =x 2 +x - 6 Solution As verification for each of these we wil

#i need help on my math homework its on algabraitle.., The question is: If ...

The question is: If 0.2 x n = 1.4,what is the value of n.

What is angle pairs in parallel lines, What is Angle Pairs in Parallel Line...

What is Angle Pairs in Parallel Lines ? Next, we introduce several angle pairs formed by transversals which are very important in our study of geometry. Alternate interior an

Project, report on shares and dividend using newspaper

report on shares and dividend using newspaper

Geometry., solve for y given that 3sin^2 y+cos y-1=0 for 0y360

solve for y given that 3sin^2 y+cos y-1=0 for 0y360

Alphabet is any arrangement , A word on an alphabet is any arrangement of t...

A word on an alphabet is any arrangement of the letters in the alphabet. For example,ODD, DOD, DOO, DDD are three-letter words on the alphabet {D,O}. How many four-letter words are

Tangent, Tangent, Normal and Binormal Vectors In this part we want to ...

Tangent, Normal and Binormal Vectors In this part we want to look at an application of derivatives for vector functions.  In fact, there are a couple of applications, but they

Four distinct points on a circle, If (a,1/a), (b,1/b),(c,1/c),(d,1/d) are f...

If (a,1/a), (b,1/b),(c,1/c),(d,1/d) are four distinct points on a circle of radius 4 units then,abcd is equal to??   Ans) As they are of form (x,1/x) let eq of circle be x

Linear relations, determine the equation that represent the following lines...

determine the equation that represent the following lines be sure to define your variable and show all of your work

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