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

The low temperature in Achorage, The low temperature in Anchorage, Alaska t...

The low temperature in Anchorage, Alaska today was negative four degrees. The low temperature in Los Angeles, California was sixty-three degreees. What is the difference in the two

High dimensions, List the five most important things you learned about high...

List the five most important things you learned about high dimensions.

Find the quotient and remainder, Question: Find the quotient and remain...

Question: Find the quotient and remainder when f(x) = x 5 - x 4 - 4x 3 + 2x + 3 is divided by g(x) = x-2. Make sure the quotient and remainder are clearly identified.

Melisa and jennifer threw a fiftieth how much is a 20% tip, Melisa and Jenn...

Melisa and Jennifer threw a fiftieth birthday party for their father at a local restaurant. While the bill came, Melisa added a 15% tip of $42. Jennifer said in which the service w

What is a negative number, Q. What is a Negative Number? Ans. Neg...

Q. What is a Negative Number? Ans. Negative numbers  are very important in mathematics. We say that positive and negative numbers are  opposites  of one another. Here

Show basic trigonometric functions, Q. Show basic Trigonometric Functions? ...

Q. Show basic Trigonometric Functions? Ans. There are six trigonometric functions and they can be defined using a right angle triangle. We first label each side according

What percent the girls surveyed said that area hockey sport, 450 girls were...

450 girls were surveyed about their favorite sport, 24% said in which basketball is their favorite sport, 13% said in which ice hockey is their favorite sport, and 41% said which s

Four-step plan, Adison earned $25 mowing her neighbor''s lawn. Then she loa...

Adison earned $25 mowing her neighbor''s lawn. Then she loaned her friend $18, and got $50 from her grandmother for her birthday. She now has $86. How much money did Adison have to

Evaluate numerator and denominator limit, Evaluate following limits. ...

Evaluate following limits. Solution : Let's do the first limit & in this case it sees like we will factor a z 3 out of the numerator and denominator both. Remember that

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