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 percent of increase heating oil, The price of heating oil rose ...

The price of heating oil rose from $1.10 per gallon to $1.43 per gallon. What is the percent of increase? The price of heating oil rose $0.33 ($1.43 - $1.10 = $0.33). To ?nd ou

Example of fraction, Example  Reduce 24/36 to its lowest terms. 2...

Example  Reduce 24/36 to its lowest terms. 24/36=12/18=6/9=2/3. In the first step we divide the numerator and the denominator by 2. The fraction gets reduced

Newtons method , Newton's Method : If x n is an approximation a solution ...

Newton's Method : If x n is an approximation a solution of f ( x ) = 0 and if given by, f ′ ( x n ) ≠ 0 the next approximation is given by

Example of factoring quadratic polynomials, Factor following polynomials. ...

Factor following polynomials.                               x 2 + 2x -15 Solution x 2 +2x -15 Okay since the first term is x 2 we know that the factoring has to ta

Applications of integrals, Applications of Integrals In this part we're...

Applications of Integrals In this part we're going to come across at some of the applications of integration.  It should be noted also that these kinds of applications are illu

Which of the subsequent terms does not describe the number 9, Which of the ...

Which of the subsequent terms does NOT describe the number 9? Nine is NOT prime since it has 3 factors; 1, 3, and 9. Prime numbers have only 2 factors.

Julie had $500 how much money did julie spend, Julie had $500. She spent 20...

Julie had $500. She spent 20% of it on clothes and then 25% of the remaining money on CDs. How much money did Julie spend? Find out 20% of $500 by multiplying $500 by the decim

what is probability that point will be chosen from triagle, In the adjoini...

In the adjoining figure ABCD is a square with sides of length 6 units points P & Q are the mid points of the sides BC & CD respectively. If a point is selected at random from the i

What difference among the areas of the two sections of a, If the areas of t...

If the areas of two sections of a garden are 6a + 2 and 5a, what is the difference among the areas of the two sections within terms of a? Because the question asks for the diff

How much did sally earn if she worked 48 hours, Sally gets paid x dollars p...

Sally gets paid x dollars per hour for a 40-hour work week and y dollars for every hour she works over 40 hours. How much did Sally earn if she worked 48 hours? Since she worke

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