It would make sense to first verify that LOGNORMAL does what it is
supposed to do, i.e., what it does for Excel. It is well known that
arguments to Excel's statistical functions can be illogical or worse.
Nevertheless, changing the semantics away from Excel's is only going
to make things worse.
I agree, and believe the Gnumeric function RANDLOGNORM does exactly what
the Excel function LOGINV does, if a random probability is used in the
Excel function. The Excel help documentation explains the syntax of
LOGINV(probability,mean,standard_dev) and gives an example. If one uses
the Excel
Jean Bréfort and Andreas J. Guelzowasked had an exchange about the
lognormal distribution on 22 Aug.
There seems to be little documentation on how the /randlognorm/ function
works. We see in the help file:
Name
|RANDLOGNORM|
Synopsis
|RANDLOGNORM|(/|zeta|/,/|sigma|/)
Description
|RANDLOGNORM
Hi,
Our Lognormal distribution support does not have a shape parameter as
described at
http://www.itl.nist.gov/div898/handbook/eda/section3/eda3669.htm
Is that correct or a gnumeric bug (or a R-project bug)?
Cheers,
Jean
___
gnumeric-list mailing
On Fri, 2008-08-22 at 12:07 +0200, Jean Bréfort wrote:
Hi,
Our Lognormal distribution support does not have a shape parameter as
described at
http://www.itl.nist.gov/div898/handbook/eda/section3/eda3669.htm
Is that correct or a gnumeric bug (or a R-project bug)?
Note from the same page
On Fri, 2008-08-22 at 12:07 +0200, Jean Bréfort wrote:
Hi,
Our Lognormal distribution support does not have a shape parameter as
described at
http://www.itl.nist.gov/div898/handbook/eda/section3/eda3669.htm
Is that correct or a gnumeric bug (or a R-project bug)?
Note from the same page
Le vendredi 22 août 2008 à 07:07 -0600, Andreas J. Guelzow a écrit :
On Fri, 2008-08-22 at 12:07 +0200, Jean Bréfort wrote:
Hi,
Our Lognormal distribution support does not have a shape parameter as
described at
http://www.itl.nist.gov/div898/handbook/eda/section3/eda3669.htm