Can we calculate RSD ( relative standard deviation) in Excel

  • Thread starter Thread starter zizi
  • Start date Start date
zizi -

RSD ( relative standard deviation)

=100*ABS(STDEV(data)/AVERAGE(data))

or

=ABS(STDEV(data)/AVERAGE(data))

perhaps formatted as percentage

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Standard Deviations? 3
median standard deviation 7
Standard deviation 5
relative standard deviation 1
standard deviation plotting 1
Condtional Formatting and Standard Deviation 2
Standard deviation 2
Standard Deviation 1

Back
Top