Can we calculate RSD ( relative standard deviation) in Excel

Mike Middleton · Sep 4, 2008

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

zizi · Sep 14, 2008

many many thx to mike.
ur information help me alot

median standard deviation	7	Apr 20, 2010
Standard deviation	5	Oct 15, 2007
relative standard deviation	1	Jan 29, 2009
Negative Standard Deviations?	3	Jan 27, 2010
standard deviation plotting	1	Jul 23, 2008
Standard deviation	2	Jul 28, 2008
Standard Deviation	1	Jun 15, 2009
%RSD	6	Jul 28, 2009

Can we calculate RSD ( relative standard deviation) in Excel

zizi

Mike Middleton

zizi

Ask a Question

Similar Threads