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

Activity example of one to one correspondence learning, Devise one activity...

Devise one activity each to help the child understand 'as many as' and 'one-to-one correspondence'. Try them out on a child/children in your neighbourhood, and record your observat

Complementary addition model, E1) How is the 'comparison model' different...

E1) How is the 'comparison model' different from the 'complementary addition model'? E2) Create one word problem related to the children's world for each of the 4 models liste

Explain linear equations, Explain Linear Equations ? Set of ordered pai...

Explain Linear Equations ? Set of ordered pairs of numbers A set is an undefined term and we describe it as a "well defined" collection. We use the symbol "{ }" to denote "a se

What is the continuously compounded forward rate, At time t an investor s...

At time t an investor shorts a $1 face value zero coupon bond that matures at time T = t and uses the entire proceeds to purchase a zero coupon bond that matures at time

Evaluate the volume of a basketball along with the volume, Dawn wants to ev...

Dawn wants to evaluate the volume of a basketball along with the volume of a tennis ball. Which formula will she use? The volume of a sphere is 4/3 times π times the radius cub

I am mathematics expert, i want some assignment for earning i am mathemati...

i want some assignment for earning i am mathematics expert plz provide us mathematics assignment as soon as possible

Find out the next number 320, Find out the next number in the subsequent pa...

Find out the next number in the subsequent pattern. 320, 160, 80, 40, . . . Each number is divided by 2 to find out the next number; 40 ÷ 2 = 20. Twenty is the next number.

Homotopy, prove same homotopy type is an equivalent relation

prove same homotopy type is an equivalent relation

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