Difference between revisions of "Manuals/calci/LOGINV"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''LOGINV '''('''p''',''' m, sd''') '''Where p''' is a lognormal distribution and m is the mean of ln(x), ...") |
|||
Line 1: | Line 1: | ||
− | <div | + | <div style="font-size:30px">'''LOGINV(prob,m,sd)'''</div><br/> |
+ | *<math>prob</math>is the probability associated with lognormal distribution | ||
+ | *<math>m</math>is the mean value of ln(x) | ||
+ | *<math>sd</math>is the standard deviation of ln(x) | ||
+ | ==Description== | ||
+ | *This function gives the inverse value of lognormal cumulative distribution. | ||
+ | *This distribution is the continuous probability distribution. | ||
+ | *Lognomal distribution is also called Galton's distribution. | ||
+ | *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. | ||
+ | *This function will give the result as error when | ||
+ | #Any one of the argument is nonnumeric. | ||
+ | #prob<0 or prob>1 or sd<=0 | ||
− | + | ==Examples== | |
− | + | #LOGINV(0.039084,3.5,1.2)=4.000025219 (EXCEL)=3.9957031(CALCI) | |
+ | #LOGINV(0.24786,6.25,3.12)=61.83892171 (EXCEL)=NULL(CALCI) | ||
+ | #LOGINV(0.007543,5.82,2.9) =0.292909096(EXCEL)=NULL(CALCI) | ||
− | + | ==See Also== | |
− | |||
− | |||
− | + | ==References== | |
− | + | [http://en.wikipedia.org/wiki/Bessel_function Bessel Function] | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Revision as of 00:04, 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)
Description
- This function gives the inverse value of lognormal cumulative distribution.
- This distribution is the continuous probability distribution.
- Lognomal distribution is also called Galton's distribution.
- 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.
- This function will give the result as error when
- Any one of the argument is nonnumeric.
- prob<0 or prob>1 or sd<=0
Examples
- LOGINV(0.039084,3.5,1.2)=4.000025219 (EXCEL)=3.9957031(CALCI)
- LOGINV(0.24786,6.25,3.12)=61.83892171 (EXCEL)=NULL(CALCI)
- LOGINV(0.007543,5.82,2.9) =0.292909096(EXCEL)=NULL(CALCI)