Thread: Can we calculate RSD ( relative standard deviation) in Excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
zizi zizi is offline
external usenet poster
  
Posts: 2
Default Can we calculate RSD ( relative standard deviation) in Excel
many many thx to mike.
ur information help me alot


"Mike Middleton" wrote:

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



Reply With QuoteReply With Quote