Hi all,
In Calc up to OOo 2.4 and in Excel [1] the function GAMMADIST works in
this way:
GAMMADIST(x;a;b;0) = 1 / (b**a * Γ(a) ) * x**(a-1) * e**(-x/b)
[I write power as **]
Therefore GAMMADIST(2;3;5;0) returns ≈0.010725.
In ODF chapter 6.17.28 I now see, that there will be a function
GAMMADIST(Number x ; Number α ; Number λ ; Logical Cumulative ) which
returns in case Cumulative=FALSE() the value
GAMMADIST(x;α;λ;FALSE()) = λ**α / Γ(α) * x**(α-1) * e**(-λ*x)
Here GAMMADIST(2;3;5;FALSE) would return ≈0.01134998
I think, that it is no good idea to change the meaning of a function.
All old documents would break. I know there is λ=1/b and both
definitions are usual in literature, but Calc should stick to one way.
[1] http://office.microsoft.com/en-us/excel/HP052091011033.aspx
@Eike: You see, I'm still working on the subject „special functions in Calc“
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
