STDEVP
Definition: The STDEVP function in Excel is used to find the standard deviation of a population.
Syntax: ==STDEVP(range).
Situation: This formula is appropriate in situations where you need to find the standard deviation of a population.
Example: If you have a range of data A1:A10, you would use the formula =STDEVP(A1:A10). This would return a value that indicates the standard deviation of the population.