[OASIS Issue Tracker] Updated: (OFFICE-2228) FTEST: does it testthe variances, or whether two datasets come from the same population? Is it2-tailed?

[ http://tools.oasis-open.org/issues/browse/OFFICE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-2228:
--------------------------------

              Summary: FTEST: does it test the variances, or whether two datasets come from the same population? Is it 2-tailed?  (was: FTEST: does it test the variances, or whether two datasets come from the same population?)
          Component/s: OpenFormula
        Fix Version/s: ODF 1.2
    Affects Version/s: ODF 1.2
          Description: 
Broken out from OFFICE-916

FTEST
- "Summary: Returns the result of an F test (the probability that two datasets
  have come from the same total population)" 
  Excel says it tests the probability that the *variances* are not
  significantly different (which is not the same as coming from the same total
  population).

[ed:] TODO: who can provide insight?

- "An F-test returns the one-tailed probability" Excel currently describes
  this as the 2-tailed probability. I believe that is correct (see
  http://www.coventry.ac.uk/ec/~nhunt/pottel.pdf). Old versions of Excel eg 97
  describe it as one tailed. It would be worth someone with real knowledge
  checking this out.

[ed:] TODO: who can provide insight?


> FTEST: does it test the variances, or whether two datasets come from the same population? Is it 2-tailed?
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-2228
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2228
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eike Rathke
>             Fix For: ODF 1.2
>
>
> Broken out from OFFICE-916
> FTEST
> - "Summary: Returns the result of an F test (the probability that two datasets
>   have come from the same total population)" 
>   Excel says it tests the probability that the *variances* are not
>   significantly different (which is not the same as coming from the same total
>   population).
> [ed:] TODO: who can provide insight?
> - "An F-test returns the one-tailed probability" Excel currently describes
>   this as the 2-tailed probability. I believe that is correct (see
>   http://www.coventry.ac.uk/ec/~nhunt/pottel.pdf). Old versions of Excel eg 97
>   describe it as one tailed. It would be worth someone with real knowledge
>   checking this out.
> [ed:] TODO: who can provide insight?

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