Relative standard deviation (RSD) is a way to express how spread out a set of measurements is, as a percentage of the average. It takes the standard deviation of your data, divides it by the mean, and multiplies by 100. The result tells you whether your data points cluster tightly together or scatter widely, and because it’s a percentage, you can compare precision across datasets that use completely different scales or units.
How RSD Differs From Standard Deviation
Standard deviation tells you, in the same units as your data, how much individual values tend to deviate from the average. If you’re measuring the weight of tablets in milligrams, your standard deviation is also in milligrams. That’s useful on its own, but it doesn’t tell you whether that amount of spread is large or small relative to what you’re measuring.
RSD solves this by converting the spread into a percentage of the mean. A standard deviation of 2 mg means something very different if your tablets average 500 mg (RSD of 0.4%) versus 10 mg (RSD of 20%). The percentage lets you instantly judge whether the variation is tight or loose, and it lets you compare precision between measurements that have nothing in common, like comparing the consistency of a weight measurement to the consistency of a volume measurement.
You’ll also see RSD called the “coefficient of variation” (CV). The two terms use the same formula and produce the same number. RSD tends to appear in chemistry and pharmaceutical contexts, while CV is more common in biology, finance, and engineering, but they’re interchangeable.
The Formula
RSD is calculated in three steps:
- Find the mean: Add up all your values and divide by how many you have.
- Find the standard deviation: For each value, subtract the mean and square the result. Add all those squared differences together, divide by the number of values minus one, and take the square root.
- Calculate RSD: Divide the standard deviation by the mean, then multiply by 100 to get a percentage.
Written out: RSD = (standard deviation / mean) × 100.
A Worked Example
Suppose you weigh five samples and get 10.2, 10.4, 10.1, 10.3, and 10.5 grams. The mean is (10.2 + 10.4 + 10.1 + 10.3 + 10.5) / 5 = 10.3 grams.
Next, find each value’s difference from the mean, square it, and add them up: (−0.1)² + (0.1)² + (−0.2)² + (0.0)² + (0.2)² = 0.01 + 0.01 + 0.04 + 0.00 + 0.04 = 0.10. Divide by (5 − 1) = 4, giving 0.025. The square root of 0.025 is about 0.158 grams. That’s your standard deviation.
Finally, RSD = (0.158 / 10.3) × 100 = 1.53%. Your measurements vary by about 1.5% of the average, which in most contexts signals good precision.
What Counts as a “Good” RSD
There’s no single universal cutoff, because acceptable precision depends entirely on what you’re measuring and why. In pharmaceutical quality control, analytical methods are typically validated to show RSDs below 1–2% for assay work. Environmental or biological testing, where samples are inherently more variable, may accept RSDs up to 10–15%. Manufacturing processes tracked with Six Sigma methods aim for RSDs low enough to keep nearly all output within specification limits.
As a rough guide: an RSD under 1% indicates very tight agreement between measurements, 1–5% is considered good precision for most laboratory work, 5–10% is acceptable in fields with naturally variable samples, and anything above 10–15% usually warrants a closer look at your method or equipment. The FDA requires that analytical procedure validations report the RSD alongside confidence intervals so reviewers can judge whether precision meets the criteria for that specific test.
When RSD Becomes Unreliable
RSD has a mathematical weakness that catches people off guard: it breaks down when the mean is very small or close to zero. Because the mean sits in the denominator of the formula, a near-zero average inflates the RSD toward infinity, even if the actual spread in the data is tiny. For this reason, RSD should only be used when zero has real physical meaning for whatever you’re measuring. Weight, length, concentration, and area all qualify. Measurements where zero is an arbitrary point on the scale, like pH or temperature in Celsius, do not.
Small sample sizes also make RSD less trustworthy. The standard deviation estimate itself becomes unreliable with only two or three data points, and since RSD is built on top of that estimate, the percentage you get can be misleading. If you’re working with fewer than about five or six measurements, treat your RSD as a rough indication rather than a firm number.
RSD is also not appropriate for evaluating limits of detection or quantitation, where you’re working at the very bottom of a method’s measurement range and the signal is small relative to noise.
Calculating RSD in Excel
Excel doesn’t have a built-in RSD function, but the formula is simple. If your data is in cells A1 through A100, enter this in any empty cell:
=(STDEV.S(A1:A100)/AVERAGE(A1:A100))*100
STDEV.S calculates the sample standard deviation (dividing by n−1, which is appropriate for most real-world datasets where you’re measuring a sample rather than an entire population). AVERAGE gives the mean. The result is your RSD as a percentage. If you’re working in Google Sheets, the same formula works identically.
Where RSD Gets Used in Practice
RSD appears most often in fields where measurement precision matters and needs to be compared or reported. In analytical chemistry, it’s the standard way to report how reproducible a test method is. Pharmaceutical companies include RSD values when validating that an assay consistently measures the right amount of active ingredient in a drug. Manufacturing quality teams track RSD to monitor whether a production process is staying consistent from batch to batch.
It’s also useful any time you need to compare variability across datasets with different averages. If one production line makes 50 mg tablets and another makes 500 mg tablets, their standard deviations won’t be directly comparable. Their RSDs will be, because both are expressed as a percentage of their respective means. That makes RSD one of the simplest tools for answering the question: which process, method, or instrument is more precise?