Navigation:  Formula Reference > Spreadsheet Formula Functions >

NORM.INV

Previous pageReturn to chapter overviewNext page

 

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

Syntax

NORM.INV(prob,mean,stdev)

Arguments

This function has these arguments:

Argument

Description

prob

Probability of the normal distribution

mean

Arithmetic mean of the distribution

stdestdev

Standard deviation of the distribution; must be greater than zero

Remarks

The #VALUE! error value is returned if any argument is nonnumeric.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

NORM.INV(B3,C12,D14)

NORM.INV(R3C2,R12C3,R14C4)

NORM.INV(0.978,32,0.252) gives the result 32.50755088397007