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

Conjugate of the complex number, The conjugate of the complex number a + b ...

The conjugate of the complex number a + b i is the complex number a - b i .  In other terms, it is the original complex number along the sign on the imaginary part changed.  Here

Bill traveled 117 miles in 2.25 hours what was his average, Bill traveled 1...

Bill traveled 117 miles in 2.25 hours. What was his average speed? Use the formula d = rt (distance = rate × time). Substitute 117 miles for d. Substitute 2.25 hours for t and

Cynthia, #stioquen..Store A is advertising a sale that will reduce prices o...

#stioquen..Store A is advertising a sale that will reduce prices on all merchandise by 15%. Store B is advertising a sale that will reduce prices on all merchandise by one over fiv

Standard interpretations to derivatives, Standard interpretations to deriva...

Standard interpretations to derivatives Example   Assume that the amount of money in a bank account is specified by                                       P (t ) = 500 + 10

Geometric interpretation of the cross product, Geometric Interpretation of ...

Geometric Interpretation of the Cross Product There is as well a geometric interpretation of the cross product.  Firstly we will let θ be the angle in between the two vectors a

Computed the total cost y of a ride which was x miles, A ride in a taxicab ...

A ride in a taxicab costs $1.25 for the first mile and $1.15 for each additional mile. Which of the following could be used to computed the total cost y of a ride which was x miles

Calculate what number of workers should be hired, You are given the followi...

You are given the following information about the amount your company can produce per day given the number of workers it hires. Numbers of Workers Quanti

Derive the marshalian demand functions, (a) Derive the Marshalian demand fu...

(a) Derive the Marshalian demand functions for the following utility function: u(x 1 ,x 2 ,x 3 ) = x 1 + δ ln(x 2 )       x 1 ≥ 0, x 2 ≥ 0 Does one need to consider the is

Describe the laws of sines, Q. Describe the Laws of Sines? Ans. Up...

Q. Describe the Laws of Sines? Ans. Up to now we have dealt exclusively with right triangles.  The Law of Sines and the Law of Cosines are used to solve  oblique triangles

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