4 Replies Latest reply on Jan 7, 2019 4:58 AM by Mahesh Gujar

    How to Calculate Confidence Level, Standard Deviation, Weighted Response, P-value Dynamically in Tableau

    Mahesh Gujar

      Hi Team,

       

       

      I'm trying to calculate Confidence Level, Standard Deviation, Weighted Response, P-value which we can do with ease in excel as we can pick cell to cell value. But, I'm running short of ideas to get these calculations in my work book dynamically.

       

       

       

      I would really appreciate your help if you can help me to get these calculations in tableau.

       

       

       

       

      Attached is the sample data source. Please let me know if you need any additional information.

       

       

      End Goal is to Calculate Confidence Level and to get it we need to calculate:

      • Conversion Lift
      • Weighted Response
      • Standard Deviation
      • P-value
      • Confidence Level - Final Output

       

      Thank you!!