STDEVP function - The function of calculating standard deviations in Excel

The following article details how to use the STDEVP function in Excel, which helps you calculate standard deviations based on patterns.

The following article details how to use the STDEVP function in Excel, which helps you calculate standard deviations based on patterns.

Description: Unlike the STDEV function, the STDEVP function helps you calculate the standard deviation or measure the dispersion of values ​​against the average value.

Syntax: STDEVP (number1, [number2] .) .

Inside:

- number1: The first argument value corresponding to the whole, is a required parameter.

- number2: The argument value from 2 to 255 corresponding to the whole, is an optional parameter. Values ​​can be individual values ​​(separated by commas) or values ​​are single or reference arrays.

Attention:

- The formula for calculating the function STDEVP :

STDEVP function - The function of calculating standard deviations in Excel Picture 1STDEVP function - The function of calculating standard deviations in Excel Picture 1

Where: X is the average value of the AVERAGE function (number1, number2, .) and n is the sample size.

- If the data represent a sample of the population, then calculate the standard deviation using the STDEV function .

- STDEV and STDEVP return nearly equal values ​​in case of large size samples.

- The standard deviation is calculated based on the "n" method .

- Value parameters can be numbers or names, arrays, or references that contain numeric values.

- The function counts arguments in the case of logical values ​​and presents the number of textual forms directly typed into the list.

- If the parameter is an array or reference -> only numeric values ​​in the array are counted, in addition, blank values, logical values, text . are ignored.

- The function will give an error in case the parameters are text or logical values ​​cannot be converted to numeric types.

- In case you want logical values, text . are allowed to calculate -> use STDEVPA function .

For example:

Calculate the standard deviation for durability of 3 products based on the following data table:

STDEVP function - The function of calculating standard deviations in Excel Picture 2STDEVP function - The function of calculating standard deviations in Excel Picture 2

In the cell to be calculated enter the following formula: = STDEVP (C8: E8) .

STDEVP function - The function of calculating standard deviations in Excel Picture 3STDEVP function - The function of calculating standard deviations in Excel Picture 3

Press Enter the standard deviation value between 3 products is:

STDEVP function - The function of calculating standard deviations in Excel Picture 4STDEVP function - The function of calculating standard deviations in Excel Picture 4

Make a copy of the formula for the remaining data cells -> The result is:

STDEVP function - The function of calculating standard deviations in Excel Picture 5STDEVP function - The function of calculating standard deviations in Excel Picture 5

With the above 3 products, if the durability of the 3 products is nearly the same -> the standard deviation value is usually less than 1. In case of 3 products with the same durability -> the value of STDEVP function = 0. Where the endurance of 3 products is nearly the same, the STDEV function has a value of 1, and the more accurate STDEVP function usually gets closer to 1.

The above is the usage and necessary notes when using the STDEVP function. Hope to help you solve the problem effectively and quickly. Good luck!

5 ★ | 1 Vote