Download Article
Download Article
This wikiHow teaches you how to find the Relative Standard Deviation (RSD) of a range in Microsoft Excel. The formula you’ll need to use is =(STDEV(RANGE)/AVERAGE(RANGE))*100
Quick Steps
- Enter =(STDEV( in an empty cell.
- Type in the range (like B2:B10).
- Type ) once you've typed in the range.
- Type /AVERAGE( right after the formula.
- Enter the same range you typed previously (like B2:B10).
- Type )) .
- Enter *100 and hit Enter .
Steps
-
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.
-
Advertisement
-
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 . [2] X Research source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Article Summary
X
To find the relative standard deviation of a range, first find the standard deviation (using the STDEV function), divide it by the range's average, and then multiple the result by 100. Use this formula: =(STDEV(RANGE)/AVERAGE(RANGE))*100
Did this summary help you?
Thanks to all authors for creating a page that has been read 155,967 times.
Advertisement