SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / STDEV.P
In This Topic
    In This Topic

    This function returns the standard deviation for an entire specified population (of numeric values).




    Each argument can be a cell, a cell range, a float value, or an integer value. This function can have up to 255 arguments.


    The standard deviation is a measure of how widely values are dispersed from the average value. If your data represents a sample of the population, then compute the standard deviation using the STDEV function.

    The standard deviation is calculated using the "biased" or "n" method.

    Logical values and text representations of numbers that are typed into the list of arguments are counted. If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, error values, logical values, or text in the array or reference are ignored.

    The equation for calculating the standard deviation for a population is:

    STDEV.P Equation

    where x is the sample mean, AVERAGE(number1,number2,…), and n is the number of values.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.





    STDEV.P(95,89,73,87,85,76,100,96,96) gives the result 8.80796497