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

Shares and dividends, suresh invested rs.1080 in shares of face value rs.50...

suresh invested rs.1080 in shares of face value rs.50 at rs.54.After receiving dividend on them at 8% he sold them at 52.In each of the transaction he paid 2 % brokerage.Hpw much d

Objectives of learning to count, Objectives :  After studying this unit, y...

Objectives :  After studying this unit, you should be able to : 1.   explain the processes involved in counting; 2.   explain why the ability to recite number names is no in

Which of the subsequent numbers will yield a number larger, Which of the su...

Which of the subsequent numbers will yield a number larger than 23.4 while it is multiplied by 23.4? When multiplying through a number less than 1, you get a product in which i

Area of polygons, ho we can find the area of diffrent types of polygon

ho we can find the area of diffrent types of polygon

Core concepts, what are the core concept of marketing

what are the core concept of marketing

Polynomials in two variables, Polynomials in two variables Let's take a...

Polynomials in two variables Let's take a look at polynomials in two variables.  Polynomials in two variables are algebraic expressions containing terms in the form ax n y m

Rational expressions, Now we have to look at rational expressions. A ration...

Now we have to look at rational expressions. A rational expression is a fraction wherein the numerator and/or the denominator are polynomials.  Here are some examples of rational e

Calculate the area of the ade and compare it with abc, The vertices ...

The vertices of a ? ABC are A(4, 6), B(1. 5) and C(7, 2). A line is drawn to intersect sides AB and AC at D and E respectively, such that AD/AB = AE/AC = 1/4 .Calculate the  ar

What is the sale price of the printer, A printer which sells for $190 is on...

A printer which sells for $190 is on sale for 20% off. What is the sale price of the printer? The printer is 20% off. That means that it is 80% of its original price (100% - 2

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