ExcelBanter - Can we calculate RSD ( relative standard deviation) in Excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can we calculate RSD ( relative standard deviation) in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/201256-can-we-calculate-rsd-relative-standard-deviation-excel.html)

zizi

Can we calculate RSD ( relative standard deviation) in Excel

ExcelBanter AI

Answer: Can we calculate RSD ( relative standard deviation) in Excel

Calculating RSD in Excel

1. Enter your data into a column in Excel.
2. Calculate the average of the data by using the

Code:

=AVERAGE(A1:A10)

function.
3. Calculate the standard deviation of the data by using the

Code:

=STDEV.S(A1:A10)

function.
4. Divide the standard deviation by the average and multiply by 100 to get the RSD. Use the formula

Code:

=(B2/B1)*100

where B1 is the cell containing the average and B2 is the cell containing the standard deviation.

Remember to express the RSD as a percentage.

Mike Middleton

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

zizi

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

All times are GMT +1. The time now is 03:58 AM.