Leonard Mada wrote:
One LAST COMMENT:
The code outputs the *F statistic*, NOT the *p Value*.
To obtain the p-value, a call to FDIST('F statistic value', dfB, dfE)
must be made, BUT:
- I did NOT figure out yet where this function is and how it's named
- all statistic software outputs both the F statistic AND the p-value
[and a lot of other data - this is actually meaningful]
So, in the longer term we must also think about more expanded output,
because Calc is really limited here. And all modern statistical
functions and techniques DO OUTPUT a lot of data, not just a p-value.
A function can return an array (LINEST does this, for example). However,
ANOVA was always an example of the things that might better be handled
in an add-on doing a one-time calculation, not an add-in function (see
issue 4921).
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
