I have a dataset with month sales for 6 months per customer. I want to compare the sales average of the first 3 months versus the last 3, but I know this averages may be influenced by seasonality of the sales.

I have the "historical" sales for these months for previous years (like 5 years). Is there a way I can use this previous data for detrending the sales of my dataset (present year)?

Right now, I'm approaching it this way:

For example, I can know that, historically, Jan-March sales are 5% higher than Apr-June. So when I calculate the variation for these periods of months, I substract 5% from my calculation. However, this doesnt detrend month by month... only the comparison between groups of months.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.