NORM.S.INV

NORM.S.INV(probability)

Returns the inverse of the probability distribution function for a standard normal distribution.

probabilityThe probability associated with the distribution.

REMARKS
* The standard normal distribution is a continuous distribution
* mean 0, standard deviation 1
* You can use the NORM.S.DIST function to return the probability distribution function for a standard normal distribution.
* You can use the NORM.DIST function to return the probability distribution function OR the cumulative probability function for a standard normal distribution.
* You can use the NORM.INV function to return the inverse of the probability distribution function for normal distribution.
* This function was added in Excel 2010 to replace the NORMSINV function.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=NORM.S.INV(0.908789) = $1.33


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