SheetFX
≡
<< Go back to all functions

NORM.INV

The NORM.INV function in Google Sheets is used to calculate the inverse of the normal cumulative distribution for a specified value. It is commonly used in statistical analysis and can help in determining the probability of a certain value occurring. Explore our comprehensive guide to understand its syntax and usage.

Function Syntax and Parameters

Syntax: NORM.INV(x, mean, standard_deviation)

Parameters:

  • x: The value at which you want to calculate the inverse of the cumulative distribution.
  • mean: The mean of the distribution.
  • standard_deviation: The standard deviation of the distribution.

Step-by-Step Tutorial

  1. Using NORM.INV with a specific value:
    • Example: =NORM.INV(0.2, 10, 5)
    • Result: Returns the z-score value corresponding to a cumulative distribution of 0.2 with a mean of 10 and a standard deviation of 5.

Use Cases and Scenarios

  1. Probability Evaluation: Calculate the z-score for a given cumulative distribution.
  2. Quality Control: Determine the acceptable limits for a manufacturing process.
  3. Financial Analysis: Evaluate the risk associated with an investment.

Related Functions

  • NORM.DIST: Calculates the cumulative standard normal distribution.

Related Articles