1 Reply Latest reply on Mar 5, 2012 11:12 AM by Tracy Rodgers

    How do I compare contrasting data sets

    Christopher Henderson

      Hi

       

      Here is the situation:

       

      I have a database of sales data which contains a list of accounts and products with product codes and their respective history. What I need to do is to look at certain products and see whether its contrasting product is influenced by increases or decreases in their respective sales.

       

      So for example - we sell two products - Product A and Product B - The natural assumption is that if I sell less of Product A I would sell more of Product B and visa versa.

       

      What I have is the sales database with all of the product codes, accounts, sales history etc, and an excel list of product codes and their contrasting or competitor product code. (Note - Not all products in the database will have a contrasting product). All these codes are contained within the database.

       

      Would anyone be able to provide some advice on how to do this?

       

      Many thanks

       

      Chris