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

Vectors, why minimum three coplanar vectors are required to give zero resul...

why minimum three coplanar vectors are required to give zero resultant and not two?

Draw the state diagram - transition function, 1. Let M be the PDA with stat...

1. Let M be the PDA with states Q = {q0, q1, and q2}, final states F = {q1, q2} and transition function δ(q0, a, λ) = {[q0, A]} δ(q0, λ , λ) = {[q1, λ]} δ(q0, b, A) = {[q2

Differentiate outline function in chain rules, Differentiate following. ...

Differentiate following. Solution : It requires the product rule & each derivative in the product rule will need a chain rule application as well. T ′ ( x ) =1/1+(2x) 2

Wave through the origin always has a slope of one or not, Can you explain t...

Can you explain that a wave through the origin always has a slope of one or not?

Bottleneck for each product, A company makes 2 products, Product A and Prod...

A company makes 2 products, Product A and Product B. The product characteristics are shown in the following table. Product A B

Determine how many player play foot ball, Determine How many player play fo...

Determine How many player play foot ball? In a group of athletic teams in a specific institute, 21 players are in the basket ball team, 26 players in the hockey team, 29 player

Fiancial project, With your current loan, explain how much additional money...

With your current loan, explain how much additional money you would need to add to your monthly payment to pay off your loan in 20 years instead of 25. Decide whether or not it wou

Find fourier series, Question: Find Fourier series for the periodic fun...

Question: Find Fourier series for the periodic function of period 2 π,defined by      f(x) = x 4 ,  - π ≤ x ≤ π

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