4

Suppose products A, B and C are sold on markets 1, 2 and 3. I have access to three years worth of monthly historical data. I'd like to detect/foresee possible shifts in sales mix for the three products over the three markets (e.g. I'd like to know if market 1 is buying more of product A than it used to, or if product B is cannibalizing the others on market 3).

Does a 5/10/15% increase mean that I'm facing a shift in consumer behaviour? Does it depend on the intrinsic variability of the behavioural pattern? Also how do I choose the optimal time-frame on which to perform such analysis (i.e. how do I know if comparing semester over semester increase makes more sense than comparing quarter over quarter increase)?

Would t-test/ANOVA work here? Or maybe a control chart? Or maybe some intervention detection method to check if there was a level shift in my time series? If so, how do I go about it?

Any input is greatly appreciated!

Peter Ellis
  • 16,522
  • 1
  • 44
  • 82
Bruder
  • 699
  • 1
  • 6
  • 17
  • 1
    The answers to the following question seem relevant: http://stats.stackexchange.com/questions/17623/how-to-detect-a-significant-change-in-time-series-data-due-to-a-policy-change – Gala Mar 07 '12 at 13:02
  • Yeah, I thought intervention detection "a la Tsay" would be an option (which reminds me I need to have a chat with IrishStat =D) so +1 for that. Does anyone else have any other suggestion? – Bruder Mar 07 '12 at 13:48
  • 1
    @Bruder I await your contact . You might check out my contact info. I don't necessarily see a role for intervention detection but rather incorporating possible canibilizers as predictor series in a Transfer Function. Annheuser-Busch used our software to relate sales of a product in a particular size as it was impacted by sales of the same product but in different sizes . They also included the price of the possible canibalizers in order to assess the effect. – IrishStat Mar 07 '12 at 21:45

2 Answers2

1

I'd go with control charts. They're not sexy because they're kind of low tech -- but they work. They're also visual, that is, you can spot trends before any numeric flags go up.

I keep recommending this book because of its almost universal applicability.

Carlos Accioly
  • 4,715
  • 4
  • 25
  • 28
  • thank you for your link. I actually own that book, and that's exactly where I got the idea of control charts from. It's good to see we're on the same page. Litteraly :) – Bruder Mar 07 '12 at 19:33
  • perhaps the numeric flags you are considering are not "good enough" – IrishStat Mar 08 '12 at 11:30
  • @Bruder I actually went out and bought the book but found it lame in many regards. – IrishStat Apr 06 '12 at 21:34
1

I think because this is a time series intervention analysis as mentioned earlier may be the best approach. Tom and Dave Reilly who have the software product called Autobox calim that they can do this automatically with their software.

Michael R. Chernick
  • 39,640
  • 28
  • 74
  • 143