Paste a table, survey results, or report numbers and get the findings in plain language, with what is solid, what is noise, and what the data cannot tell you.
Help me understand this data. I am not a statistician.
What this data is and where it came from: {{context}}
The question I am trying to answer: {{question}}
Who I need to explain it to: {{audience:my team}}
Do this:
1. Describe what you are looking at: what each row and column represents, the time period, and the number of records.
2. Check quality first: missing values, obvious errors, duplicates, outliers, and anything that looks inconsistent. Tell me before drawing any conclusions.
3. Give the 3 to 5 most important findings. For each one:
- State it in a plain sentence, with the actual numbers.
- Say how confident I should be, and why. Is the difference large or small? Is the sample big enough? Could it be chance?
4. Answer my question directly, or tell me that this data cannot answer it and why.
5. Say what the data does not show. Point out anywhere it would be tempting to assume a cause when there is only a pattern.
6. Suggest the one chart that would show the main finding most clearly, and what goes on each axis.
7. Give me a 3-sentence summary I could say out loud to my audience.
Rules:
- Use only the numbers I gave you. Show your working for any figure you calculate, so I can check it.
- Do not call a difference "significant" unless you can justify it. Small samples and small differences should be described as such.
- Keep percentages honest: say "from 4 to 6 customers", not only "a 50% increase".
- If you need to know something about how the data was collected before you can interpret it, ask.
Data:
{{data}}
Turns a question about your data into a query, states every assumption it had to make, and explains the result so you can check it is answering the right thing.
Write a SQL query that answers my question.
Database: {{database:PostgreSQL}}
My question: {{question}}
Tables and columns (paste the schema, or describe the tables, their columns, and how they relate):
{{schema}}
Give me:
1. The query, formatted, with a short comment above any part that is not obvious.
2. A plain-English walkthrough: which tables it reads, how they are joined, what is filtered out, and how the result is grouped and sorted.
3. Every assumption you made. Common ones: what counts as "active" or "recent", how nulls are treated, whether time ranges include their end date, which time zone dates are in, and whether rows can be duplicated by a join.
4. What the output will look like: the columns, and one or two example rows.
5. A quick check I can run to confirm that the number is right, such as a count before and after the join.
Rules:
- Use only tables and columns from the schema I gave. If something I need is not there, say what is missing; do not make up a column.
- Use syntax that works in the database I named.
- If my question could mean two different things, write both queries and explain what distinguishes them.
- Watch for joins that multiply rows and inflate sums or counts. Call it out if that is a risk here.
- If the query could be slow on a large table, say which index would help.
- This is for reading data. Do not write anything that changes or deletes data unless I ask for it.
Describe what you want in words and get a working Excel or Google Sheets formula, explained piece by piece, with the mistakes to watch for.
Write a spreadsheet formula for me.
Spreadsheet program: {{app:Google Sheets}}
What I want the formula to do: {{goal}}
How my data is laid out (which columns hold what, which row the data starts on, the sheet name if it matters): {{layout}}
A few example rows, if I have them: {{examples:none provided}}
Give me:
1. The formula, ready to paste, in a code block.
2. The cell to put it in, and whether to drag it down or whether it fills by itself.
3. An explanation of each part from the inside out, in plain words.
4. What it returns for my example rows, or for a small example you make up if I gave none.
5. What will break it: blank cells, text stored as numbers, extra spaces, merged cells, dates stored as text. Give the fix for each one that applies to my case.
6. A simpler or more robust alternative, if there is one. For example, a lookup that does not break when a column is inserted.
Rules:
- Use functions that exist in the program I named. If the best function is only in newer versions, say so and give a fallback.
- Use my real column letters and sheet names, not placeholders.
- Assume my regional settings use {{separator:commas}} to separate arguments.
- If my description could mean two different things, show both formulas and explain the difference.
- If this would be better done with a pivot table, a filter, or a helper column than with one giant formula, tell me.