LOGINV(probability, mean, standard_dev)
=LOGINV(0.7, 2, 0.75)
The LOGINV function can be used to compute the inverse of the lognormal cumulative distribution function. This is useful if you need to calculate the value of x associated with a given cumulative probability. For example, this function returns the x value that has a cumulative probability of 0.7 when the lognormal distribution has a mean of 2 and a standard deviation of 0.75.
=LOGINV(A2, 2, 0.75)
The LOGINV function can also be used to calculate the value of a probability associated with a given x value. This function returns the x value that has a cumulative probability equal to the probability in A2 when the lognormal distribution has a mean of 2 and a standard deviation of 0.75.
=LOGINV(A2, A3, A4)
You can also use the LOGINV function to calculate the probability associated with a given x value. For example: , where A2 is a cell containing an x value, A3 is a cell containing the mean of the lognormal distribution, and A4 is a cell containing the standard deviation of the lognormal distribution. This function returns the cumulative probability associated with the x value in A2 when the lognormal distribution has a mean and standard deviation equal to the values in A3 and A4.
The LOGINV function calculates the inverse of the lognormal cumulative distribution function, used to analyze logarithmically transformed data. It offers improved accuracy compared to other functions.