The statistical distribution DIST functions measure the probability of the distribution function at the point in the distribution given by the supplied value. The INV functions calculate the value, given the probability of the distribution. In contrast, the groups of statistical aggregation functions calculate the aggregated values of series of statistical test values for various statistical hypothesis tests.
The statistical distribution
functions described below are all implemented in Qlik Sense using the Cephes function
library. For references and details on algorithms used, accuracy, and so on,
see: Cephes library.
The Cephes function library is used by permission.
All functions can be used in both the data load script and in chart expressions.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
CHIDIST() returns the one-tailed probability
of the chi2 distribution. The chi2 distribution is associated with a chi2 test.
NORMDIST() returns the cumulative normal
distribution for the specified mean and standard deviation. If mean = 0
and standard_dev = 1, the function returns the standard normal distribution.
TDIST() returns the probability for the
Student's t-distribution where a numeric value is a calculated value of
t for which the probability is to be computed.