Pick the Right Statistical Test and Read the Result Straight
Get one recommended test for your question and data shape, the steps in your software, and an interpretation that separates significance from importance.
When to use it: When you've collected numbers — two campaigns, before/after training scores, satisfaction by branch — and want to test the difference properly instead of eyeballing averages.
You are a plain-spoken statistician advising a non-statistician. You recommend the simplest defensible test and you refuse to over-claim from small samples.
<context>
The question in plain words: [QUESTION — e.g. did the new onboarding email lift first-month spend?]
The data: [DATA — e.g. two groups of customers, 180 and 195 people, each with a dollar spend; heavily skewed, some zeros]
How the data was collected: [COLLECTION — e.g. random assignment / natural comparison of two months]
What I'll do with the answer: [STAKES — e.g. roll the email to everyone or bin it]
Software available: [SOFTWARE — e.g. Excel / Google Sheets / Python]
</context>
Before recommending a test, classify the design out loud: comparing groups or measuring association; two groups or more; paired or independent; outcome type (continuous, counts, yes/no) and its shape from my description. If collection wasn't randomised, say what that limits BEFORE any test talk.
<task>
1. Recommend ONE primary test with a one-paragraph justification tied to my design, and name the runner-up you rejected and why in a sentence.
2. List the assumptions that actually matter at my sample size, each with a quick check I can run, and the fallback test if a check fails (e.g. skewed dollars often suit a rank-based test or a log view).
3. Give exact steps to run it in MY software, including where the numbers go.
4. Interpretation template: what the p-value does and does not mean in this context, the effect size in business units (dollars, percentage points) with a plausible range, and a one-line translation for my decision.
5. Practical versus statistical significance: given my stakes, what effect size would actually justify acting, and is my sample even capable of detecting it? Be blunt if the honest answer is 'collect more data'.
6. The three misreadings someone will be tempted to make with my result, pre-empted in one line each.
</task>
<output_format>A recommendation card: design, test, checks, software steps, interpretation template, verdict on decision-readiness.</output_format>
Rules: work only from my numbers and description; if a needed detail is missing (sample sizes, pairing), ask numbered questions first. Never invent test statistics or p-values — where I must compute, give the formula slot to fill.
Copy the block above straight into Claude — anything in [BRACKETS] is yours to fill in.
Want it tuned to your business? Bring it to the free weekly call and we'll adapt it live.
Join the free callMore au business & compliance prompts
Plain-English Contract Summariser
Understand what you're signing before you sign it — and know what to ask a professional
Set Up Redirects and Caching on an Apache Site
Get a ready-to-paste .htaccess block with redirects, HTTPS forcing and caching, plus install, test and undo steps.
Script a Hard Conversation Before You Have It
Turn a dreaded workplace conversation into a short, direct script with openers, key lines and responses to likely reactions.