How a spreadsheet finds its own statistical test
All you do is paste your data. Every step after that follows a decision table written in advance, and the tool tells you why it chose what it chose.
Paste a table for an analysis selected by a pre-specified decision table, with reasons and reproducible R code.
Paste your data; the test is chosen from how the data are laid out
Your data is parsed and analysed in your browser and is never sent to a server.
Illustrative samples
Paste a data table with at least two columns.
Your analysis will appear here.
All you do is paste your data. Every step after that follows a decision table written in advance, and the tool tells you why it chose what it chose.
First the tool works out what each column is: text labels are groups, numbers are measurements, and a code that repeats marks the same subject. Where it cannot tell, it asks you to pick instead of guessing.
One thing cannot be read from the numbers: whether they come from the same samples measured twice. Guess wrong and the whole result is wrong, so this is the one question the tool asks you directly.
Four things guide the method: outcome type, number of groups, pairing, and each group's distribution shape. A fixed rule checks skew and the mean–median gap, then shows the judgement for you to confirm.
When the data are roughly normal, Welch compares the means. When they are skewed, the tool compares ranks instead. You can see the shape judgement for each group and confirm it before the analysis.
Whichever method is selected, the tool always runs the other method as a robustness check. Agreement adds confidence; disagreement is a reason to look back at the data points, not to pick the smaller p value.
Immunohistochemistry often produces many zero scores. When zeros are common, the tool splits the question in two — how many samples stained at all, and how strongly the stained ones stained — and then combines them into one answer.
What you get at the end is a result you can put in a paper: the method, the sample sizes, the test statistic, degrees of freedom, the exact p value and the effect size — with a 95% confidence interval wherever a standard method for one exists.
Back to the top and paste your data ↑