| Powerful statistical analysis, right inside Excel | Statistical process control that stands up to audit | The tools behind better diagnostic decisions | Method validation software trusted by regulators worldwide | Every statistical tool we make, in one licence | |
| Read more... | Read more... | Read more... | Read more... | Read more... | |
|
Annual subscription / Perpetual license More about annual vs. perpetual licenses... |
from US$ 155 / US$ 395 | from US$ 290 / US$ 760 | from US$ 340 / US$ 815 | from US$ 475 / US$ 1155 | from US$ 575 / US$ 1495 |
| Distribution & descriptive statistics | |||||
|---|---|---|---|---|---|
| Descriptive statistics | |||||
| Histogram, box-and-whisker plot, dot plot | |||||
| Normality tests (Shapiro-Wilk, Anderson-Darling, D'Agostino) and normal Q-Q plot | |||||
| 1-sample t-test & Wilcoxon signed-rank | |||||
| Compare groups | |||||
| Independent samples & paired t-tests | |||||
| One-way and multi-factor ANOVA | |||||
| Multiple comparisons (Tukey, Dunnett, Scheffé, Bonferroni, Games-Howell, and more) | |||||
| Non-parametric tests (Mann-Whitney, Wilcoxon signed-rank, Kruskal-Wallis, Friedman) | |||||
| Homogeneity of variance (Bartlett, Levene, Brown-Forsythe) | |||||
| Contingency tables | |||||
| Chi-square, Fisher exact, McNemar | |||||
| Odds ratio & relative risk with confidence intervals | |||||
| Mosaic plot | |||||
| Regression & model fitting | |||||
| Simple & multiple linear regression | |||||
| Logistic regression | |||||
| Multi-factor ANOVA / ANCOVA / GLM | |||||
| Leverage & influence diagnostics, Cook's D | |||||
| Predict Y from X with confidence & prediction intervals | |||||
| Main effect & interaction plots | |||||
| Correlation & multivariate | |||||
| Pearson / Spearman / Kendall correlation | |||||
| Scatter matrix | |||||
| Principal Components Analysis (PCA) with Gabriel & Gower-Hand biplots | |||||
| Factor analysis | |||||
| Cronbach's alpha & item reliability | |||||
| Process control | |||||
| Shewhart variable charts (Xbar-R, Xbar-S, I-MR) | |||||
| Shewhart attribute charts (p, np, c, u) | |||||
| Time-weighted charts (CUSUM, EWMA, UWMA) | |||||
| Detection rulesets (WECO, Nelson, Montgomery, custom) | |||||
| Phases and stratification | |||||
| Process capability | |||||
| Capability indices (Cp, Cpl, Cpu, Cpk, Cpm) | |||||
| Performance indices (Pp, Ppl, Ppu, Ppk) | |||||
| Nonconforming units & sigma metrics | |||||
| Non-normal transformations | |||||
| Pareto analysis | |||||
| Pareto chart | |||||
| 2-way stratification | |||||
| Combine, reorder & colour bars | |||||
| Measurement system analysis | |||||
| Precision — up to 3 random nested factors, balanced & unbalanced designs (EP05-A3) | |||||
| Variance components with Exact, Satterthwaite, and MLS confidence intervals | |||||
| Precision profiles with 6 variance function models (constant, CV, mixed, Sadler, alternative power, 4-parameter) | |||||
| Linearity with polynomial regression & Hsieh-Liu nonlinearity testing (EP06-A) | |||||
| Reportable range determination with adjustable measuring interval | |||||
| Detection capability — LoB, LoD, LoQ by parametric, non-parametric, probit, and variance function methods (EP17-A2) | |||||
| Verification of precision and trueness with ?² and equivalence tests (EP15-A3) | |||||
| Interference testing against allowable limits (EP10-A3-AMD) | |||||
| Generalised ESD outlier identification | |||||
| Method comparison | |||||
| Passing-Bablok regression (1983 & 1988) with CUSUM linearity test and bootstrap CIs | |||||
| Deming & Weighted Deming regression with systematic error decomposition and Syx | |||||
| OLS & Weighted OLS regression | |||||
| Bland-Altman mean and median bias with confidence intervals | |||||
| Bland-Altman limits of agreement with constant and non-constant (V-shaped) precision | |||||
| Bland-Altman linear trend fit for concentration-dependent (proportional) bias | |||||
| Bland-Altman allowable difference band | |||||
| Confidence intervals on the limits of agreement | |||||
| Difference plot & mountain plot | |||||
| Bias at clinical decision points with equality & equivalence tests | |||||
| Allowable difference as absolute, percentage, or combination (e.g. "10% with minimum 5 mg/dL") | |||||
| Total analytical error per EP21-A with allowable total error goals | |||||
| Partition the measuring range with separate fit & allowable difference per interval | |||||
| Replicate handling (mean, 1st replicate, 1st vs mean of reference) with correct within-subject variance | |||||
| Commutability with prediction intervals for processed samples (EP14-A3) | |||||
| Other agreement measures | |||||
| Cohen's Kappa & Weighted Kappa | |||||
| Fleiss' Kappa | |||||
| Reference intervals EP28-A3C | |||||
| Parametric quantile method | |||||
| Non-parametric quantile methods with 3 computation approaches — (N+1)p, Np+1/2, (N+1/3)p+1/3 | |||||
| Robust bi-weight method | |||||
| Bootstrap and Harrell-Davis quantile methods | |||||
| Partition by factor (sex, age, ethnicity, and more) | |||||
| Transformations — log, square root, reciprocal, Box-Cox, Manly exponential, 2-stage exponential/modulus | |||||
| Outlier screening with Tukey box plots and formal outlier tests | |||||
| Confidence intervals on reference limits | |||||
| Verify existing intervals with the binomial test for proportion inside the reference interval | |||||
| Transfer existing intervals to a new procedure using method comparison regression | |||||
| Diagnostic performance | |||||
| Empirical and binormal ROC curves (EP24-A2) | |||||
| AUC with DeLong confidence intervals and Z test | |||||
| Compare up to 10 paired or independent tests (DeLong) with equality, equivalence, and non-inferiority | |||||
| Sensitivity, specificity, predictive values, likelihood ratios, diagnostic odds ratio, Youden's index | |||||
| Optimal threshold by Youden, closest-to-(0,1), or minimum cost | |||||
| Decision plot of sensitivity, specificity, likelihood ratios, predictive values, or cost across thresholds | |||||
| Bi-histogram of positive and negative outcomes | |||||
| Qualitative test evaluation (EP12-A2) — Clopper-Pearson, Wilson, and Newcombe CIs, Score Z test, positive/negative agreement | |||||
| Survival analysis new in v6.10 | |||||
| Kaplan-Meier survival curve | |||||
| Log-rank test | |||||
| Cox proportional hazards with hazard ratio | |||||
| Software & validation | |||||
| Runs entirely within Microsoft Excel on your PC — no cloud, no data transmission | |||||
| Results stored as standard .xlsx — openable anywhere, no proprietary format | |||||
| Calculations validated against CLSI and NIST reference datasets | |||||
| Free email & telephone support | |||||
| Software updates included (annual subscription for the term; perpetual licence for 1 year, then via maintenance renewal) | |||||