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

Please help me solve these Problems step by step, What angle (to the neares...

What angle (to the nearest degree) corresponds to the cos 0.6 or what is cos-1(0.6)? (Note: Use Appendix I) What angle (to the nearest degree) corresponds to the sin 0.6 or what

Fractions rates and ratios, In 6th grade I am learning about ratios rates a...

In 6th grade I am learning about ratios rates and fractions. I am working on vmathlive.com and need serious.

Triangle, we have to find the perimeter when 1 rib is 7 cm and another rib...

we have to find the perimeter when 1 rib is 7 cm and another rib is 5 cm

Initial conditions and boundary conditions, Initial Condition...

Initial Conditions and Boundary Conditions In many problems on integration, an initial condition (y = y 0 when x = 0) or a boundary condition (y = y

Explain the graph of an equation and graph of an inequality, Explain The Gr...

Explain The Graph of an Equation and The Graph of an Inequality ? Here is the graph of the equation y = x. Notice that for every point along the line shown in the graph, the y

Listing method, how will you explain the listing method?

how will you explain the listing method?

Calculate the width of the river, A surveyor is hired to calculate the widt...

A surveyor is hired to calculate the width of a river. Using the example provided, Calculate the width of the river. a. 48 ft b. 8 ft c. 35 ft d. 75 ft

Errors are useful in learning maths, Errors Are Useful :  While teaching c...

Errors Are Useful :  While teaching children, you must have found theft making mistakes off and on. How do you respond to the errors'? What do they tell you about the child-failur

Unipolar and bipolar boolean inputs, A 4-input Neuron has weights (1,-1,  0...

A 4-input Neuron has weights (1,-1,  0,  0.5.Calculate the network output when the following input vectors are applied. For calculation assume: a. f(net) = unipolar bina

Find out the variance and standard deviation, The probability of a rare dis...

The probability of a rare disease striking a described population is 0.003. A sample of 10000 was examined. Determine the expected no. suffering from the disease and thus find out

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