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

What is the sample space for this experiment, A die is thrown repeatedly un...

A die is thrown repeatedly until a six comes up. What is the sample space for this experiment? HINT ;A= {6} B={1,2,3,4,5,} Ans: The sample space is = {A, BA, BBA, BBBA, BBBBA.

Illustration of rank correlation coefficient, Illustration of Rank Correlat...

Illustration of Rank Correlation Coefficient Sometimes numerical data such refers to the quantifiable variables may be described after which a rank correlation coefficient may

Estimate the grade resistance, The grade resistance is F=W sin θ, where θ i...

The grade resistance is F=W sin θ, where θ is the grade and W is the weight of the automobile.  What is the grade resistance of a 2500 pound car traveling on a 2.6 degree uphill gr

Solve following x - x e 5 x + 2 = 0 logarithms, Solve following  x - x  ...

Solve following  x - x  e 5 x + 2   = 0 . Solution : The primary step is to factor an x out of both terms. DO NOT DIVIDE AN x FROM BOTH TERMS!!!! Note as well that it i

The median- graphical method -progression , The median - it is a stati...

The median - it is a statistical value which is usually located at the center of a given set of data that has been organized in the order of size or magnitude as illustrating,

Statistics, The winning team''s score in 21 high school basketball games wa...

The winning team''s score in 21 high school basketball games was recorded. If the sample mean is 54.3 points and the sample standard deviation is 11.0 points, find the 90% confiden

Algebra, Manuel is a cross-country runner for his school’s team. He jogged ...

Manuel is a cross-country runner for his school’s team. He jogged along the perimeter of a rectangular field at his school. The track is a rectangle that has a length that is 3 tim

Harmonic progression (h.p.), Three quantities a, b and c are said to ...

Three quantities a, b and c are said to be in harmonic progression if, In this case we observe that we have to consider three terms in o

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