Buzz
The STDEV function in Excel helps estimate sample standard deviation based on a sample. Standard deviation measures the dispersion of values around the mean. This article below will provide insights into the syntax and usage of this function.
Exploring Excel's STDEV Function
How to Use the STDEV Function in Excel - Illustrated Example
Syntax: STDEV(number1,[number2],...)
Where:
- Number1: The first argument corresponds to the population sample. Mandatory value.
- Number2: Arguments 2 through 255 correspond to the population sample. Optional values.
Consider an Example
We have 3 products, each corresponding to a durability represented by number1… as shown below. To calculate standard deviation, perform the following: Enter the formula in cell E5, yielding the result below.
Copy the formula down to the cells below
So, now you know how to use the STDEV function in Excel to calculate standard deviation based on a sample. You can use a single array or reference an array instead of individual arguments separated by commas. You can apply this function across Office 2013, Office 2010, Office 2007, and Office 2003 versions.
The AVEDEV function and DEVSQ function are also highly useful in Excel, allowing you to apply them to your work very effectively. Refer to the AVEDEV function and the DEVSQ function in the previous article to use the functions efficiently.
