Statistical distribution functions

The statistical distribution functions described below are all implemented in Qlik Sense using the Cephes library. For references and details on algorithms used, accuracy etc, see http://www.netlib.org/cephes/. 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.

This function returns the one-tailed probability of the chi2 distribution. The chi2distribution is associated with a chi2 test.

CHIDIST(value, degrees_freedom)

This function returns the inverse of the one-tailed probability of the chi2 distribution.

CHIINV(prob, degrees_freedom)

This function 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)

This function returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

NORMINV(prob, mean, standard_dev)

This function returns the probability for the student 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)

This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom.

TINV(prob, degrees_freedom)

This function returns the F-distribution.

FDIST(value, degrees_freedom1, degrees_freedom2)

This function returns the inverse of the F-distribution.

FINV(prob, degrees_freedom1, degrees_freedom2)

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 – please let us know!

Leave your feedback here