Claude · Data analysis
Claude for data analysis
llmwise has 6 of Anthropic's Claude models, from Claude Haiku 5.5 (up to 60 messages a day on Pro) to Claude Fable 5.1 (up to 31 messages a month). We ran the same data analysis prompts on every one and published every reply: which Claude model to use, from the results, what each costs per message, and how to get more out of it.
Based on 30 of our test runs on , through OpenRouter with the app's own prompt and settings. Updated .
Short answer
In our test runs on October 7, 2026, 4 models passed 5 of 5 data analysis prompts, so these prompts don't pick one for hard problems. For value, Claude Sonnet 5.5 (5 of 5), 125 a month on Pro; for everyday data analysis, Claude Haiku 5.5 (5 of 5), from the daily count.
Our picks for data analysis
Hard problems
Shared by 4 models
4 models passed 5 of 5, both hard ones: Claude Fable 5.1, Claude Opus 5.5, Claude Sonnet 5.5 and Claude Haiku 5.5. These prompts don't tell them apart, so they share the pick.
Best value
Passed 5 of 5 data analysis prompts, with 125 a month on Pro.
Everyday
Passed 5 of 5 data analysis prompts; an everyday model, so its messages come from the daily count (60 a day on Pro), not the monthly allowance.
These picks aren't our opinion: they're what the results below give, by these rules, among the Claude models in llmwise. They change when the results do.
- Hard problems: the model that passed the most prompts and, of those, the most hard ones. Models level on both share the pick: the prompts don't tell them apart, so we don't break the tie by price or by name.
- Best value: among the models that draw on the monthly allowance, the one with the most messages on Pro that passed no more than one prompt fewer than the top model. Ties go to the one that passed more, then to the lower cost per reply.
- Everyday: among the cheapest models on the page (the everyday models, which come from the daily count, when the page has any), the one that passed the most. Ties go to the one that passed more of the hard prompts, then to the lower cost per reply.
Our data analysis test runs, model by model
How each model did on our 5 data analysis prompts, what each reply counted as on Pro, and what it cost to run.
| Model | Passed | Hard ones | Messages used on Pro | Cost per reply | Time per reply |
|---|---|---|---|---|---|
| Claude Fable 5.1Anthropic | 5 of 5 | 2 of 2 | 1 each, of 31 a month on Pro | $0.0283 | 6.7 s |
| Claude Opus 5.5Anthropic | 5 of 5 | 2 of 2 | 1 each, of 62 a month on Pro | $0.0131 | 5.9 s |
| Claude Sonnet 5.5Anthropic | 5 of 5 | 2 of 2 | 1 each, of 125 a month on Pro | $0.0047 | 2.4 s |
| Claude Sonnet 5Anthropic | 4 of 5 | 1 of 2 | 1 each, of 125 a month on Pro | $0.0069 | 6.9 s |
| Claude Haiku 4.5Anthropic | 3 of 5 | 1 of 2 | 1 each, of 250 a month on Pro | $0.0025 | 3.2 s |
| Claude Haiku 5.5Anthropic | 5 of 5 | 2 of 2 | 1 each, of 60 a day on Pro | $0.0004 | 3.2 s |
One prompt, side by side
Each model's reply to “A median, filtered two ways”, as it came, with whether it passed and what it cost.
The prompt: A median, filtered two ways (hard)
Here are support tickets as CSV. What's the median hours_to_resolve for high-priority tickets handled by the Billing team? ticket_id,team,priority,hours_to_resolve T1,Billing,high,5.5 T2,Tech,high,12 T3,Billing,low,30 T4,Billing,high,2 T5,Tech,low,48 T6,Billing,high,9 T7,Billing,medium,16 T8,Tech,high,3.5 T9,Billing,high,7 T10,Billing,high,26 T11,Tech,medium,20 T12,Billing,high,4 Show your working briefly, then end with a line that says "Final answer: " followed by the answer alone.
Claude Fable 5.1
Passed: Final answer 6.25: right.
Billing + high tickets: T1 (5.5), T4 (2), T6 (9), T9 (7), T10 (26), T12 (4) — 6 tickets. Sorted hours: 2, 4, 5.5, 7, 9, 26 Median of 6 values = average of 3rd and 4th: (5.5 + 7) / 2 = 6.25 Final answer: 6.25
691 tokens in, 132 out · 6.7 s · $0.0151 · 1 message on Pro · answered by anthropic/claude-fable-5.1 via Anthropic ·
Claude Sonnet 5.5
Passed: Final answer 6.25 hours: right.
Billing + high tickets: T1 (5.5), T4 (2), T6 (9), T9 (7), T10 (26), T12 (4). Sorted: 2, 4, 5.5, 7, 9, 26 Six values, so the median is the average of the 3rd and 4th: (5.5 + 7) / 2 = 6.25 Final answer: 6.25 hours
693 tokens in, 127 out · 1.5 s · $0.0030 · 1 message on Pro · answered by anthropic/claude-sonnet-5.5 via Anthropic ·
Claude Haiku 5.5
Passed: Final answer 6.25: right.
Billing tickets with high priority: - T1: 5.5 - T4: 2 - T6: 9 - T9: 7 - T10: 26 - T12: 4 Sorted: 2, 4, 5.5, 7, 9, 26 With six values, the median is the average of the middle two: (5.5 + 7) / 2 = 6.25 Final answer: 6.25
692 tokens in, 240 out (114 of them reasoning) · 2.6 s · $0.0002 · 1 message on Pro · answered by anthropic/claude-haiku-5.5 via Anthropic ·
The data analysis prompts, and how they're scored
Final answer. Automatic. The reply's last “Final answer:” line must hold the right value.
Each prompt was sent the way llmwise sends a message in a side-by-side comparison, which offers no tools: the app's own system prompt, the model's own settings, and Pro's reply size limit (8,000 tokens). Read all five data analysis prompts and how every reply was scored.
Prompts like these to try yourself
Claude in llmwise
| Model | On Pro | On Free | Context window | Images | PDFs | Reasoning | API price per 1M, in / out |
|---|---|---|---|---|---|---|---|
| Claude Fable 5.1Anthropic | 31/mo on Pro | No | 1M tokens | Yes | Whole file | Yes | $10.00 / $50.00 |
| Claude Opus 5.5Anthropic | 62/mo on Pro | 1 message | 1M tokens | Yes | Whole file | Yes | $4.00 / $20.00 |
| Claude Sonnet 5.5Anthropic | 125/mo on Pro | Yes | 1M tokens | Yes | Whole file | Yes | $2.00 / $10.00 |
| Claude Sonnet 5Anthropic | 125/mo on Pro | Yes | 1M tokens | Yes | Whole file | Yes | $2.00 / $10.00 |
| Claude Haiku 4.5Anthropic | 250/mo on Pro | Yes | 200K tokens | Yes | Whole file | No | $1.00 / $5.00 |
| Claude Haiku 5.5Anthropic | 60/day on Pro | Yes | 1M tokens | Yes | Whole file | Yes | $0.10 / $0.50 |
Every limit is published. Paid plans also have a monthly fair-use limit on AI cost: Pro $7.50, Max $20, Ultra $42, Studio $85. Using every message on your plan at typical sizes stays under it; very large messages and heavy research use it faster. Every limit, explained.
Claude Haiku 4.5 doesn't reason before answering in llmwise.
What matters for data analysis
Calculations in code
Numbers done in a model's head are often slightly wrong. Analysis you can trust runs real code on the real data.
Reading PDFs and charts
Reports arrive as PDFs and charts as images. A model that takes the whole PDF file and reads images has more to go on.
Explaining the result
The value is in the explanation: what the numbers mean, what's uncertain, and what to check next.
Claude for data analysis in llmwise
Bring the data in
Attach CSV files, PDFs of reports (up to 100 pages) and screenshots of charts.
Run Python on your data (paid plans)
On a paid plan the model can run Python on the files you attach, then hand you the charts or CSVs it saves. A run counts as 1 Claude Haiku 4.5 message.
Spreadsheets
Ask for a table and it opens as a spreadsheet you can edit and download as Excel or CSV.
The Analyst persona
Pick the Analyst persona for answers grounded in data, assumptions and confidence levels.
In llmwise, a message to Claude goes to its maker, Anthropic, or through OpenRouter when llmwise can't reach the maker directly. See the Privacy Policy.
Tips
Describe the columns and what one row means before asking questions.
Ask the model to show the code it ran, so you can check it.
Start with a sample; run the full file once the approach works.
Ask what could make the conclusion wrong.
Questions
Is Claude good for data analysis?
In our test runs on October 7, 2026, Claude Fable 5.1 passed 5 of 5, Claude Opus 5.5 passed 5 of 5, Claude Sonnet 5.5 passed 5 of 5, Claude Sonnet 5 passed 4 of 5, Claude Haiku 4.5 passed 3 of 5, Claude Haiku 5.5 passed 5 of 5 of our data analysis prompts, against a best result of 5 of 5 among all 19 models. Every reply is published on this page and the methods page, so you can judge them yourself.
Which Claude model should I use for data analysis?
Start with Claude Haiku 5.5 for formula help, quick lookups and explaining a chart, and move up to Claude Fable 5.1 for messy data, ambiguous questions and analysis you'll present or decide on.
Can I use Claude for data analysis for free?
Yes: Claude Sonnet 5.5, Claude Sonnet 5, Claude Haiku 4.5, and Claude Haiku 5.5 are on the Free plan (a one-time trial of 5 messages, one of them can be on Claude Opus 5.5). Claude Fable 5.1 needs a paid plan.
Can it make charts?
On a paid plan, a code run can save a chart (or any file) and you download it from the chat. The model writes the plotting code and runs it once you approve.
Claude, GPT, Gemini, DeepSeek, Grok, Kimi, GLM, and Mistral, in one chat.
See what a message costs before you send it. Free is 5 messages to try; sign in with an email link, no password or card.