Difference between revisions of "Manuals/calci/LOGINV"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
*<math>sd</math> is the standard deviation of ln(x) | *<math>sd</math> is the standard deviation of ln(x) | ||
==Description== | ==Description== | ||
| − | *This function gives the inverse value of | + | *This function gives the inverse value of Log-normal Cumulative Distribution. |
| − | *This distribution is the | + | *This distribution is the Continuous Probability Distribution. |
| − | * | + | *Log-normal Distribution is also called Galton's distribution. |
*A random variable which is log-normally distributed takes only positive real values. | *A random variable which is log-normally distributed takes only positive real values. | ||
| − | *If LOGNORMDIST(x,m,sd)=prob, then LOGINV(prob,m,d)=x. | + | *If <math>LOGNORMDIST(x,m,sd)=prob</math>, then <math>LOGINV(prob,m,d)=x</math>. |
*This function will give the result as error when | *This function will give the result as error when | ||
| − | + | Any one of the argument is non-numeric. | |
| − | + | <math>prob<0</math> or <math>prob>1</math> or <math>sd \le 0</math> | |
==Examples== | ==Examples== | ||
| − | #LOGINV(0.039084,3.5,1.2 | + | #LOGINV(0.039084,3.5,1.2) = 3.9957031 |
| − | #LOGINV(0.24786,6.25,3.12 | + | #LOGINV(0.24786,6.25,3.12) = NULL |
| − | #LOGINV(0.007543,5.82,2.9 | + | #LOGINV(0.007543,5.82,2.9) = NULL |
==See Also== | ==See Also== | ||
| + | *[[Manuals/calci/LOG | LOG]] | ||
| + | *[[Manuals/calci/EXP | EXP]] | ||
| + | *[[Manuals/calci/LN | LN]] | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Bessel_function Bessel Function] | [http://en.wikipedia.org/wiki/Bessel_function Bessel Function] | ||
Revision as of 00:56, 16 December 2013
LOGINV(prob,m,sd)
- is the probability associated with lognormal distribution
- is the mean value of ln(x)
- is the standard deviation of ln(x)
is the probability associated with lognormal distribution
is the mean value of ln(x)
is the standard deviation of ln(x)Description
- This function gives the inverse value of Log-normal Cumulative Distribution.
- This distribution is the Continuous Probability Distribution.
- Log-normal Distribution is also called Galton's distribution.
- A random variable which is log-normally distributed takes only positive real values.
- If , then .
- This function will give the result as error when
, then 
.Any one of the argument is non-numeric. or or
or 
or 
Examples
- LOGINV(0.039084,3.5,1.2) = 3.9957031
- LOGINV(0.24786,6.25,3.12) = NULL
- LOGINV(0.007543,5.82,2.9) = NULL