Tested prompt · Data analysis
A median, filtered two ways: every AI model's reply, tested
We sent this hard data analysis prompt to all 20 models in llmwise, the same way the app sends a message, and checked every reply the same way. Here's each one as it came, with whether it passed, what it cost and how long it took.
Based on 20 of our test runs on , through OpenRouter with the app's own prompt and settings. Updated .
Short answer
All 20 models passed this data analysis prompt's check (final answer). The cheapest reply that passed was GPT-6 Luna's, at $0.00012; the fastest, DeepSeek V4.1 Flash's in 0.6 s. The dearest reply, Claude Fable 5.1's, cost 131 times as much ($0.0151).
The prompt, as sent, and its check
Checked by final answer, the same way for every model.
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.
The final answer must be 6.25.
Exactly what this prompt's replies are checked against, with every other prompt of our test runs.
Every model's result
All 20 models on this prompt, in catalog order.
| Model | Result | Cost | Time | Reply |
|---|---|---|---|---|
| Claude Fable 5.1Anthropic | Passed: Final answer 6.25: right. | $0.0151 | 6.7 s | 132 tokens |
| Claude Opus 5.5Anthropic | Passed: Final answer 6.25: right. | $0.0079 | 4.6 s | 142 tokens |
| Claude Sonnet 5.5Anthropic | Passed: Final answer 6.25 hours: right. | $0.0030 | 1.5 s | 127 tokens |
| Claude Sonnet 5Anthropic | Passed: Final answer 6.25 hours: right. | $0.0036 | 4.9 s | 123 tokens |
| Claude Haiku 5.5Anthropic | Passed: Final answer 6.25: right. | $0.00021 | 2.6 s | 126 tokens |
| Claude Haiku 4.5Anthropic | Passed: Final answer 6.25: right. | $0.0016 | 2.0 s | 216 tokens |
| GPT-6 AstraOpenAI | Passed: Final answer 6.25 hours: right. | $0.0090 | 2.0 s | 77 tokens |
| GPT-6.1 SolOpenAI | Passed: Final answer 6.25 hours: right. | $0.0010 | 1.9 s | 100 tokens |
| GPT-6 SolOpenAI | Passed: Final answer 6.25 hours: right. | $0.0024 | 2.5 s | 94 tokens |
| GPT-6 LunaOpenAI | Passed: Final answer 6.25 hours: right. | $0.00012 | 2.5 s | 75 tokens |
| Gemini 4 ArgonGoogle | Passed: Final answer 6.25: right. | $0.0017 | 6.9 s | 180 tokens |
| Gemini 3.1 Pro (preview)Google | Passed: Final answer 6.25: right. | $0.0082 | 7.1 s | 185 tokens |
| Gemini 3.8 FlashGoogle | Passed: Final answer 6.25: right. | $0.0010 | 3.5 s | 169 tokens |
| DeepSeek V4.1 FlashDeepSeek | Passed: Final answer 6.25: right. | $0.00031 | 0.6 s | 103 tokens |
| DeepSeek V4 ProDeepSeek | Passed: Final answer 6.25: right. | $0.0011 | 1.2 s | 79 tokens |
| Grok 4.7xAI | Passed: Final answer 6.25: right. | $0.0037 | 4.4 s | 92 tokens |
| Kimi K3Moonshot | Passed: Final answer 6.25: right. | $0.0042 | 3.5 s | 83 tokens |
| GLM 5.3Z.ai | Passed: Final answer 6.25: right. | $0.0011 | 1.0 s | 92 tokens |
| GLM 5.3 FlashZ.ai | Passed: Final answer 6.25: right. | $0.00012 | 3.7 s | 89 tokens |
| Mistral Large 4Mistral | Passed: Final answer 6.25: right. | $0.0011 | 3.9 s | 197 tokens |
Cost: what OpenRouter charged us for the reply. Time: from sending to the whole reply. Reply: its length in tokens, thinking not counted. In llmwise you pay per message, not per token: each of these replies counted as one message on Pro.
Every reply
Every reply passed: here they are from the cheapest up.
GPT-6 Luna
Passed: Final answer 6.25 hours: right.
Billing high-priority resolution times, 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 hours. Final answer: 6.25 hours
512 tokens in, 128 out (53 of them reasoning) · 2.5 s · $0.0001 · 1 message on Pro · answered by openai/gpt-6-luna via OpenAI ·
GLM 5.3 Flash
Passed: Final answer 6.25: 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 median = (5.5 + 7)/2 = 6.25 Final answer: 6.25
526 tokens in, 142 out (53 of them reasoning) · 3.7 s · $0.0001 · 1 message on Pro · answered by z-ai/glm-5.3-flash via AtlasCloud ·
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 ·
DeepSeek V4.1 Flash
Passed: Final answer 6.25: right.
Billing + high tickets: T1=5.5, T4=2, T6=9, T9=7, T10=26, T12=4 → 6 values. Sorted: 2, 4, 5.5, 7, 9, 26 Even count, so median = average of the two middle values: (5.5 + 7) / 2 = 6.25 Final answer: 6.25
554 tokens in, 182 out (79 of them reasoning) · 0.6 s · $0.0003 · 1 message on Pro · answered by deepseek/deepseek-v4.1-flash via Together ·
GPT-6.1 Sol
Passed: Final answer 6.25 hours: right.
High-priority Billing tickets have resolution times: 5.5, 2, 9, 7, 26, and 4 hours. Sorted: 2, 4, 5.5, 7, 9, 26. With 6 values, the median is the average of the two middle values: (5.5 + 7) ÷ 2 = 6.25 hours. Final answer: 6.25 hours
514 tokens in, 100 out · 1.9 s · $0.0010 · 1 message on Pro · answered by openai/gpt-6.1-sol via OpenAI ·
Gemini 3.8 Flash
Passed: Final answer 6.25: right.
1. Filter for tickets where `team` is "Billing" and `priority` is "high": - T1: 5.5 - T4: 2 - T6: 9 - T9: 7 - T10: 26 - T12: 4 2. Sort the values in ascending order: - 2, 4, 5.5, 7, 9, 26 3. Calculate the median of the 6 values (average of the 3rd and 4th values): - (5.5 + 7) / 2 = 12.5 / 2 = 6.25 Final answer: 6.25
551 tokens in, 169 out · 3.5 s · $0.0010 · 1 message on Pro · answered by google/gemini-3.8-flash via Google ·
DeepSeek V4 Pro
Passed: Final answer 6.25: right.
Filtering to Billing team + high priority: 5.5, 2, 9, 7, 26, 4 Sorted: 2, 4, 5.5, 7, 9, 26 Median = (5.5 + 7) / 2 = 6.25 Final answer: 6.25
526 tokens in, 210 out (131 of them reasoning) · 1.2 s · $0.0011 · 1 message on Pro · answered by deepseek/deepseek-v4-pro-0813 via Wafer ·
GLM 5.3
Passed: Final answer 6.25: right.
Billing high-priority tickets: 5.5, 2, 9, 7, 26, 4 (six values). Sorted: 2, 4, 5.5, 7, 9, 26. With an even count, the median is the average of the two middle values: (5.5 + 7) / 2 = 6.25. Final answer: 6.25
549 tokens in, 149 out (57 of them reasoning) · 1.0 s · $0.0011 · 1 message on Pro · answered by z-ai/glm-5.3 via Wafer ·
Mistral Large 4
Passed: Final answer 6.25: right.
Filtering to Billing team + high priority: 5.5, 2, 9, 7, 26, 4. Sorted: 2, 4, 5.5, 7, 9, 26. Six values, so median = average of 3rd and 4th = (5.5 + 7) / 2 = 6.25. Final answer: 6.25
518 tokens in, 377 out (180 of them reasoning) · 3.9 s · $0.0011 · 1 message on Pro · answered by mistralai/mistral-large-4-0 via Mistral ·
Claude Haiku 4.5
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 ·
Gemini 4 Argon
Passed: Final answer 6.25: right.
1. **Filter for `team = Billing` and `priority = high`:** - T1: 5.5 - T4: 2 - T6: 9 - T9: 7 - T10: 26 - T12: 4 2. **Sort the `hours_to_resolve` values in ascending order:** 2, 4, 5.5, 7, 9, 26 3. **Find the median:** Since there are 6 values (an even number), the median is the average of the two middle values (3rd and 4th): (5.5 + 7) / 2 = 6.25 Final answer: 6.25
770 tokens in, 180 out · 6.9 s · $0.0017 · 1 message on Pro · answered by google/gemini-4-argon via Google AI Studio ·
GPT-6 Sol
Passed: Final answer 6.25 hours: right.
The high-priority Billing tickets took 5.5, 2, 9, 7, 26, and 4 hours. Sorted: 2, 4, 5.5, 7, 9, 26. The median is the average of the middle two values: (5.5 + 7) ÷ 2 = 6.25. Final answer: 6.25 hours
512 tokens in, 137 out (43 of them reasoning) · 2.5 s · $0.0024 · 1 message on Pro · answered by openai/gpt-6-sol via OpenAI ·
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 Sonnet 5
Passed: Final answer 6.25 hours: right.
Billing + high-priority tickets: T1=5.5, T4=2, T6=9, T9=7, T10=26, T12=4 Sorted: 2, 4, 5.5, 7, 9, 26 (6 values) Median = average of 3rd and 4th values = (5.5 + 7) / 2 = 6.25 Final answer: 6.25 hours
689 tokens in, 223 out (100 of them reasoning) · 4.9 s · $0.0036 · 1 message on Pro · answered by anthropic/claude-sonnet-5 via Claude Platform on AWS ·
Grok 4.7
Passed: Final answer 6.25: right.
Billing + high tickets: 5.5, 2, 9, 7, 26, 4. Sorted: 2, 4, 5.5, 7, 9, 26. Even count (6), so median is the average of the 3rd and 4th values: (5.5 + 7) / 2 = 6.25. Final answer: 6.25
1,750 tokens in, 381 out (289 of them reasoning) · 4.4 s · $0.0037 · 1 message on Pro · answered by x-ai/grok-4.7 via xAI ·
Kimi K3
Passed: Final answer 6.25: right.
Billing + high tickets: 5.5, 2, 9, 7, 26, 4 Sorted: 2, 4, 5.5, 7, 9, 26 Median = (5.5 + 7) / 2 = 6.25 Final answer: 6.25
597 tokens in, 265 out (182 of them reasoning) · 3.5 s · $0.0042 · 1 message on Pro · answered by moonshotai/kimi-k3 via Phala ·
Claude Opus 5.5
Passed: Final answer 6.25: right.
**Billing + high-priority tickets:** - T1: 5.5 - T4: 2 - T6: 9 - T9: 7 - T10: 26 - T12: 4 **Sorted:** 2, 4, 5.5, 7, 9, 26 There are 6 values, so the median is the average of the 3rd and 4th values: (5.5 + 7) / 2 = **6.25** Final answer: 6.25
691 tokens in, 225 out (83 of them reasoning) · 4.6 s · $0.0079 · 1 message on Pro · answered by anthropic/claude-opus-5.5 via Claude Platform on AWS ·
Gemini 3.1 Pro
Passed: Final answer 6.25: right.
To find the median `hours_to_resolve` for high-priority tickets handled by the Billing team, we first filter the data for those specific tickets: * T1: 5.5 * T4: 2 * T6: 9 * T9: 7 * T10: 26 * T12: 4 Next, we sort these values in ascending order: 2, 4, 5.5, 7, 9, 26 Since there are 6 values (an even number), the median is the average of the two middle numbers (the 3rd and 4th values): (5.5 + 7) / 2 = 12.5 / 2 = 6.25 Final answer: 6.25
551 tokens in, 590 out (405 of them reasoning) · 7.1 s · $0.0082 · 1 message on Pro · answered by google/gemini-3.1-pro-preview via Google ·
GPT-6 Astra
Passed: Final answer 6.25 hours: right.
High-priority Billing resolution times, sorted: 2, 4, 5.5, 7, 9, 26 hours. With 6 tickets, the median is the average of the two middle values: (5.5 + 7) ÷ 2 = 6.25 hours. Final answer: 6.25 hours
512 tokens in, 77 out · 2.0 s · $0.0090 · 1 message on Pro · answered by openai/gpt-6-astra via OpenAI ·
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 ·
More data analysis prompts
The other data analysis prompts, each with every model's reply.
Questions
Which AI does best on “A median, filtered two ways”?
All 20 models passed this data analysis prompt's check (final answer). The cheapest reply that passed was GPT-6 Luna's, at $0.00012; the fastest, DeepSeek V4.1 Flash's in 0.6 s. The dearest reply, Claude Fable 5.1's, cost 131 times as much ($0.0151).
What does a reply to “A median, filtered two ways” cost?
Through the models' APIs, what OpenRouter charged us ran from $0.00012 (GPT-6 Luna) to $0.0151 (Claude Fable 5.1) for this prompt. In llmwise you don't pay by the token: a reply like these counts as one message on Pro, whichever model answers.
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.