Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-1132 Public Comment: [office-formula] problems with some functions, most statistical
  3. OFFICE-2298

TTEST

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html

      As of draft draft22a:
      For type=1 change
      t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n -1}}
      to
      t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n }}

      Show
      Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html As of draft draft22a: For type=1 change t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n -1}} to t = ABS{{overline X - overline Y} over { sqrt{s^2_{X-Y}} } sqrt { n }}
    • Resolution:
      Hide

      Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html

      Show
      Change the description of TTEST as shown in the attachment to http://www.oasis-open.org/apps/org/workgroup/office-formula/email/archives/201001/msg00088.html

      Description

      == 6.17.80 TTEST ==

      A lot of problems
      (1) All formulas miss the degrees of freedom. It is necessary for TDIST.
      In case unequal variance there must be defined, whether the degrees of
      freedom are made integer by FLOOR or whether they remain real.
      (2) In case paired: sqrt

      {n-1}

      is wrong because it is already contained
      in s_

      {X_1 - X_2}

      .
      (3) In case equal variance: definition of s² is missing.
      (4) In case unequal variance: definition does not meet usual
      definitions. In fact it is the definition for the equal variance case,
      with pooled variance.
      (5) As TDIST actually returns the values of the cumulative distribution
      function, the definite integral in the formulas has to be revised
      together with TDIST.

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow (Inactive)
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: