Share via

How to use the Relative Standard Deviation formula on Excel 2008

Anonymous
2012-01-27T04:27:47+00:00

Original Title:"relative standard deviation on excel"

I am using Excel from Microsoft Office 2008 on my mac and I can't figure out how to do the relative standard deviation formula (RSD). I know there is a way to do it on a PC with an older version of Microsoft Office and I found shortcut for standard deviation (STDEV), but I can't find one for relative standard deviation (RSD).  Please Help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2012-01-27T05:00:13+00:00

    RSD  is just the sample standard deviation divided by the expected value of the sample, so 

    RSD = STDEV(rng)/AVERAGE(rng)

    formatted as a percentage or

    RSD = 100 * STDEV(rng)/AVEREAGE(rng)

    when formatted as a number.

    I don't remember any version of XL actually combining the two into a single function - there's hardly any point...

    Note that in XL2011, STDEV() is deprecated, so the preferred formula is

    =STDEV.S(rng)/AVERAGE(rng)

    but the first will still work.

    20+ people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest