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

Quick Steps

  1. Enter =(STDEV( in an empty cell.
  2. Type in the range (like B2:B10).
  3. Type ) once you've typed in the range.
  4. Type /AVERAGE( right after the formula.
  5. Enter the same range you typed previously (like B2:B10).
  6. Type )) .
  7. Enter *100 and hit Enter .

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
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unprotect an Excel Sheet
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Create a Graph in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Unhide Multiple Rows in Microsoft Excel
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Add a Column or Calculated Field in an Excel Pivot Table
      The Best Ways to Make & Format Lists in Excel
      How to
      Add a Best Fit Line in Excel
      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 154,275 times.

      Is this article up to date?

      Advertisement