Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm currently having difficulty calculating values for the deseasonalised sales column. How do you go about doing it for 2004Q1-2004Q2?

enter image description here

Btw in case you are wondering:


$$First MA = {\frac{20+12+9+7}{4}} = 12$$ $$Centered MA = {\frac{11.5+12}{2}} = 11.750$$ $${\frac{Sales}{CMA}} = {\frac{12}{11.750}} = 1.02$$


$$First MA = {\frac{12+9+7+25}{4}} = 13.75$$ $$Centered MA = {\frac{12+13.25}{2}} = 12.625$$ $${\frac{Sales}{CMA}} = {\frac{9}{12.625}} = 0.71$$

This is the pattern being followed throughout.

share|cite|improve this question
up vote 1 down vote accepted

Deseasonalizing the data means dividing the sales by a constant, where that constant is defined for a particular time of year. In the context of time series, this can be based on previous performance and some sort of percentage of total sales in a previous year. Here it seems that each quarter has its own constant that persists over the years: divide observed sales 2001q1 by its related deseasonalized sales to get ~1.14. You get about the same value for 2002q1 and 2003q1. So it stands that you would get the same with a hypothetical value for deseasonalized sales of 2004q1, for a value of $12/x=1.14\to x=12/1.14$. The solution is analogous for 2004q2.

share|cite|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.