Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
What is the STDEV Function?
The STDEV Function[1] is categorized under Excel Statistical functions. The function will estimate the standard deviation based on a sample.
As a financial analyst, STDEV can be useful in using the annual rate of return on an investment to measure its volatility. A risky stock will show a higher standard deviation while a safer stock, such as blue-chip companies like Apple or Coca-Cola, will show a lower standard deviation.
Formula
=STDEV(number1,[number2],…)
The STDEV function uses the following arguments:
Number1 (required argument) – This is the first number argument that corresponds to a sample of a population.
Number2 (optional argument) – This is a number argument that corresponds to a sample of a population.
Notes
Arguments must provide two or more numeric values to the function.
The function can contain 1–255 numeric arguments.
Arguments can either be numbers, arrays, or references that contain numbers.
STDEV is used to calculate the standard deviation of a population sample. To calculate the standard deviation of a whole population, we should use STDEVP or STDEV.P instead.
How to use the STDEV Function in Excel?
As a worksheet function, STDEV can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider an example:
Example
Suppose we are given the test scores of students below:
For the standard deviation, the formula used is:
We get the results below:
The equation used is:
Where:
x takes on each value in the set
x is the average (statistical mean) of the set of values
n is the number of values
Things to remember about the STDEV Function:
#DIV/0! error – Occurs if less than two numeric values are provided to the STDEV function.
#VALUE error – Happens if any of the given values to the function are text values.
In MS Excel 2010, the STDEV function has been updated to the STDEV.S function. However, STDEV can still be used to allow for backward compatibility with older versions of Excel.
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly improve your financial modeling in Excel. To learn more, check out these additional CFI resources:
To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.