Thread: Can we calculate RSD ( relative standard deviation) in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default Can we calculate RSD ( relative standard deviation) in Excel
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