[OASIS Issue Tracker] Commented: (OFFICE-2217) ZTEST: inaccuratedescription and one-sided vs. two-tailed

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

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16688#action_16688 ] 

Andreas Guelzow  commented on OFFICE-2217:
------------------------------------------

First of all, even if we wanted to change ZTEST to this (unusual) definition, we would need to  change much more than just the summary.

We should note that: 
1) this is not what one would normally expect from the ZTEST function.
2) I am not sure what is meant with a z-statistic computed based on the sample (since the population mean and population std dev is known we really only use the mean of the sample)
3) This is not what Gnumeric calculates
4) This is not what OpenOffice.org 3.1.1 calculates
5) This is not what Excel claims to calculate (I don't know what it really determines.)

> ZTEST: inaccurate description and one-sided vs. two-tailed
> ----------------------------------------------------------
>
>                 Key: OFFICE-2217
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2217
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eike Rathke
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2
>
>
> Broken out from OFFICE-790
> The current summary and description of ZTEST is inaccurate.
> This may be of help for understanding:
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_ZTEST_function
> See also http://qa.openoffice.org/issues/show_bug.cgi?id=90759

-- 
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