Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      6.17.32 GAUSS
      Summary: Returns 0.5 less than the standard normal cumulative distribution
      Syntax: GAUSS( Number x )
      Returns: Number
      Semantics: Returns NORMDIST(x;0;1;TRUE())-0.5

      Show
      6.17.32 GAUSS Summary: Returns 0.5 less than the standard normal cumulative distribution Syntax: GAUSS( Number x ) Returns: Number Semantics: Returns NORMDIST(x;0;1;TRUE())-0.5
    • Resolution:
      Hide

      Changed Summary to "Returns 0.5 less than the standard normal cumulative distribution"

      Show
      Changed Summary to "Returns 0.5 less than the standard normal cumulative distribution"

      Description

      Currently it says that:
      -------------------------------------------------------------------------
      6.17.32 GAUSS
      Summary: Returns the standard normal cumulative distribution
      Syntax: GAUSS( Number x )
      Returns: Number
      Semantics: Returns NORMDIST(x;0;1;TRUE())-0.5
      -------------------------------------------------------------------------

      THis does not make sense: NORMDIST(x;0;1;TRUE()) is the standard normal cumulative distribution function. So GAUSS cannot be both that function and differ by 0.5!

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              aguelzow Andreas Guelzow
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: