Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data.
Syntax
LOGINV(probability,mean,standard_dev)
Probability is a probability associated with the lognormal distribution.
Mean is the mean of ln(x).
Standard_dev is the standard deviation of ln(x).
Remarks
-
If any argument is nonnumeric, LOGINV returns the #VALUE! error value.
-
If probability < 0 or probability > 1, LOGINV returns the #NUM! error value.
-
If standard_dev <= 0, LOGINV returns the #NUM! error value.
-
The inverse of the lognormal distribution function is:
Example
| Probability | Mean | StdDev | Formula | Description (Result) |
| 0.039084 | 3.5 | 1.2 | =LOGINV([Probability], [Mean], [StdDev]) | Inverse of the lognormal cumulative distribution function for the specified arguments (4.000028) |
Hello guys, I just want to share my joyful experience about HACK VANISH CREDIT SPECIALIST. Before the coronavirus pandemic, I had criminal Judgments, few evictions, and late payment which negatively impacted my credit score down to 487 and left me in difficult financial situation, as a single mum of 3, I needed a loan to keep the family running after I lost my husband as a result of COVID-19, all hope were lost, until Mrs. Olivia referred me to HACK VANISH, a credit genius who was very helpful in fixing my credit 6 days after I reached out to him via Email: hackvanish (At) gmail (Dot) com and Phone: +1(747) 293-8514, throughout the process, I felt so involved because an open line of communication was maintained till I got my FICO score restored to 796, currently my loan application has been approved. If you need to hire a credible hacker, HACK VANISH is highly recommended.
ReplyDelete