In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Profile a Dataset From Its Summary Statistics
Prompt
What the dataset is: {{DATASET_DESCRIPTION}}
Summary table for each column (count, missing, min, max, mean, median, standard deviation, distinct count; add top values for text): {{SUMMARY_STATS}}
Units and expected ranges I know of: {{EXPECTED_RANGES}}
Review each column and report:
1. Red flags: min or max outside plausible range, mean far from median (skew or outliers), counts that don't match the other columns, distinct counts suggesting IDs that aren't unique or categories that aren't consistent.
2. For each red flag, a hypothesis for the cause (data entry, unit mix-up, placeholder value like 0 or 9999, join error), labelled as a hypothesis, and the quick check to test it.
3. Columns that look fine, and why, in one line each.
4. Which columns I should not use for the planned analysis until the issues are resolved.
Only comment on what the numbers show. If I haven't supplied the stat you'd need, list it as a request instead of assuming. Do not estimate values for any column. Summary statistics can hide problems, so end by listing three visual checks (for example histograms) I should still run.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Profile a Dataset From Its Summary Statistics” is a free prompt for ChatGPT in the Reasoning & Problem-Solving category, 196 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 3 placeholders to fill in first:
{{DATASET_DESCRIPTION}}, {{SUMMARY_STATS}}, {{EXPECTED_RANGES}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 6 times.
Browse all Reasoning & Problem-Solving prompts, the AI prompt database or use the AI prompt finder to search every prompt.