[OASIS Issue Tracker] Created: (OFFICE-2300) ZTEST

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

ZTEST
-----

                 Key: OFFICE-2300
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2300
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Sub-task
          Components: OpenFormula
    Affects Versions: ODF 1.2
            Reporter: Robert Weir 


== 6.17.86 ZTEST ==

The draft specification defines the result as 1-P(-|z| <= Z <= |z|), 
which is a two-tailed form. But the current implementations use a 
one-tailed form. Besides a real bug in OOo, Excel and OOo return
1-P( Z<=z) for z>=0 and
P( Z <= |z|) for z<0
Gnumeric returns P( Z <= |z|) for z<0 too, but I do not understand the 
result in Gnumeric for z>=0.

In other cases of changed semantic, for example the change from right 
tail to left tail in CHIDIST, for the old version LEGACY was introduced. 
Shouldn't there be a differentiation in the case of ZTEST too? I know 
the specification is only about the internal names and using a prefixed 
name for the old version internally is possible. But the names in the 
specification give a strong hint how the functions should be named in 
the UI of the applications and unique names in different applications 
would make working with different applications much easier for users.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira