Excel Function : LOGINV

Download now!

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.