What is the STDEV.S Function?
The STDEV.S Function is a Statistical functionFunctionsThe STDEV.S Function is a Statistical function, that will calculate the standard deviation that is based on a sample of the population. It will ignore logic, that will calculate the standard deviation that is based on a sample of the population. It will ignore logical values and text.
While doing financial analysis, the STDEV.S function can be useful in measuring the income of sample standard deviation representative of an entire population.
Formula
=STDEV.S(number1,[number2],…)
The STDEV.S function uses the following arguments:
- Number1 (required argument) – It is the first number argument that corresponds to a sample of the population.
- Number2 (optional argument) – It is a number argument that corresponds to a sample of the population.
Notes
- The given arguments must provide at least two numeric values to the function.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- The STDEV.S function is used to calculate the SD of a sample and not a population. To calculate the standard deviation for a population, use either the STDEVP function or the STDEV.P function.
How to use the STDEV.S Function in Excel?
As a worksheet function, STDEV.S 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:
Step by Step Example of STDEV.S Function
Suppose we are given a record of a business’ monthly expense figures over the last three years, as shown below:
For the standard deviation, the formula used is:
We get the results below:
The equation used for this 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.S Function
- #DIV/0! error – Occurs if none of the values that are supplied to the function is numeric. Sometimes the number may not be selected as a number.
- #VALUE! error – Occurs if any input values on the STDEV function are values that aren’t numeric values.
- The STDEV.S function is used when calculating the standard deviation for a sample population. If we are calculating the standard deviation of an entire population, we need to use the STDEV.P function.
Click here to download the sample Excel file
Additional resources
Thank you for reading this CFI guide to important Excel functions! By taking the time to learn and master these formulas, you’ll significantly speed up your financial modeling and analysis. To learn more, check out these additional resources:
- Excel for FinanceExcel for FinanceThis Excel for Finance guide will teach the top 10 formulas and functions you must know to be a great financial analyst in Excel. This guide has examples, screenshots and step by step instructions. In the end, download the free Excel template that includes all the finance functions covered in the tutorial
- INDEX MATCHIndex Match FormulaCombining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH MATCH in this Excel tutorial. Index returns the value of a cell in a table based on the column and row number and Match returns the position of a cell in a row or column. Learn how to them in this guide
- OFFSETOFFSET FunctionThe OFFSET function is categorized under Lookup and Reference functions. Offset will return a range of cells. It will return a specified number
- ShortcutsExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts