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

Explain the common forms of linear equations, Explain the Common Forms of L...

Explain the Common Forms of Linear Equations ? An equation whose graph is a line is called a linear equation. Here are listed some special forms of linear equations. Why should

Triangles, ABCD is a parallelogram which AB and CD are divides by P and Q. ...

ABCD is a parallelogram which AB and CD are divides by P and Q. Such that AP:PB=3:2 and CQ:QD=4:1. If PQ and AC are meet at R, show that AR=3/7AC.

Show trigonometric functions on a graph, Q. Show Trigonometric Functions on...

Q. Show Trigonometric Functions on a Graph? Ans. By discussing the trig functions with respect to an angle in a right-angle triangle, we have only considered angles betwee

Introduction to multiplication and division, INTRODUCTION :  When a Class ...

INTRODUCTION :  When a Class 5 child was given the problem 'If I paid Rs. 60 for 30 pencil boxes, how much did b pencil box cost?', he said it would be 60 x 30 = 1800. This

Determine centigrade equivalent for a temperature, 1. 10 -2 is equal to ...

1. 10 -2 is equal to 2. If 3n = 27, what is the value of (4n) + 1 3. What is 1/100 of 10000? 4. The formula C=5/9 x (F-32) converts Centigrade temperature from Fa

..Job, Eddie mkes $15.75 per hour. Estimate how much Eddie will make per ye...

Eddie mkes $15.75 per hour. Estimate how much Eddie will make per year if he works 40 hours per week and 50 weeks per year.

Divisiblety test, find the greater value of a and b so that the following e...

find the greater value of a and b so that the following even numbers are divisible by both 3 and 5 : 2ab2a

The stoichiometric reaction, Prove that a reaction following the rate law v...

Prove that a reaction following the rate law v = k[A] 2 is characterized by a linear plot of [P] t 1 versus t-l, where P is the product of the stoichiometric reaction A = P. Sho

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