2 Replies Latest reply: Dec 13, 2015 3:53 AM by Massimo Grossi RSS

    performing statistical analysis on data

      I have a requirement to create dashboard for performing statistical analysis on data fields.

      It should be generic dashboard where we can plug in any data and should be able to perform following operations

      without much manual effort.


      for ex. for numeric variable

      1. Min

      2. Max

      3. Median

      4. Std Dev

      5. Mode

      6. Coefficient of variance

      7. 25th percentile and 75th percentile

      8. missing data %



      for character variable

      1. mode

      2. unique string

      3. missing data %

      4. second highest value (in terms of frequency)

      How to identify numeric and character variable in data set?

      Mode of variable returns Null in case of two values having same number of occurrence, how to deal with it.

      Thanks in advance