Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

NORM.INV

Returns the standard normal cumulative distribution for the given number.

Sample Usage

NORM.INV(0.75,1,4)
NORM.INV(A2,A3,A4)


Syntax

NORM.INV(x, mean, standard_deviation)

  • x - The input to the inverse normal distribution function.
  • mean - The arithmetic mean of the distribution.
  • standard_deviation - The standard deviation of the distribution.

Examples

NORM.INV(0.75,1,4) returns a value of 3.6979
NORM.INV(A2,A3,A4) returns the inverse of the normal cumulative distribution for the arguments defined.