Docs

Pane tooltips stay short. Formulas, install, and the report skeleton live here.

Install

WhichStat is an Office.js Add-in. Use Insert → Add-ins, not File → Options → Excel Add-ins. Full steps: Download.

Glossary

n

Usable sample size after dropping missing and non-numeric cells.

Q1

First quartile (25th percentile) via Excel PERCENTILE.INC.

Q3

Third quartile (75th percentile) via Excel PERCENTILE.INC.

IQR

Interquartile range: Q3 − Q1, the middle 50% of the sample. Tukey fences: Q1 − 1.5×IQR and Q3 + 1.5×IQR.

SD

Sample standard deviation (n−1). Excel STDEV.S, not STDEV.P.

CV

Coefficient of variation: SD divided by the mean.

MAD

Median absolute deviation, scaled by 1.4826 so it matches SD on a normal sample.

G1

Fisher skewness (Excel SKEW). |G1| ≥ 1 is treated as strong skew.

ECDF

Empirical cumulative distribution function: share of points at or below each value.

DNA

Statistic DNA: when to use, when to avoid, and assumptions for this summary. Full cards: Statistics.

Report template

The PDF and the Report step follow the same skeleton: objective, data quality, fingerprint, which summary, statistic table (recommended + comparison), evidence plots, interpretation. Optional footer: Prepared with WhichStat for Excel · whichstat.com.

Pin notes are written to the sheet and PDF for audit. They do not change the engine rank.

Contributor layout: TypeScript monorepo (packages/stat-engine, apps/excel-addin, apps/website). Analysis never uploads raw samples.