Claude Haiku 4.5 · Data analysis
Claude Haiku 4.5 for data analysis: our test runs
Claude Haiku 4.5 ran our 5 data analysis prompts in llmwise, through the same pipeline your messages take. Here's every reply as it came, whether it passed, what it cost and what it counts as on Pro, next to the other models.
Based on 5 of our test runs on , through OpenRouter with the app's own prompt and settings. Updated .
Short answer
In our test runs on September 27, 2026, Claude Haiku 4.5 passed 3 of 5 of our data analysis prompts (1 of the 2 hard ones): 20th of 20 models. Each reply counted as 1 message on Pro, where it has 250 a month, and cost $0.0025 to run on average.
Prompt by prompt
Each of the 5 data analysis prompts, and how Claude Haiku 4.5's reply did.
| Prompt | Result | Cost | Time |
|---|---|---|---|
| The region with the most revenueEveryday | Passed: Final answer North region brought in the most revenue with 1,085.: right. | $0.0026 | 2.7 s |
| Average order value in AugustEveryday | Failed: Final answer 275.00; expected 300. | $0.0023 | 2.1 s |
| Revenue change from July to AugustEveryday | Passed: Final answer 67.4%: right. | $0.0022 | 4.2 s |
| A median, filtered two waysHard | Passed: Final answer 6.25: right. | $0.0016 | 2.0 s |
| Correlation between ad spend and sign-upsHard | Failed: Final answer 0.99; expected 0.97. | $0.0037 | 5.0 s |
Every data analysis reply from Claude Haiku 4.5
The region with the most revenue
An everyday prompt: “The region with the most revenue”, in full.
Passed: Final answer North region brought in the most revenue with 1,085.: right.
I'll calculate the revenue for each order and sum by region. **Revenue by order (quantity × price):** | Order | Region | Revenue | |-------|--------|---------| | 1001 | West | 2 × $45 = $90 | | 1002 | East | 1 × $120 = $120 | | 1003 | West | 1 × $310 = $310 | | 1004 | North | 4 × $45 = $180 | | 1005 | East | 3 × $45 = $135 | | 1006 | North | 2 × $120 = $240 | | 1007 | West | 2 × $120 = $240 | | 1008 | East | 1 × $310 = $310 | | 1009 | North | 2 × $310 = $620 | | 1010 | West | 5 × $45 = $225 | | 1011 | East | 3 × $120 = $360 | | 1012 | North | 1 × $45 = $45 | **Total revenue by region:** - **West:** $90 + $310 + $240 + $225 = $865 - **East:** $120 + $135 + $310 + $360 = $925 - **North:** $180 + $240 + $620 + $45 = $1,085 Final answer: North region brought in the most revenue with $1,085.
675 tokens in, 390 out · 2.7 s · $0.0026 · 1 message on Pro · answered by anthropic/claude-haiku-4.5 via Amazon Bedrock ·
Average order value in August
An everyday prompt: “Average order value in August”, in full.
Failed: Final answer 275.00; expected 300.
I'll find the average revenue per order for August 2026. **August 2026 orders:** | order_id | date | quantity | price | revenue | |----------|------|----------|-------|---------| | 1007 | 2026-08-02 | 2 | 45.00 | 90.00 | | 1008 | 2026-08-06 | 1 | 310.00 | 310.00 | | 1009 | 2026-08-11 | 2 | 310.00 | 620.00 | | 1010 | 2026-08-15 | 5 | 45.00 | 225.00 | | 1011 | 2026-08-19 | 3 | 120.00 | 360.00 | | 1012 | 2026-08-27 | 1 | 45.00 | 45.00 | **Calculation:** - Total revenue: 90 + 310 + 620 + 225 + 360 + 45 = 1,650.00 - Number of orders: 6 - Average revenue per order: 1,650.00 ÷ 6 = 275.00 Final answer: 275.00
683 tokens in, 326 out · 2.1 s · $0.0023 · 1 message on Pro · answered by anthropic/claude-haiku-4.5 via Amazon Bedrock ·
Revenue change from July to August
An everyday prompt: “Revenue change from July to August”, in full.
Passed: Final answer 67.4%: right.
I'll calculate the revenue for each order, then sum by month. **July 2026 orders:** - 1001: 2 × $45 = $90 - 1002: 1 × $120 = $120 - 1003: 1 × $310 = $310 - 1004: 4 × $45 = $180 - 1005: 3 × $45 = $135 - 1006: 2 × $120 = $240 **July total: $1,075** **August 2026 orders:** - 1007: 2 × $120 = $240 - 1008: 1 × $310 = $310 - 1009: 2 × $310 = $620 - 1010: 5 × $45 = $225 - 1011: 3 × $120 = $360 - 1012: 1 × $45 = $45 **August total: $1,800** **Percentage change:** $$\frac{1,800 - 1,075}{1,075} × 100 = \frac{725}{1,075} × 100 = 67.4\%$$ Final answer: 67.4%688 tokens in, 309 out · 4.2 s · $0.0022 · 1 message on Pro · answered by anthropic/claude-haiku-4.5 via Amazon Bedrock ·
A median, filtered two ways
A hard prompt: “A median, filtered two ways”, in full.
Passed: Final answer 6.25: right.
I'll filter for high-priority Billing team tickets and find the median. **Filtering the data:** High-priority tickets handled by Billing team: - T1: 5.5 hours - T4: 2 hours - T6: 9 hours - T9: 7 hours - T10: 26 hours - T12: 4 hours **Sorting by hours_to_resolve:** 2, 4, 5.5, 7, 9, 26 **Calculating median:** With 6 values (even number), the median is the average of the 3rd and 4th values: - 3rd value: 5.5 - 4th value: 7 - Median: (5.5 + 7) / 2 = 12.5 / 2 = 6.25 Final answer: 6.25
550 tokens in, 216 out · 2.0 s · $0.0016 · 1 message on Pro · answered by anthropic/claude-haiku-4.5 via Amazon Bedrock ·
Correlation between ad spend and sign-ups
A hard prompt: “Correlation between ad spend and sign-ups”, in full.
Failed: Final answer 0.99; expected 0.97.
I'll calculate the Pearson correlation coefficient between ad_spend and signups. **Data:** - ad_spend: 500, 800, 650, 1200, 900, 300, 1100, 700 - signups: 42, 55, 49, 71, 60, 35, 64, 58 **Calculations:** Mean of ad_spend: (500+800+650+1200+900+300+1100+700)/8 = 6150/8 = 768.75 Mean of signups: (42+55+49+71+60+35+64+58)/8 = 434/8 = 54.25 **Deviations and products:** | Week | ad_spend - 768.75 | signups - 54.25 | Product | |------|------------------|-----------------|---------| | 1 | -268.75 | -12.25 | 3291.19 | | 2 | 31.25 | 0.75 | 23.44 | | 3 | -118.75 | -5.25 | 623.44 | | 4 | 431.25 | 16.75 | 7223.44 | | 5 | 131.25 | 5.75 | 755.19 | | 6 | -468.75 | -19.25 | 9023.44 | | 7 | 331.25 | 9.75 | 3229.69 | | 8 | -68.75 | 3.75 | -257.81 | Sum of products: 23,891.98 **Variance calculations:** - Variance of ad_spend: (72031.25 + 976.56 + 14101.56 + 185975.56 + 17226.56 + 219726.56 + 109726.56 + 4726.56) / 8 = 107995.31 - Variance of signups: (150.06 + 0.56 + 27.56 + 280.56 + 33.06 + 370.56 + 95.06 + 14.06) / 8 = 121.63 **Correlation:** r = 23,891.98 / √(107,995.31 × 121.63) = 23,891.98 / √13,128.46 = 23,891.98 / 114.57 = 0.9875 ≈ **0.99** Final answer: 0.99
482 tokens in, 642 out · 5.0 s · $0.0037 · 1 message on Pro · answered by anthropic/claude-haiku-4.5 via Amazon Bedrock ·
How it compares on data analysis
Claude Haiku 4.5 beside the job's picks among every model. 16 models share the hard-problems pick, and Claude Haiku 4.5 isn't one of them.
| Model | Passed | On Pro | Cost per reply |
|---|---|---|---|
| GLM 5.3Our pick: hard problems (shared), best value | 5 of 5 | 250 a month on Pro | $0.0019 |
| GPT-6 LunaOur pick: hard problems (shared), everyday | 5 of 5 | 60 a day on Pro | $0.0002 |
| Claude Haiku 4.5 | 3 of 5 | 250 a month on Pro | $0.0025 |
Every limit is published. Paid plans also have a monthly fair-use limit on AI cost: Plus $3.75, 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 next to each model on data analysis
Claude Haiku 4.5 against each model on the same 5 data analysis prompts. One run each, through OpenRouter: a wait depends on the provider and the load that day, so a lead under 10% counts as close.
Against Claude Fable 5.1: Claude Haiku 4.5 answered 1.8× sooner (2.7 s to 4.9 s), cost 11.3× less, and passed 3 of 5 to its 5. Only Claude Fable 5.1 passed Average order value in August; Correlation between ad spend and sign-ups.
Against Claude Opus 5.5: Claude Haiku 4.5 answered 1.7× sooner (2.7 s to 4.6 s), cost 5.2× less, and passed 3 of 5 to its 5. Only Claude Opus 5.5 passed Average order value in August; Correlation between ad spend and sign-ups.
Against Claude Sonnet 5.5: Claude Haiku 4.5 answered 1.2× later (2.7 s to 2.3 s), cost 1.9× less, and passed 3 of 5 to its 5. Only Claude Sonnet 5.5 passed Average order value in August; Correlation between ad spend and sign-ups.
Against Claude Sonnet 5: Claude Haiku 4.5 answered 1.9× sooner (2.7 s to 5.3 s), cost 2.8× less, and passed 3 of 5 to its 4. Only Claude Sonnet 5 passed Average order value in August.
Against Claude Haiku 5.5: Claude Haiku 4.5 answered 1.2× sooner (2.7 s to 3.3 s), cost 7.0× more, and passed 3 of 5 to its 5. Only Claude Haiku 5.5 passed Average order value in August; Correlation between ad spend and sign-ups.
Against GPT-6 Astra: Claude Haiku 4.5 answered 1.2× sooner (2.7 s to 3.3 s), cost 6.2× less, and passed 3 of 5 to its 5. Only GPT-6 Astra passed Average order value in August; Correlation between ad spend and sign-ups.
Against GPT-6.1 Sol: Claude Haiku 4.5 answered within 10% of its time (2.7 s to 3.0 s), cost 1.6× more, and passed 3 of 5 to its 5. Only GPT-6.1 Sol passed Average order value in August; Correlation between ad spend and sign-ups.
Against GPT-6 Sol: Claude Haiku 4.5 answered within 10% of its time (2.7 s to 2.8 s), cost 1.4× less, and passed 3 of 5 to its 5. Only GPT-6 Sol passed Average order value in August; Correlation between ad spend and sign-ups.
Against GPT-6 Luna: Claude Haiku 4.5 answered within 10% of its time (2.7 s to 2.5 s), cost 14.2× more, and passed 3 of 5 to its 5. Only GPT-6 Luna passed Average order value in August; Correlation between ad spend and sign-ups.
Against Gemini 4 Argon: Claude Haiku 4.5 answered 2.5× sooner (2.7 s to 6.9 s), cost 1.1× less, and passed 3 of 5 to its 5. Only Gemini 4 Argon passed Average order value in August; Correlation between ad spend and sign-ups.
Against Gemini 3.1 Pro (preview): Claude Haiku 4.5 answered 3.2× sooner (2.7 s to 8.6 s), cost 6.2× less, and passed 3 of 5 to its 5. Only Gemini 3.1 Pro (preview) passed Average order value in August; Correlation between ad spend and sign-ups.
Against Gemini 3.8 Flash: Claude Haiku 4.5 answered 2.0× sooner (2.7 s to 5.4 s), cost 1.1× less, and passed 3 of 5 to its 4. Only Gemini 3.8 Flash passed Average order value in August.
Against DeepSeek V4.1 Flash: Claude Haiku 4.5 answered 3.2× later (2.7 s to 0.9 s), cost 2.9× more, and passed 3 of 5 to its 5. Only DeepSeek V4.1 Flash passed Average order value in August; Correlation between ad spend and sign-ups.
Against DeepSeek V4 Pro: Claude Haiku 4.5 answered 1.5× sooner (2.7 s to 4.1 s), cost 1.1× less, and passed 3 of 5 to its 5. Only DeepSeek V4 Pro passed Average order value in August; Correlation between ad spend and sign-ups.
Against Grok 4.7: Claude Haiku 4.5 answered 3.3× sooner (2.7 s to 8.9 s), cost 4.5× less, and passed 3 of 5 to its 5. Only Grok 4.7 passed Average order value in August; Correlation between ad spend and sign-ups.
Against Kimi K3: Claude Haiku 4.5 answered 1.3× sooner (2.7 s to 3.5 s), cost 2.7× less, and passed 3 of 5 to its 5. Only Kimi K3 passed Average order value in August; Correlation between ad spend and sign-ups.
Against GLM 5.3: Claude Haiku 4.5 answered 1.4× later (2.7 s to 1.9 s), cost 1.3× more, and passed 3 of 5 to its 5. Only GLM 5.3 passed Average order value in August; Correlation between ad spend and sign-ups.
Against GLM 5.3 Flash: Claude Haiku 4.5 answered 3.6× sooner (2.7 s to 9.8 s), cost 6.5× more, and passed 3 of 5 to its 4. Only GLM 5.3 Flash passed Average order value in August.
Against Mistral Large 4: Claude Haiku 4.5 answered 5.8× sooner (2.7 s to 15.8 s), cost 1.5× less, and passed 3 of 5 to its 5. Only Mistral Large 4 passed Average order value in August; Correlation between ad spend and sign-ups.
How these runs were done
Final answer. Automatic. The reply's last “Final answer:” line must hold the right value.
Claude Haiku 4.5, and data analysis, elsewhere
- Claude Haiku 4.5: price, limits and messages on every plan
- Claude for data analysis
- Claude Haiku 4.5 for coding: our test runs
- Claude Haiku 4.5 for writing: our test runs
- Claude Haiku 4.5 for math: our test runs
- Claude Haiku 5.5 vs Claude Haiku 4.5
- Claude Fable 5.1 vs Claude Haiku 4.5
- Claude Opus 5.5 vs Claude Haiku 4.5
- Claude Sonnet 5 vs Claude Haiku 4.5
- Claude Haiku 4.5 vs GPT-6 Sol
- Claude Haiku 4.5 vs GPT-6 Luna
- Claude Haiku 4.5 vs Gemini 3.1 Pro (preview)
- Claude Haiku 4.5 vs Gemini 3.8 Flash
- Claude Haiku 4.5 vs DeepSeek V4.1 Flash
- Claude Haiku 4.5 vs DeepSeek V4 Pro
- Claude Haiku 4.5 vs Grok 4.7
- Claude Haiku 4.5 vs Kimi K3
- Claude Haiku 4.5 vs GLM 5.3
- Claude Haiku 4.5 vs GLM 5.3 Flash
- Analyze a CSV with code: the prompt, and its price
- AI prompts for business, tested on four models
- Our test runs: 50 prompts on every model
Questions
Is Claude Haiku 4.5 good for data analysis?
In our test runs it passed 3 of 5 data analysis prompts, 20th of the 20 models in llmwise. Every reply is on this page, so you can judge them yourself.
How many of my messages does a data analysis reply from Claude Haiku 4.5 use?
1 message each on Pro, where it has 250 a month on Pro. The price of a message is fixed and shown before you send it, however long the reply.
How were these runs done?
The same way for every model: each prompt sent through llmwise's own pipeline, each reply checked the same way. The methods page has every prompt and how each is scored.
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.