LOGINV

The LOGINV function in Google Sheets returns the value of the inverse log-normal cumulative distribution with a given mean and standard deviation at a specified value.

Function Syntax and Parameters

Syntax: LOGINV(x, mean, standard_deviation)

Parameters:

• x: The value at which to evaluate the inverse log-normal cumulative distribution.
• mean: The mean of the log-normal distribution.
• standard_deviation: The standard deviation of the log-normal distribution.

Step-by-Step Tutorial

1. Using LOGINV with specific values:
   • Example: =LOGINV(0.5, 2, 3)
   • Result: <result>

Use Cases and Scenarios

1. Financial Analysis: Calculate the inverse log-normal cumulative distribution for investment returns.
2. Risk Assessment: Evaluate the inverse log-normal distribution for estimating the probability of extreme events.
3. Health Research: Determine the inverse log-normal cumulative distribution for analyzing medical data.

Related Functions

N/A

Related Articles

N/A