Skip to main content Skip to complementary content

NORMINV - script and chart function

NORMINV() returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Syntax:  

NORMINV(prob, mean, standard_dev)

Return data type: number

Arguments:  

NORMINV arguments
Argument Description
prob A probability associated with the normal distribution. It must be a number between 0 and 1.
mean A value stating the arithmetic mean for the distribution.
standard_dev A positive value stating the standard deviation of the distribution.

This function is related to the NORMDIST function in the following way:
If prob = NORMDIST(value, m, sd), then NORMINV(prob, m, sd) = value

Limitations:  

All arguments must be numeric, else NULL will be returned.

Examples and results:  

Examples and results
Example Result
NORMINV( 0.6914625, 0, 1 ) Returns 0.5000  

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com