Advanced statistics

They determine the most probable and the most frequent values and builds frequency tables. The main advanced statistics include the following values:

Mode: computes the most probable value. For numerical data or continuous data, you can set bins in the parameters of this indicator. It is different from the "average" and the "median". It is good for addressing categorical attributes.
Value Frequency: computes the number of most frequent values for each distinct record.
All other Value Frequency indicators are available to aggregate date and numerical data (with respect to "date", "week", "month", "quarter", "year" and "bin").
Value Low Frequency: computes the number of less frequent records for each distinct record.
All other Value Low Frequency indicators are available to aggregate date and numerical data (with respect to "date", "week", "month", "quarter", "year" and "bin"), where "bin" is the aggregation of numerical data by intervals.

The following table shows the indicators that you can select in any database:

Indicator	Supported data types with the Java analysis engine	Supported data types with the SQL analysis engine
Mode	Number Text Date	Number Text Date
Value (Low) Frequency	Number Text Date	Number Text Date
Date (Low) Frequency	Date, with the exception of time	Date, with the exception of time
Week (Low) Frequency	Date, with the exception of time	Date, with the exception of time
Month (Low) Frequency	Date, with the exception of time	Date, with the exception of time
Quarter (Low) Frequency	Date, with the exception of time	Date, with the exception of time
Year (Low) Frequency	Date, with the exception of time	Date, with the exception of time
Bin (Low) Frequency	Number	Number

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!