LOGINV Function

Basic Description

The Excel LOGINV function calculates the inverse of the Cumulative Log-Normal Distribution Function of x, for a supplied probability.

Syntax: LOGINV( probability, mean, standard_dev )

Where the function arguments are:

probability The value at which you want to evaluate the inverse function
mean The arithmetic mean of ln(x)
standard_dev The standard deviation of ln(x)

 

Loginv Function Example

Plot of Inverse Log-Normal Cumulative Distribution Function with Mean=2 and Standard Deviation=0.2

Inverse of Log-Normal Cumulative Distribution of x with
mean ln(x) = 2 & standard deviation ln(x) = 0.2

The chart on the right shows the the Inverse Log-Normal Cumulative Distribution Function of x. The mean of ln(x) = 2 and the standard deviation of ln(x) = 0.2.

If you want to calculate the value of x, for a probability of 0.3, this can be done using the Excel Loginv function, as follows:

=LOGINV( 0.3, 2, 0.2 )

This gives the result 6.653346076.

 

Loginv Function Errors

If you get an error from your Excel Loginv function this is likely to be one of the following:

#NUM! Occurs if either the supplied probability argument is ≤ 0 or ≥ 1 or the supplied standard_dev argument is ≤ 0
#VALUE! Occurs if any of the the supplied arguments are non-numeric.

One thought on “LOGINV Function

  1. I just wanted to thank you yet again for this amazing web-site you have developed here. It can be full of useful tips for those who are seriously interested in this specific subject, specifically this very post. You really are all really sweet and also thoughtful of others as well as reading your blog posts is a fantastic delight to me. And such a generous reward! Tom and I will have fun making use of your points in what we should instead do in a few weeks. Our checklist is a kilometer long which means your tips might be put to beneficial use.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment