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

Hello, I am here to tell you, Alex has a cold.

I am here to tell you, Alex has a cold.

Solution to a differential equation, A solution to a differential equation ...

A solution to a differential equation at an interval α Illustration 1:   Show that y(x) = x -3/2 is a solution to 4x 2 y′′ + 12xy′ + 3 y = 0 for x > 0. Solution : We'll

Design an automaton that accepts only even numbers, Design an automaton tha...

Design an automaton that accepts just only even numbers of 0s and even number of 1's. Ans: The needed automata that accepts even number of 0's and even number of 1's is specifi

Explain how we converting fractions to percents, Explain how we Converting ...

Explain how we Converting Fractions to Percents ? To convert a fraction to a percent: 1. Convert the fraction to a decimal using long division. 2. Move the decimal point two p

Give the introduction about graphing, Give the  introduction about Graphin...

Give the  introduction about Graphing? Somebody tells you that x = 5 and y = 3. "What does it all mean?!" you shout. Well here's a picture: This picture is what's call

Derivatives, Derivatives The rate of change in the value of a...

Derivatives The rate of change in the value of a function is useful to study the behavior of a function. This change in y for a unit change in x is

Probability distribution for continuous random variables, Probability Distr...

Probability Distribution for Continuous Random Variables In a continuous distribution, the variable can take any value within a specified range, e.g. 2.21 or 1.64 compared to

How far up the building will the ladder reach?, A rescue and ?re squad plac...

A rescue and ?re squad places a 15 ft ladder against a burning building. If the ladder is 9 ft from the base of the building, how far up the building will the ladder reach? a. 8

Product, a product can be anything including physical good,services,places,...

a product can be anything including physical good,services,places,experience,nations,organizations,properties,information.discuss the statement?

Proportions, bananas are on sale for 3 pounds for $2. At that price how man...

bananas are on sale for 3 pounds for $2. At that price how many pounds can you buy for $22

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