SheetFX
≡
<< Go back to all functions

LOGNORM.INV

The LOGNORM.INV function in Google Sheets is a statistical function that calculates the inverse of the log-normal cumulative distribution. It is often used in finance, economics, and other fields to model data that follows a log-normal distribution. Discover how to use this function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: LOGNORM.INV(x, mean, standard_deviation)

Parameters:

  • x: The probability of the event happening (between 0 and 1).
  • mean: The mean of the logarithm of the data.
  • standard_deviation: The standard deviation of the logarithm of the data.

Step-by-Step Tutorial

  1. Using LOGNORM.INV with example values:
    • Example: =LOGNORM.INV(0.5, 0, 1)
    • Result: Returns the value from the log-normal distribution with a probability of 0.5, mean of 0, and standard deviation of 1.

Use Cases and Scenarios

  1. Financial Analysis: Determine the value of an investment with a given probability.
  2. Risk Management: Calculate the risk associated with certain events.
  3. Insurance Modeling: Assess the likelihood of insurance claims based on historical data.

Related Functions

  • LOGINV: Calculate the inverse of the standard normal cumulative distribution.

Related Article