Missing zero population size error cases in some OpenFormula statistical function definitions

XMLWordPrintable

    • Hide

      Add a constraint to each of the affected functions, reading:

      STDEVP exchange "Constraints: None." with "Constraints: COUNT(N) >= 1."
      STDEVPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1."
      VARPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1."

      Show
      Add a constraint to each of the affected functions, reading: STDEVP exchange "Constraints: None." with "Constraints: COUNT(N) >= 1." STDEVPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1." VARPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1."

      I've been doing some research on missing spreadsheet function constraints, and I noticed that, in a couple of the OpenFormula statistical functions, there should be a constraint requiring population size to be greater than zero. All the existing implementations I tested already return an error in this instance, but it probably ought to be added to OpenFormula.

      The functions affected are:

      STDEVP (ODF 1.2 Part 2, 6.18.74)
      STDEVPA (6.18.75)
      VARPA (6.18.85)

            Assignee:
            Unassigned
            Reporter:
            Chris Rae (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: