NORM.INV(probability, mean, standard_dev)

Returns the x variable corresponding to less than a particular probability.

probabilityThe probability associated with the distribution.
meanThe arithmetic mean of the distribution.
standard_devThe standard deviation of the distribution.

Remarks

* Added in Excel 2010.
* This function replaces the NORMINV function.
* This function is the inverse of the NORM.DIST function.
* The normal distribution is a continuous distribution.
* For the Microsoft documentation refer to support.office.com

 A
1=NORM.INV(0.908789,40,1.5) = 42
2=NORM.INV(0.87,0,1) = 1.126
3=NORM.INV(NORM.DIST(0.87,0,1,TRUE),0,1) = 0.87
4=NORM.INV(1,0,1) = #NUM!
5=NORM.INV(-1,40,1.5) = #NUM!
6=NORM.INV(2,40,1.5) = #NUM!
7=NORM.INV(0.908789,"some text",1.5) = #VALUE!

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top