Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Sintaxis
NORM.INV(probability, mean, standard_dev)Argumentos
probabilityobligatorio
A probability corresponding to the normal distribution, between 0 and 1 inclusive.
meanobligatorio
The arithmetic mean of the distribution.
standard_devobligatorio
The standard deviation of the distribution, which must be greater than 0.
The NORM.INV function calculates the value of a variable for which the probability of a normal distribution is equal to the given probability. It is commonly used to determine critical values or thresholds in statistical analysis based on a normal distribution model.
=NORM.INV(0.95, 50, 10)→66.44853627Calculates the value below which 95% of the data falls in a normal distribution with a mean of 50 and standard deviation of 10.
Identify parameters
Determine the probability, the distribution mean, and the standard deviation for your dataset.
Enter the function
Type =NORM.INV(probability, mean, standard_dev) into a cell, replacing the arguments with your specific values.
The function will return the #NUM! error value.