2.1.1044 Part 1 Section 18.17.7.301, STDEVP

  • Article

a.   The standard maps x to sample value, x-bar to sample mean, and n to the sample size.

Office maps x to a population value, x-bar to the population mean, and n to the population size.

b.   The standard states that if data represents a population sample only, STDEVA should be used.

In Office, STDEV should be used in this case.

c.   The standard does not specify what happens if population size is 0.

Office returns #DIV/0! if population size is 0.