STDEVX.S

The STDEVX.S function returns the standard deviation of a sample of the population drawn from a table to whose rows a certain expression is applied.

Syntax

STDEVX.S(
    table,
    expression
)

Parameters
  • table: Table containing the rows for which the expression will be evaluated.
  • expression: Expression to evaluate for each row of the table.
Returned value

The STDEVX.S function returns a real number.

Additional Information

The function evaluates the expression included as the second argument for each of the rows of the indicated table, returning the standard deviation assuming that the table refers to a sample of the population. If the table represents the total population, the STDEVX.P function should be used.

The STDEVX.S function uses the following formula:

STDEVX.S function. Standard deviation

...where x̃ is the mean value of x for the sample population and n is the size of the population. The use of n-1 instead of n is known as the Bessel's correction.

Empty rows are ignored in the calculation. If there are less than two non-empty rows, the function returns an error.

Examples

Suppose we have the following table showing a list of products and their sale price:

STDEVX.P function. Example of use

Assuming that the data shown is a sample of the population, we can calculate the standard deviation of the prices using the following measure:

Desviación estándar = STDEVX.S(Ventas, Ventas[Precio])

If we take this measure to a card-type display, we obtain the following result:

STDEVX.S function. Example of use

If, instead of a list of products and prices, we had a list of sales including the quantity sold and the unit price of each sale:

STDEVX.S function. Example of use

...we could calculate the standard deviation of the invoiced figures (that is, of the product of the quantity and the unit price) -assuming that they represent a sample of the population- with the following measure:

Desviación estándar = STDEVX.S(Ventas, Ventas[Cantidad] * Ventas[Precio])

...which, taken to a card-like display, returns the following result:

STDEVX.S function. Example of use

Category
Statistical
Submitted by admin on Mon, 12/03/2018 - 23:12