Thread: relative standard deviation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default relative standard deviation
Hi,

Try

=STDEV(A1:A10)/AVERAGE(A1:A10)

or if you have negative numbers in your dataset

=ABS(STDEV(A1:A10)/AVERAGE(A1:A10))

Mike



"divyesh" wrote:

how to calculate rsd in excel
Reply With QuoteReply With Quote