OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Created: (OFFICE-2300) 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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]