Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been viewed 140,288 times.
Learn more...
This How.com.vn 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
Steps
Download Article
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.[1]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]
Expert Q&A
Video
Tips
References
About This Article
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
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
