📘 Beginner Guide

Beginner's Guide to Precision Repeatability

A plain-language guide to what Precision Repeatability is for Assay, Dissolution, Content Uniformity, and Impurity, why every sample must keep its own weight in the calculation, the exact spreadsheet mistake that silently breaks it, and the ICH Q2(R1)/USP <1225> theory behind %RSD acceptance criteria — plus tips for filling in the calculator correctly.

🧪 Assay • Dissolution • CU • Impurity ⚖️ Per-Sample Own-Weight Rule 📊 %RSD Explained 🔬 HPLC / UV-Vis ✅ ICH Q2(R1) / USP <1225>
🧪 Precision Calculator 📘 Beginner Tips & Guide

What Is Precision (Repeatability) and How Does This Calculator Work?

🧪
What Is Repeatability?
Repeatability — also called intra-assay precision — checks how close your results are when you analyze several separate preparations of the same sample, on the same day, by the same analyst, on the same instrument. Regulatory guidance (ICH Q2(R1)) typically expects at least 6 independent sample preparations at 100% of the test concentration. This calculator supports repeatability studies for Assay, Dissolution, Content Uniformity, and Impurity/Related Substances — pick your Test from the dropdown before calculating.
⚖️
When Is %RSD Checked?
%RSD is calculated once all six (or more) replicate % Result values are available, and is compared against the acceptance limit stated in your method validation protocol — commonly ≤ 2.0% for repeatability, though tighter or looser limits may apply depending on your method SOP and test type (Impurity/trace-level methods often use a wider limit).

How the Calculation Works

  1. Select your Test from the dropdown — Assay, Dissolution, Content Uniformity, or Impurity. This is required; the calculator won't run until it's chosen.
  2. Weigh and inject your standard — get its average reading (peak area or absorbance) from system suitability injections.
  3. Weigh each of the 6 sample preparations individually — write down each one's exact weight. Each sample keeps its own weight; never share it between rows.
  4. Inject each sample and record its reading.
  5. Calculate mg/dosage for each sample using that sample's own weight in the denominator.
  6. Convert to % Result: (mg/dosage ÷ Label Claim) × 100.
  7. Calculate %RSD across all % Results and compare to your acceptance limit.

The #1 Mistake Beginners Make (and Excel Encourages)

Locking the sample weight cell. When building this calculation in Excel, it's extremely common to write the first row's formula correctly, then drag-fill it down — but accidentally leave the sample weight cell reference absolute (e.g. $F$34) instead of relative (F34, F35, F36...). Every row after the first then silently reuses the first sample's weight instead of its own.

Why it matters: dosage units are never perfectly uniform in weight. Using the wrong sample's weight introduces a small but real error into both the individual % Result and the overall %RSD — sometimes enough to change a borderline pass into a fail. This calculator asks for each sample's own weight in its own row on purpose, so this error can't happen here.

Beginner Tips — How to Fill the Form

  • Select Test (required): Choose Assay, Dissolution, Content Uniformity, or Impurity before you calculate — the calculator blocks Calculate and highlights the dropdown in red until a Test is picked.
  • Instrument Type: Choose HPLC (Peak Area) or UV-Vis (Absorbance) at the top — every label on the page updates to match, and UV-Vis also enforces a valid 0.00–2.00 AU reading range, flagging any out-of-range cell in red as you type.
  • Standard & Product Data: Enter this once — Average Standard reading, Weight of Standard, Dilution Factor, Average Weight (mg), Label Claim, and Potency of Standard. These apply to every sample below.
  • API Factor (optional): Leave this blank to use the default formula. If you enter a value, it's automatically multiplied into the mg/dosage formula — both the "without API Factor" and "with API Factor" versions are always shown side by side in the formula box above the table, with the one actually in effect highlighted.
  • Sample Data: Enter each sample's own reading and own Sample Weight (mg), one row per preparation. Most SOPs require at least 6 replicate preparations — use "➕ Add Sample" for more.
  • Multiple Readings per Sample (optional): Use "➕ Add Area of Sample Column" if your SOP takes more than one reading per sample preparation — the calculator averages that sample's own filled-in readings automatically before using it in the formula. It never mixes readings across different samples.
  • Complete Every Row: If you start filling a row, both the reading and Sample Weight need a value — an incomplete row gets highlighted red and blocks calculation until it's completed (or cleared entirely).
  • Acceptance Limit (%RSD): Use your method SOP's specified limit — commonly ≤ 2.0% for repeatability. Select "Custom Limit" if yours isn't listed.
  • Decimal Places: This only controls how many digits are displayed — it does not change the underlying precision of the calculation.
  • Live Stats: As you type, a quick count/mean/%RSD preview appears automatically below the rows so you can sanity-check your entries before running the full calculation.
  • Result: The calculator reports Mean, Max, Min and %RSD of % Result, plus a per-sample mg/dosage breakdown, a visual deviation map, and a trend chart.

Precision Repeatability — Theory & Guidelines

Regulatory Basis

  • ICH Q2(R1) — Validation of Analytical Procedures: Text and Methodology. Defines precision as repeatability, intermediate precision, and reproducibility, and recommends a minimum of 6 determinations at 100% of the test concentration for repeatability.
  • USP General Chapter <1225> — Validation of Compendial Procedures, covering acceptance criteria for Assay, Dissolution, Content Uniformity, and Impurity/Related Substances methods.

Typical Acceptance Criteria

ParameterTypical Limit*
%RSD of 6 replicate results (Assay / Dissolution / CU)≤ 2.0%
%RSD of 6 replicate results (Impurity / trace-level)Often wider — per protocol, commonly ≤ 5.0–10.0%
Individual result vs. label claimPer monograph / protocol, commonly 98.0–102.0%
*Always confirm limits against your own approved validation protocol or pharmacopeial monograph — these vary by product, test type, and method.

Repeatability vs. Intermediate Precision vs. Reproducibility

TermWhat Varies
RepeatabilityNothing — same analyst, instrument, day (this calculator)
Intermediate PrecisionDay, analyst, or instrument within the same lab
ReproducibilityDifferent laboratories entirely
Formula reminder (same for Assay, Dissolution, Content Uniformity & Impurity):
mg/dosage = (Sample Area × Std Weight (mg) × Dilution Factor × Avg. Weight (mg) × Potency of Standard (%)) ÷ (Avg. Standard Area × Sample Weight (mg) — this sample's own weight × 100)

mg/dosage — with API Factor = (Sample Area × Std Weight (mg) × Dilution Factor × API Factor × Avg. Weight (mg) × Potency of Standard (%)) ÷ (Avg. Standard Area × Sample Weight (mg) × 100)