How to use the NORM.INV function
What is the NORM.INV function?
The NORM.INV function calculates the inverse of the normal cumulative distribution for a given mean and standard deviation.
What is the NORM.DIST function?
The NORM.DIST function calculates the normal distribution for a given mean and standard deviation.
What is a normal distribution?
The normal distribution is a symmetric bell-shaped probability distribution described by its mean and standard deviation. Used by many to model a plethora of natural phenomena and represent unknown processes.
What is the mean?
It is also known as the average. It is calculated by adding up all the values in the data set and dividing by the number of values.
For example, if you have a data set of 5, 7, 9, 11, and 13, the mean is (5 + 7 + 9 + 11 + 13) / 5 = 9.
What is deviation?
In statistics, deviation is a measure of how far each value in a data set lies from the mean (the average of all values). A high deviation means that the values are spread out widely, while a low deviation means that they are clustered closely around the mean.
What is standard deviation?
Standard deviation measures dispersion from the mean by taking the square root of the average of squared deviations, useful for assessing variability and spread in data.
What is the difference between deviation and standard deviation?
- Deviation is the difference between an individual data point and the mean.
- Standard deviation measures the variation across all deviations by using the square root of the average squared deviation.
What is the difference between the NORM.DIST function vs NORM.INV function?
NORM.INV function returns the inverse of the normal cumulative distribution for a given mean and standard deviation.
NORM.INV(probability, mean, standard_dev)
The NORM.DIST function calculates the normal distribution for a given mean and standard deviation.
NORM.DIST(x, mean, standard_dev, cumulative)
For example, the chart above demonstrates a standard normal distribution with a mean of 0 (zero) and standard deviation of 1.
The NORM.DIST(-1,0,1,TRUE) returns 0.158655253931457 which is the orange area below the curve up to x = -1 that represents the cumulative probability.
The NORM.INV(0.158655253931457,0,1) returns -1 which is the x value given the cumulative probability of 0.158655253931457
What is a standard normal distribution?
A standard normal distribution is a normal distribution with the mean of 0 (zero) and the standard deviation is 1. You can standardize any normal distribution using the STANDARDIZE function in Excel, it works like this:
z = (x - µ)/σ
z = z-score
µ is the mean.
σ is the standard deviation.
NORM.INV function Syntax
NORM.INV(probability, mean, standard_dev)
NORM.INV function Arguments
probability | Required. A probability corresponding to the normal distribution. |
mean | Required. The average of the distribution. |
standard_dev | Required. The standard deviation of the distribution. |
NORM.INV function example
Formula in cell C7:
NORM.INV function not working
NORM.INV returns
- #VALUE! if argument is non-numeric.
- #NUM! if standard_dev ≤ 0
- #NUM! if probability <= 0 or if probability >= 1
- the standard normal distribution if mean = 0 and standard_dev = 1
Functions in 'Statistical' category
The NORM.INV function function is one of many functions in the 'Statistical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form