6.17.32 GAUSS does not make sense

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • 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
    • 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"

      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!

            Assignee:
            Andreas Guelzow (Inactive)
            Reporter:
            Andreas Guelzow (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: