Excel Tools
Excel Tools for Laboratory Quality & Statistical Evaluation
Practical, standards-aligned Excel tools for accredited laboratories, proficiency testing providers, reference material producers and laboratory quality professionals.
Our Excel-based tools provide practical support for laboratory statistics, data analysis, quality control, technical evaluation, and result assessment. They help laboratory professionals perform complex calculations and statistical evaluations in a clear, consistent, and efficient way.
The tools support laboratory activities based on relevant requirements and statistical principles of ISO/IEC 17025, ISO 5725, ISO 13528, ISO/IEC 17043, and ISO 17034, helping organizations strengthen data reliability, improve consistency in evaluation processes, and support technically sound laboratory decisions.
Basic Statistical Calculator
General-purpose statistical calculations for routine laboratory data, including mean, SD, variance and RSD.
Learn more
Outliers Tool
Detect and evaluate potential outliers using Dixon, Grubbs and Cochran statistical tests.
Learn more
Repeatability Evaluation
Evaluate method repeatability, including repeatability standard deviation, repeatability limit and coefficient of variation.
Learn more
Intermediate Precision
Evaluate intermediate precision using ANOVA or single-dataset statistical approaches.
Learn more
Bias & Recovery
Evaluate analytical method bias and recovery using certified reference materials, proficiency testing results or spiked samples.
Learn more
Linearity
Assess calibration linearity using regression statistics, residuals and associated statistical tests.
Learn more
LOD / LOQ
Estimate detection and quantification limits using multiple commonly applied calculation approaches.
Learn more
Method Comparison
Compare two analytical methods using statistical approaches including t-tests, F-tests and regression.
Learn more
Robustness
Assess method robustness under deliberate changes to analytical parameters using structured experimental designs.
Learn more
PT Evaluation Tool
Evaluate proficiency testing data including robust statistics, Algorithm A, z- and zeta-scores, homogeneity and stability assessment.
Learn moreIncluded with Every Tool
More Than Just a Spreadsheet
Every ISO4LAB Excel tool includes a companion help guide and a validated dataset, helping users understand the workflow and apply the tool correctly.
Excel Tool
Ready-to-use calculation workbook
Help Guide
Step-by-step guidance for using the tool
Example Dataset
Worked data for understanding the calculation process
Latest Resources & Insights
ISO4LAB
Supporting laboratories, PT providers and CRM producers through practical tools, training, consulting and accreditation-focused solutions.
Quick Links
- Home
- About ISO4LAB
- Services
- Tools & Templates
- Resources
- Contact
Resources
- Blog
- Podcast
- Method Validation Planner
- QC Planner
- Free Tools & Downloads