Buzz
STDEV.P function is one of the statistical functions highly favored in Excel, calculating standard deviation based on the entire population in Excel.
STDEV.P Function in Excel
How to Use STDEV.P Function in Excel
1. Description and Syntax Usage
STDEV.P is a function that returns the standard deviation based on the entire population, ignoring logical and text values. Standard deviation measures the dispersion of values around the mean. The function is supported from Excel 2010 onwards.
Syntax:
STDEV.P(number1,[number2],...)
Where:
- Number1,[Number2],...: Are the values for which you want to calculate the standard deviation. Number1 is a required parameter, while the rest are optional and can contain up to 254 Number parameters.
Note:
- The STDEV.P function assumes its arguments are the entire population.
- With a large sample size ->STDEV.S, STDEV.P returns similar values.
Where:
+ x represents the sample mean AVERAGE(number1,number2,...)
+ n represents the sample size.
2. Specific Scenario Examples
Suppose you need to calculate the standard deviation based on the entire population of values in the data table below:
Step 1: In the cell where you want the result -> input the formula: =STDEV.P(B3:B7)
Step 2: Press Enter -> the result of the standard deviation based on the entire population is:
In cases where the values of elements in the set are text or logical values -> they are ignored:
If the arguments are text or error values that cannot be converted to numbers, then the STDEV.P function will result in an error:
An article on Mytour just shared with you about STDEV.P Function in Excel, which returns the standard deviation based on the entire population, ignoring logical and text values. With this function, the Number argument is the values for which you want to calculate the standard deviation, where Number1 is a required parameter, and the rest are optional, containing up to 254 Number parameters.
Using the IF function is not difficult at all; it's also a basic conditional function widely used, especially by those working in accounting using Excel. Explore IF function in Excel through the article on Mytour.
Using the STDEV function is also very simple, allowing you to achieve high efficiency in your work. If you're not familiar, you can refer to this article on the STDEV function.
