Compatibility - STDEV Function

The STDEV function replaces the STDEV.S function in Excel 2010.

Description

The function estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Syntax

STDEV (number1,[number2],...)

Arguments

Argument Description Required/ Optional
Number1 The first number argument corresponding to a sample of a population. Required
Number2, ...

Number arguments 2 to 255 corresponding to a sample of a population.

You can also use a single array or a reference to an array instead of arguments separated by commas.

 Optional

Notes

  • STDEV uses the following formula −

    $$\sqrt{\frac{\sum(x-\bar{x})^2}{(n-1)}}$$

    Where x is the sample mean AVERAGE (number1,number2,…) and n is the sample size.

  • STDEV assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the standard deviation using STDEVP

  • The standard deviation is calculated using the "n-1" method.

  • Arguments can be either numbers or names, arrays, or references that contain numbers.

  • Logical values and text representations of numbers that you type directly 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, logical values, text, or error values in the array or reference are ignored.

  • Arguments that are error values or text that cannot be translated into numbers cause errors.

  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the STDEVA function.

Example

STDEV Function
advanced_excel_compatibility_functions.htm
Advertisements