To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94555 Issue #|94555 Summary|ODFF: introduce GAMMA, CHISQDIST, CHISQINV. Adapt GAMM |ADIST parameter Component|Spreadsheet Version|DEV300m30 Platform|PC URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|PATCH Priority|P3 Subcomponent|code Assigned to|er Reported by|regina
------- Additional comments from [EMAIL PROTECTED] Wed Oct 1 22:38:32 +0000 2008 ------- This patch contains several changes according to ODFF (1) Introduce the GAMMA function I put the GAMMA function to the group "Statistical functions", although it is in the "Mathematical" group in chapter 6.15 in ODFF spec, because the GAMMALN function is in "Statistic" too. The domain of the GAMMA function contains negative values. The ODFF draft spec is not adapted yet. (2) Introduce CHISQDIST In contrast to CHIDIST (now LEGACY.CHIDIST) it gives the left tail probability, same as other distributions do. In addition it has an optional parameter to calculate the density function. (3) Introduce CHISQINV I use the same way as the other inverse distribution functions are computed. (4) Adapt the "cumulative" parameter of the GAMMADIST function to be logical and optional. (5) Adapt the domain of CHIDIST to allow negativ x, see ODFF 6.17.10. (6) Remove the constraint "degrees of freedom < 1.0E5" from CHIDIST and CHIINV because they are no longer needed with the new implementation in issue 90703. Please notice, that the ODFF draft spec is wrong in the third parameter of GAMMADIST and GAMMAINV. OOo, Excel, and Gnumeric use the third parameter 'beta' in the way, that mean=alpha•beta, but ODFF draft spec uses the third parameter 'lambda' in the way that mean=alpha/lambda. The application help must explain, which use of the parameter OOo has, because the commom usage of the parameter differs between countries. Unfortunately the identifier GAMMAINV is already used for the inverse of the Gamma-distribution. It can likely be confused to be the inverse of the Gamma function. A comment in the application help is necessary. The patches are zipped to one file. The patches are made against this versions, which is m30 and cws odff05: compiler.hrc Revision 1.20 opcode.hxx Revision 1.23 compiler.src Revision 1.59 scfuncs.hrc Revision 1.14 scfuncs.src Revision 1.95 hidother.src Revision 1.29 interpr.hxx Revision 1.35 interpr4.cxx Revision 1.57.98.2 interpr3.cxx Revision 1.25 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]