How it works
From a selection to a proven recommendation in seven steps — all inside Excel.
Tip: click any screenshot to open it larger, and use ‹ › to walk through the whole flow.
1Select & analyze
Select a numeric range in Excel and click Analyze selection on the WhichDist ribbon button.
2Data & quality
WhichDist reports descriptive statistics and flags blanks, errors, and outliers — nothing is deleted — with a plain-language quality verdict.
3Nature wizard
Tell it whether the data are continuous or discrete, the theoretical support, and your engineering major(s) — these shape the candidate set.
4Fit & rank
Candidate distributions are estimated by MLE/MoM and ranked by the AICc-led composite, always showing Anderson–Darling and Kolmogorov–Smirnov (χ² for discrete).
5Evidence & plots
Inspect the Distribution DNA and proof plots — histogram + fitted PDF, ECDF vs CDF, Q–Q, and a top-3 overlay — each with a short "how to read it" note.
6Export
Write the WhichDist_Results sheet, download JSON, or generate a PDF lab report. Pro unlocks Python/R/Arena/Simio/AnyLogic and Monte Carlo.
7Lab report
Generate a polished PDF lab report — descriptive statistics, the ranked comparison, the Distribution DNA, the proof plots, and ready-to-paste Excel/Python/R/Arena/Simio/AnyLogic snippets gathered into one document you can print, archive, or attach to a thesis or assignment.