How to Calculate RSD in Excel

PDF download Download Article
PDF download 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

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bb\/Calculate-RSD-in-Excel-Step-1.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/b\/bb\/Calculate-RSD-in-Excel-Step-1.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Before you can find the RSD of a range, you’ll need to use the STDEV formula to calculate the standard deviation.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6c\/Calculate-RSD-in-Excel-Step-2.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/6\/6c\/Calculate-RSD-in-Excel-Step-2.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This starts the formula. [1]
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/95\/Calculate-RSD-in-Excel-Step-3.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/9\/95\/Calculate-RSD-in-Excel-Step-3.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/53\/Calculate-RSD-in-Excel-Step-4.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/5\/53\/Calculate-RSD-in-Excel-Step-4.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The formula should now look like this (if the values are A2:10):
    • =(STDEV(A2:A10)
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/36\/Calculate-RSD-in-Excel-Step-5.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/3\/36\/Calculate-RSD-in-Excel-Step-5.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Type this right after the last character of the formula.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/73\/Calculate-RSD-in-Excel-Step-6.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/7\/73\/Calculate-RSD-in-Excel-Step-6.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cd\/Calculate-RSD-in-Excel-Step-7.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/c\/cd\/Calculate-RSD-in-Excel-Step-7.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The formula should now look like this (using the example):
    • =(STDEV(A2:A10)/AVERAGE(A2:A10)) .
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/06\/Calculate-RSD-in-Excel-Step-8.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/0\/06\/Calculate-RSD-in-Excel-Step-8.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":550,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Calculate-RSD-in-Excel-Step-9.jpg\/v4-460px-Calculate-RSD-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/d\/d3\/Calculate-RSD-in-Excel-Step-9.jpg\/aid10115233-v4-728px-Calculate-RSD-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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]
    10. 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
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      How to Combine Columns in Excel Without Losing Data
      Advertisement

      References

      1. ↑ https://support.office.com/en-us/article/stdeva-function-5ff38888-7ea5-48de-9a6d-11ed73b29e9d
      2. ↑ https://www.gcflearnfree.org/excel2013/formatting-cells/5

      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?
      In other languages
      Thanks to all authors for creating a page that has been read 143,584 times.

      Is this article up to date?

      Advertisement