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

Mental math, i dint get how to do math promblems

i dint get how to do math promblems

Linear equation, tens digit of a 2-digit number is twice its unit digit. If...

tens digit of a 2-digit number is twice its unit digit. If the sum of the digit is 12, find the number.

Describe laws of cosines, Q. Describe Laws of Cosines? The law of cosin...

Q. Describe Laws of Cosines? The law of cosines is used to find the missing piece of a triangle if we are given either 1. Two sides and the included angle (SAS) or  2. All t

Determine y inverse for x2 + y 4 = 10, Determine  y′′  for           ...

Determine  y′′  for                                x 2 + y 4   = 10 Solution: We know that to get the second derivative we required the first derivative and to get that w

Describe the types of triangles, Describe the Types of triangles ? Tria...

Describe the Types of triangles ? Triangles can be classified according to the lengths of the sides or the measures of the angles. 1. Naming triangles by sides An

Ratios, the ratio of boys to girls in the sixth grade is 2:3 if there are ...

the ratio of boys to girls in the sixth grade is 2:3 if there are 24 boys, how many are girls?

What is a lattice, What is a lattice? Which of the following graphs are lat...

What is a lattice? Which of the following graphs are lattice and why? Ans:  Let (L, ≤) be a poset. If each subset {x, y} consisting of any two elements of L, comprises a glb (I

The probability that five randomly selected 3-year old snake, The probabili...

The probability that a randomly selected 3-year old garter snake will live to be 4 years old is .54 (assume results are independent).  What is the probability that five randomly se

Power series - sequences and series, Power Series We have spent quite...

Power Series We have spent quite a bit of time talking about series now and along with just only a couple of exceptions we've spent most of that time talking about how to fin

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