Table of Contents
To calculate the standard deviation in Excel, enter the data set into a column, then click the Data tab and select “Data Analysis” from the Analysis group. Choose “Descriptive Statistics” from the list of options, then select the range of cells containing the data set. Make sure the “Summary statistics” box is checked, then click “OK.” The standard deviation will be listed in the output table.
You can use the following formulas to perform a standard deviation IF calculation in Excel:
Method 1: Standard Deviation IF (One Criteria)
=STDEV(IF(A:A="Value",C:C))
This formula calculates the standard deviation of values in column C where the values in column A are equal to “Value.”
Method 2: Standard Deviation IF (Multiple Criteria)
=STDEV(IF((A:A="Value1")*(B:B="Value2"),C:C,""))
This formula calculates the standard deviation of values in column C where the values in column A are equal to “Value1” and the values in column B are equal to “Value2.”
The following examples show how to use each formula in practice.
Example 1: Calculate Standard Deviation IF (One Criteria)
We can use the following formula to calculate the standard deviation of the values in the Points column where the value in the Team column is equal to “Mavs”:
=STDEV(IF(A:A="Mavs",C:C))
The following screenshot shows how to use this formula in practice:
The standard deviation of Points for the rows where Team is equal to “Mavs” is 7.3326.
Example 2: Calculate Standard Deviation IF (Multiple Criteria)
We can use the following formula to calculate the standard deviation of the values in the Points column where the value in the Team column is equal to “Mavs” and the value in the Position column is equal to “Guard”:
=STDEV(IF((A:A="Mavs")*(B:B="Guard"),C:C,""))
The standard deviation of Points for the rows where Team is equal to “Mavs” and Position is equal to “Guard” is 5.5603.
Related: