Open the Excel sheet that contains your data. Before you can find the RSD of a range, you’ll need to use the STDEV formula to calculate the standard deviation.
Type =(STDEV( into a blank cell. This starts the formula.
Highlight the range. This adds the range to the formula. For example, to calculate the standard deviation for the values of cells A2 through A10, highlight cells A2 through A10. A2:A10 will be added to the formula. You can also type the range into the formula manually.
Type ) after the range in the formula. The formula should now look like this (if the values are A2:10): =(STDEV(A2:A10)
Type /AVERAGE(. Type this right after the last character of the formula.
Highlight the range again. Just as you did before, drag the mouse over the range of values, or manually type the same range for which you just calculated the standard deviation.
Type )). The formula should now look like this (using the example): =(STDEV(A2:A10)/AVERAGE(A2:A10)).
Type *100. This tells Excel to multiply the result of the formula by 100. This step ensures that the RSD displays in the correct format (as a percentage). The full formula should now look like this: =(STDEV(A2:A10)/AVERAGE(A2:A10))*100
Press ↵ Enter or ⏎ Return. The RSD for the range now appears in the cell in which you typed the formula. If the value displays a decimal instead of a percentage, click the cell once to select it, click the small arrow next to ″Number Format″ on the Home tab, then select Percentage.
Comments
0 comment