Choose and interpret the right statistical test
Picks the right method for your question and data and explains results in plain language.
The prompt
Help me with a statistics question.
My question: [e.g. "Did the new process reduce errors?", "Is satisfaction different across regions?"]
My data: [variables, types (numeric/categorical), sample size, how it was collected]
Results so far (if any): [PASTE OUTPUT]
Tools I use: [Excel / Google Sheets / R / Python / SPSS]
Explain:
1. The right test or method and why — and the assumptions it requires (and how to check them).
2. How to run it in my tool, step by step.
3. How to interpret the output in plain language: effect size, confidence interval, p-value, and what they do and don't mean.
4. Common mistakes to avoid with this kind of data.
If my data or sample can't support the question, say so and suggest what would.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- PASTE OUTPUT
- Excel / Google Sheets / R / Python / SPSS
How this prompt is built
This prompt follows the Chain-of-Thought structure (Chain-of-thought prompting). A chain-of-thought prompt asks the model to work through a problem step by step before giving its answer, which tends to help on reasoning, planning and multi-part questions.
Related prompts
- Explain a complicated Excel formula in plain EnglishBreaks down a long or nested Excel formula step by step, says what it actually returns, and points out hidden risks.
- Build a simple spreadsheet to track ticket sales for an eventStep-by-step setup for a ticket sales tracker with a data entry form, search, totals, and payment status for fundraisers and community events.
- Solve an Excel or Google Sheets problemGets you the right formula, pivot, or approach — with an explanation you can reuse.
- Explain, debug, or speed up a SQL, Python, or DAX snippetExplains what an existing query or script does, fixes errors, and optimizes it.