Calculates the standard deviation based on an entire population given as arguments Show
What is the STDEV.P Function?The STDEV.P Function[1] is categorized under Excel 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, for example, calculating deviations in revenue. Portfolio managers 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:
Notes
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 1Suppose 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:
Things to remember about the STDEV.P Function
Click here to download the sample Excel file Additional ResourcesThanks 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 CFI resources:
Article Sources
Which Excel function returns the population standard deviation?The Excel STDEV function returns the standard deviation for data that represents a sample. To calculate the standard deviation for an entire population, use STDEVP or STDEV.
Which of the following functions will determine the standard deviation of a sample?Which of the following functions will determine the standard deviation of a sample? STDEV. S calculates the standard deviation of a sample.
What function returns the variance of a population quizlet?The VARPA function calculates the variance of a population for numerical values.
What function returns the variance of a population?The Excel VAR. P function returns the variance in an entire population. If data represents a sample of the population, use the VAR. S function.
|