Skip to content

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.

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): 15th of 15 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.

Claude Haiku 4.5 on each data analysis prompt
PromptResultCostTime
The region with the most revenueEverydayPassed: Final answer North region brought in the most revenue with 1,085.: right.$0.00262.7 s
Average order value in AugustEverydayFailed: Final answer 275.00; expected 300.$0.00232.1 s
Revenue change from July to AugustEverydayPassed: Final answer 67.4%: right.$0.00224.2 s
A median, filtered two waysHardPassed: Final answer 6.25: right.$0.00162.0 s
Correlation between ad spend and sign-upsHardFailed: Final answer 0.99; expected 0.97.$0.00375.0 s

Every data analysis reply from Claude Haiku 4.5

  1. 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 ·

  2. 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 ·

  3. 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 ·

  4. 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 ·

  5. 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. 11 models share the hard-problems pick, and Claude Haiku 4.5 isn't one of them.

Claude Haiku 4.5 beside other models on data analysis
ModelPassedOn ProCost per reply
DeepSeek V4 ProOur pick: hard problems (shared), best value5 of 5250 a month on Pro$0.0016
GPT-6 LunaOur pick: hard problems (shared), everyday5 of 560 a day on Pro$0.0002
Claude Haiku 4.53 of 5250 a month on Pro$0.0025
On Pro: Pro's count on each model. Cost: what OpenRouter charged us per reply, on average.

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.

How these runs were done

Final answer. Automatic. The reply's last “Final answer:” line must hold the right value.

How the runs were done, and every data analysis prompt.

Claude Haiku 4.5, and data analysis, elsewhere

Questions

Is Claude Haiku 4.5 good for data analysis?

In our test runs it passed 3 of 5 data analysis prompts, 15th of the 15 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, and GLM, 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.