ExcelBanter - relative standard deviation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - relative standard deviation (https://www.excelbanter.com/excel-worksheet-functions/218316-relative-standard-deviation.html)

divyesh

relative standard deviation

how to calculate rsd in excel

Mike H

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

All times are GMT +1. The time now is 05:40 AM.