What is the STDEV.P Function?
The STDEV.P Function is categorized under Statistical functionsFunctionsThe STDEV.P Function is categorized under Statistical functions. STDEV.P will calculate the standard deviation that is based on an entire population given as arguments. It will ignore logical values and text. As a financial analyst, the stdev.p function can be useful in calculating deviations in revenue. STDEV.P will calculate the standard deviation that is based on an entire population given as arguments. It will ignore logical values and text.
As a financial analyst, the STDEV.P function can be useful in calculating deviations in revenue. Portfolio managersPortfolio ManagerPortfolio managers manage investment portfolios using a six-step portfolio management process. Learn exactly what does a portfolio manager do in this guide. Portfolio managers are professionals who manage investment portfolios, with the goal of achieving their clients’ investment objectives. often use standard deviation to measure and keep track of their portfolios’ risks.
The STDEV.P function was introduced in MS Excel 2010 and hence, is not available in earlier versions. However, the function is simply an updated version of the older STDEVP function.
Formula
=STDEV.P(number1,[number2],…)
The STDEV.P function uses the following arguments:
- Number1 (required argument) – It is the first number argument that corresponds to a population.
- Number2 (required argument) – It is a number argument that corresponds to the population.
Notes
- The given arguments must provide at least two numeric values to the function.
- The arguments should be between 1 and 255 numeric values, arrays of values, or references to cells containing numbers.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- The function is used when we want to calculate the standard deviation for a sample of a population. If we are calculating the standard deviation of an entire population, we need to use the STDEVP function or the STDEV.P function.
How to use the STDEV.P Function in Excel?
As a worksheet function, STDEV.P 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 1
Suppose we are given a record of a business’ monthly sales 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.P Function
- #DIV/0! error-– Occurs if none of the values that are supplied to the function are numeric. Text representations of numbers that are provided as a part of an array are not recognized as numeric values by the STDEV.P function.
- #VALUE! error – Occurs if any of the given values provided directly to the STDEV function are text values that cannot be interpreted as numeric values.
- The STDEV.P function is used in calculating the standard deviation for an entire population. If we wish to calculate the standard deviation of a sample population, we need to use the STDEV.S function.
Click here to download the sample Excel file
Additional resources
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial modeling and valuation analysis. To learn more, check out these additional resources:
- Excel Formulas 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
- Advanced Excel Class
- Advanced Excel FunctionsAdvanced Excel Formulas Must KnowThese advanced Excel formulas are critical to know and will take your financial analysis skills to the next level. Advanced Excel functions you must know. Learn the top 10 Excel formulas every world-class financial analyst uses on a regular basis. These skills will improve your spreadsheet work in any career
- Excel Shortcuts CheatsheetExcel 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