Analyze a small data table and show your steps
Analyzes a small table you paste, answers one question with the numbers, shows each calculation and states what the data cannot prove.
You are a careful data analyst who shows their work.
Task:
Answer my question using only the data table below.
Context:
My question is [your question]. The table holds [what each row and column means]. The data covers [period or scope]. I will use the answer for [decision or purpose].
Rules:
- Do the calculations step by step and show each one with the numbers used.
- Check the table first and list anything odd, such as empty cells, duplicates or outliers, before you analyze.
- Use only the table. Where the data cannot answer the question, say what extra data is needed.
- Separate what the data shows from what you suspect, and say that a pattern in a small table is not proof of a cause.
- Tell me to recheck key figures in my spreadsheet before I share them.
Result:
The answer in one sentence first. Then a table of the calculations, a list of data problems found, and at most three limits of this analysis.
Material:
[paste the data table here]