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

Probability, Mike sells on the average 15 newspapers per week (Monday – Fri...

Mike sells on the average 15 newspapers per week (Monday – Friday). Find the probability that 2.1 In a given week he will sell all the newspapers

Advanced functions, writ the equation that describes the motion of a point ...

writ the equation that describes the motion of a point on the wheel that has a center of 4m off the ground, has radius of 15 cm, makes a full rotation every 10 seconds and starts a

Core concepts, Discuss mareketing core concepts analysing how they are used...

Discuss mareketing core concepts analysing how they are used in marketing hospitality product

Algebria, solve and graph the solution set 7x-4 > 5x + 0

solve and graph the solution set 7x-4 > 5x + 0

Area and perimeter, if perimeter is 300m length is 100m.find the breadth

if perimeter is 300m length is 100m.find the breadth

Illustrate median with example, Q. Illustrate Median with example? Ans...

Q. Illustrate Median with example? Ans. The median of a data set is the middle value (or the average of the two middle terms if there are an even number of data values) wh

Ronding off numbers, how to round off numbers to the nearest tens and to th...

how to round off numbers to the nearest tens and to the nearest hundred

Rewriting percent expressions, i have trouble going through problem in this...

i have trouble going through problem in this lesson. Markdown and Markups are theh ones im stuck in

Permutations and combinations, number of ways that a mixed doubles tennis g...

number of ways that a mixed doubles tennis game can be arranged from 7 couples if no husband and wife play in the same game is??

Definition of a function, A function is a relation for which each of the va...

A function is a relation for which each of the value from the set the first components of the ordered pairs is related with exactly one value from the set of second components of t

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