Applies a senior statistician's workflow to your data: descriptive summary, justified test selection, models, effect sizes with confidence intervals, and a plain-language reading of what is practically significant.
Version 1 · 3 variables · 2 required
Fill in the values below — the customized prompt updates as you type. marks a required value.
Variables and their types, sample and group sizes, how the data was collected, completeness.
What you want to test, stated as questions or as directional hypotheses.
Usually 95% for business decisions, 99% where a wrong call is expensive. Default: 95%
Fill in Data structure and quality, Questions or hypotheses to copy the customized prompt.
Showing all 1 public result from Claude Sonnet 5 on version 1.
Contributor notes: Illustrative example — not an actual model run. Written to show the shape of a good answer so the prompt can be judged before you spend a call on it. Attribution: adapted from https://github.com/aj-geddes/useful-ai-prompts by aj-geddes, licensed MIT. Source file: https://github.com/aj-geddes/useful-ai-prompts/blob/main/prompts/analysis/statistical-analysis-expert.md
1 public result from 1 model
Reports go to moderators and are never shown publicly.
```csv quarter,line,units_produced,defects,defect_rate_pct,shift_pattern Q1,Line A,14200,318,2.24,"Two shifts, weekdays" Q1,Line B,11850,402,3.39,"Two shifts, weekdays" Q1,Line C,9600,151,1.57,"One shift, weekdays" Q1,Line D,UNCLEAR,88,UNCLEAR,"One shift, weekends" Q2,Line A,15040,295,1.96,"Three shifts, weekdays" Q2,Line B,12310,377,3.06,"Two shifts, weekdays" Q2,Line C,9880,143,1.45,"One shift, weekdays" Q2,Line D,4120,96,2.33,"One shift, weekends" ``` **Notes** - **UNCLEAR cells:** row 5 (Q
Extracts a table from a screenshot or scanned page into a flat, copy-paste-ready CSV, unmerging cells, stripping units into their own columns and flagging anything unreadable instead of guessing.
## 1. Technical Audit & Business Context | Column | Smell | Business impact | |---|---|---| | `churn_date` | Populated only for churned accounts | This is the label in disguise. Any model that sees it will score ~perfectly in training and be useless in production. | | `mrr` | Right-skewed, a long tail of enterprise accounts | Mean imputation would drag small accounts upward and understate churn risk in the SMB segment, which is where outreach capacity actually sits. | | `signup_date` | Mixed `Y
Audits a raw dataset for data smells, ties each issue to its business impact, then proposes an imputation, encoding and scaling strategy with a leakage-safe pandas and scikit-learn pipeline.
Converts a natural-language data requirement plus a table schema into a syntactically correct SQL query for a named database, with its assumptions stated up front.
**Recommended formula** — enter in Summary!B2 and fill down: =IFERROR(SUMIFS(Orders!$D$2:$D$5000, Orders!$B$2:$B$5000, $A2, Orders!$C$2:$C$5000, "Shipped", Orders!$A$2:$A$5000, ">="&DATE(2025,10,1), Orders!$A$2:$A$5000, "<="&DATE(2025,12,31)), 0) **How it works, step by step** 1. SUMIFS(sum_range, criteria_range1, criteria1, ...) adds values from Orders!D2:D5000 only for rows where every criteria pair matches. Unlike SUMIF it takes multiple conditions, so no helper column is needed. 2. Orders
Turns a described spreadsheet calculation into a working Excel formula plus a plain-language walkthrough of every function, operator and reference it uses.
Oldest first · one level of replies
Sign in to join the discussion. Share what you learned or made with this prompt.
No comments yet
Be the first to share how this prompt worked for you.