Can we calculate RSD ( relative standard deviation) in Excel

[Mike Middleton]

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]

many many thx to mike.
ur information help me alot