Table of Contents
This guide provides a practical overview of LOGNORM. INV Function, including its main features, benefits, limitations, and important considerations.
Description: The function returns the inverse of the logarithmic distribution of x. Where LN (x) is usually distributed with parameter mean and standard deviation. Use functions to analyze logarithmic change data. Support function from Excel 2010 version.
Syntax: LOGNORM. INV (probability, mean, standard_dev)
Inside:
- probability : Probability associated with a standard logarithmic distribution, which is a required parameter.
- mean: The average value of LN (x) , is a required parameter.
- standard_dev: Standard deviation of LN (x), is a required parameter.
Attention:
- Any argument except ( cumulative) is not a number -> function returns the #VALUE! Error value
- If probability ? 0 or probability ? 1 -> the function returns the #NUM! Error value
- If standard_dev ? 0 -> the function returns the #NUM! Error value
For example:
Find the inverse value of the cumulative standard logarithmic distribution function as described in the following data table:
- In the cell to calculate, enter the formula : = LOGNORM. INV (D6, D7, D8)
- Press Enter -> the inverse value of the cumulative standard logarithmic distribution function is:
- Where the probability associated with a standard cumulative distribution is less than 0 or greater than 1-> the function returns the #NUM! Error value
- Where the standard deviation is less than 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the LOGNORM. INV function in Excel.
Good luck!
FAQ
What does the LOGNORM. INV Function function do in Excel?
The LOGNORM. INV Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the LOGNORM. INV Function function correctly?
Start with an equals sign, enter LOGNORM. INV Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the LOGNORM. INV Function function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.