Excel Function : LOGINV
Category
Compatibility
Description
Returns the inverse of the lognormal cumulative distribution
Microsoft Excel Reference Page
https://support.office.com/en-us/article/LOGINV-function-0bd7631a-2725-482b-afb4-de23df77acfe
Syntax and Description of the LOGINV Excel Function
. To use the LOGINV() function, =LOGINV(probability,mean,standard_deviation) Here, probability – This is the probability that is used to find the percentile. mean – This is the average of the probability distribution. standard_deviation – This is the standard deviation of the probability distribution. For example, =LOGINV(0.1,1,2) This means that the probability is 10%. The mean is 1 and the standard deviation is 2.
About LOGINV Excel Function
The LOGINV function returns the inverse of the lognormal cumulative distribution.