0 Replies Latest reply: Dec 1, 2014 7:39 AM by Amit Gupta RSS

    How to use expressions in TTEST_SIG function?

      Hi Everyone,

       

      I want to calculate p-value of the % of customers using each product in each of the two countries to understand if the % difference in usage of a product in each country is really significant i.e people of one country prefer a product more as compared to other country. How can I write a TTEST_SIG formula to find the % of users of each product in each country and then compare the percentages of one country with other for each product? Below is the sample data:

       

      COUNTRYCUSTOMERPRODUCT
      AC1P1
      AC2P1
      AC3P1
      AC4P2
      AC5P2
      BC6P1
      BC7P2
      BC8P2
      BC9P2
      BC10P2

       

      Thanks,

      Amit