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.
CHIINV() returns the inverse of the one-tailed probability of the chi2 distribution.
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.
NORMDIST(value, mean, standard_dev)
NORMINV() returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMINV(prob, mean, standard_dev)
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.
TDIST(value, degrees_freedom, tails)
TINV() returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
FDIST() returns the F-probability distribution.
FDIST(value, degrees_freedom1, degrees_freedom2)
FINV() returns the inverse of the F-probability distribution.
FINV(prob, degrees_freedom1, degrees_freedom2)