3 Replies Latest reply on Feb 28, 2013 10:12 AM by Pulkit Saxena

    How to calculate relative percentage from max - market share indexing

    Pulkit Saxena

      Hi, I was trying to create an index of market share for certain values but cant figure out how.

      Essentially i have a data set (just an example) with 3 different product - X,Y,Z which are in 3 different cities.

       

      Say for city - NYC X has market share 10%, Y - 20% and Z 18%.

       

      Now an index would be -

       

      for X - 10% / max (X,Y,Z) = 10%/20% = 0.5

      for Y - 20% / max( X,Y,Z) = 20%/20% = 1

      and so on..

       

      So if i have 3 different cities it should take the market share of a product and divide by max market share of that city.

       

      Any ideas would be of great help!

       

      Pulkit