K
Kwei
Help me find the %RSD formulae in the Excel spreadsheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
And this is what?
best wishes
best wishes
F
Fred Smith
What's RSD?
Regards,
Fred
Regards,
Fred
G
Glenn
Kwei said:Help me find the %RSD formulae in the Excel spreadsheet
=STDEV(A1:A10)*100/AVERAGE(A1:A10)
G
Glenn
Bernard said:And this is what?
best wishes
Relative Standard Deviation
J
JoeU2004
Glenn said:=STDEV(A1:A10)*100/AVERAGE(A1:A10)
That is the way I always see the RSD formula written. But I wonder: is
the purpose of scaling by 100 simply to make the percentage appear as a
number between 0 and 100, but it is still interpreted as a percentage; or is
the statistic always expected to be scaled by 100, and it is interpreted as
an index?
Put another way, if the std dev is 4 and the mean is 8, would I say "the RSD
is 50", or would I say "the RSD is 50 percent".
If the latter, I would write the Excel formula as one of the following,
depending on whether the population or sample std dev is appropriate for the
statistical situation:
=STDEVP(A1:A10) / AVERAGE(A1:A10)
=STDEV(A1:A10) / AVERAGE(A1:A10)
formatted as Percentage (Format > Cells > Number).
J
Jerry W. Lewis
It is a percentage, so you are correct that the % format instead of
multiplying by 100 would be better. %RSD is the more common term in
analytical literature, CV (coefficient of variation) is more common in the
statistical literature.
Jerry
multiplying by 100 would be better. %RSD is the more common term in
analytical literature, CV (coefficient of variation) is more common in the
statistical literature.
Jerry