Claude vs Gemini for data analysis

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.

Data analysis: Claude Haiku 5.5 passed 5 of 5 and Gemini 3.1 Pro (preview) 5 of 5. Claude Haiku 5.5 answered 2.6× sooner at the median, 3.3 s against 8.6 s. Claude Haiku 5.5 cost 43.1× less, $0.0018 against $0.0773 for the 5 replies. Gemini 3.1 Pro (preview)'s replies ran 73% longer, in tokens of reply, thinking not counted.

1. 1. The region with the most revenue

   Everyday. Claude: 6 of 6 models passed, Claude Haiku 5.5 the cheapest at $0.0003 · Gemini: 3 of 3 models passed, Gemini 4 Argon the cheapest at $0.0021. The prompt in full.

   Claude Haiku 5.5 and Gemini 3.1 Pro both passed this one. Claude Haiku 5.5 answered sooner (3.4 s to 8.5 s), and Claude Haiku 5.5's reply cost less ($0.0003 to $0.0117); Claude Haiku 5.5 wrote 105 tokens of reply, Gemini 3.1 Pro 255.

   • Claude Haiku 5.5

     Passed: Final answer North, 1085: right.

     Revenue = quantity × price, summed by region:
     
     - **West:** 90 + 310 + 240 + 225 = **865**
     - **East:** 120 + 135 + 310 + 360 = **925**
     - **North:** 180 + 240 + 620 + 45 = **1085**
     
     Final answer: North, 1085

     816 tokens in, 336 out (231 of them reasoning) · 3.4 s · $0.0003 · 1 message on Pro · answered by anthropic/claude-haiku-5.5 via Anthropic · October 7, 2026

   • Gemini 3.1 Pro

     Passed: Final answer North, 1085: right.

     Here is the revenue calculation for each region (quantity × price):
     
     *   **West**: 
         *   2 × $45 = $90
         *   1 × $310 = $310
         *   2 × $120 = $240
         *   5 × $45 = $225
         *   *Total* = $865
     *   **East**: 
         *   1 × $120 = $120
         *   3 × $45 = $135
         *   1 × $310 = $310
         *   3 × $120 = $360
         *   *Total* = $925
     *   **North**: 
         *   4 × $45 = $180
         *   2 × $120 = $240
         *   2 × $310 = $620
         *   1 × $45 = $45
         *   *Total* = $1085
     
     Final answer: North, $1085

     770 tokens in, 849 out (594 of them reasoning) · 8.5 s · $0.0117 · 1 message on Pro · answered by google/gemini-3.1-pro-preview via Google · September 27, 2026

2. 2. Average order value in August

   Everyday. Claude: 5 of 6 models passed, Claude Haiku 5.5 the cheapest at $0.0002 · Gemini: 3 of 3 models passed, Gemini 3.8 Flash the cheapest at $0.0016. The prompt in full.

   Claude Haiku 5.5 and Gemini 3.1 Pro both passed this one. Claude Haiku 5.5 answered sooner (1.3 s to 8.6 s), and Claude Haiku 5.5's reply cost less ($0.0002 to $0.0130); Claude Haiku 5.5 wrote 208 tokens of reply, Gemini 3.1 Pro 273.

   • Claude Haiku 5.5

     Passed: Final answer 300.00: right.

     August orders (1007–1012):
     
     - 1007: 2 × 120.00 = 240.00
     - 1008: 1 × 310.00 = 310.00
     - 1009: 2 × 310.00 = 620.00
     - 1010: 5 × 45.00 = 225.00
     - 1011: 3 × 120.00 = 360.00
     - 1012: 1 × 45.00 = 45.00
     
     Total revenue: 240 + 310 + 620 + 225 + 360 + 45 = 1,800.00
     
     Number of orders: 6
     
     Average: 1,800.00 / 6 = 300.00
     
     Final answer: 300.00

     824 tokens in, 208 out · 1.3 s · $0.0002 · 1 message on Pro · answered by anthropic/claude-haiku-5.5 via Anthropic · October 7, 2026

   • Gemini 3.1 Pro

     Passed: Final answer 300.00: right.

     Here are the orders for August 2026 and their calculated revenue (quantity × price):
     
     *   Order 1007: 2 × $120.00 = $240.00
     *   Order 1008: 1 × $310.00 = $310.00
     *   Order 1009: 2 × $310.00 = $620.00
     *   Order 1010: 5 × $45.00 = $225.00
     *   Order 1011: 3 × $120.00 = $360.00
     *   Order 1012: 1 × $45.00 = $45.00
     
     Total revenue for August = $240 + $310 + $620 + $225 + $360 + $45 = $1800.00
     Number of orders in August = 6
     Average revenue per order = $1800.00 / 6 = $300.00
     
     Final answer: 300.00

     779 tokens in, 955 out (682 of them reasoning) · 8.6 s · $0.0130 · 1 message on Pro · answered by google/gemini-3.1-pro-preview via Google · September 27, 2026

3. 3. Revenue change from July to August

   Everyday. Claude: 6 of 6 models passed, Claude Haiku 5.5 the cheapest at $0.0004 · Gemini: 3 of 3 models passed, Gemini 4 Argon the cheapest at $0.0036. The prompt in full.

   Claude Haiku 5.5 and Gemini 3.1 Pro both passed this one. Claude Haiku 5.5 answered sooner (3.3 s to 9.0 s), and Claude Haiku 5.5's reply cost less ($0.0004 to $0.0135); Claude Haiku 5.5 wrote 298 tokens of reply, Gemini 3.1 Pro 356.

   • Claude Haiku 5.5

     Passed: Final answer 67.4%: right.

     **July 2026 revenue:**
     - 1001: 2 × 45 = 90
     - 1002: 1 × 120 = 120
     - 1003: 1 × 310 = 310
     - 1004: 4 × 45 = 180
     - 1005: 3 × 45 = 135
     - 1006: 2 × 120 = 240
     - Total: **1,075**
     
     **August 2026 revenue:**
     - 1007: 2 × 120 = 240
     - 1008: 1 × 310 = 310
     - 1009: 2 × 310 = 620
     - 1010: 5 × 45 = 225
     - 1011: 3 × 120 = 360
     - 1012: 1 × 45 = 45
     - Total: **1,800**
     
     **Change:** (1,800 − 1,075) / 1,075 = 725 / 1,075 ≈ 0.6744, or 67.4%.
     
     Final answer: 67.4%

     832 tokens in, 575 out (277 of them reasoning) · 3.3 s · $0.0004 · 1 message on Pro · answered by anthropic/claude-haiku-5.5 via Anthropic · October 7, 2026

   • Gemini 3.1 Pro

     Passed: Final answer 67.4%: right.

     **July 2026 Revenue:**
     * Order 1001: 2 x $45 = $90
     * Order 1002: 1 x $120 = $120
     * Order 1003: 1 x $310 = $310
     * Order 1004: 4 x $45 = $180
     * Order 1005: 3 x $45 = $135
     * Order 1006: 2 x $120 = $240
     * **July Total:** $1,075
     
     **August 2026 Revenue:**
     * Order 1007: 2 x $120 = $240
     * Order 1008: 1 x $310 = $310
     * Order 1009: 2 x $310 = $620
     * Order 1010: 5 x $45 = $225
     * Order 1011: 3 x $120 = $360
     * Order 1012: 1 x $45 = $45
     * **August Total:** $1,800
     
     **Percentage Change:**
     ((1800 - 1075) / 1075) * 100 = (725 / 1075) * 100 = 67.4418...%
     
     Final answer: 67.4%

     786 tokens in, 990 out (634 of them reasoning) · 9.0 s · $0.0135 · 1 message on Pro · answered by google/gemini-3.1-pro-preview via Google · September 27, 2026

4. 4. A median, filtered two ways

   Hard. Claude: 6 of 6 models passed, Claude Haiku 5.5 the cheapest at $0.0002 · Gemini: 3 of 3 models passed, Gemini 3.8 Flash the cheapest at $0.0010. The prompt in full.

   Claude Haiku 5.5 and Gemini 3.1 Pro both passed this one. Claude Haiku 5.5 answered sooner (2.6 s to 7.1 s), and Claude Haiku 5.5's reply cost less ($0.0002 to $0.0082); Claude Haiku 5.5 wrote 126 tokens of reply, Gemini 3.1 Pro 185.

   • 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 · October 7, 2026

   • 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 · September 27, 2026

5. 5. Correlation between ad spend and sign-ups

   Hard. Claude: 4 of 6 models passed, Claude Haiku 5.5 the cheapest at $0.0007 · Gemini: 2 of 3 models passed, Gemini 4 Argon the cheapest at $0.0041. The prompt in full.

   Claude Haiku 5.5 and Gemini 3.1 Pro both passed this one. Claude Haiku 5.5 answered sooner (5.7 s to 16.5 s), and Claude Haiku 5.5's reply cost less ($0.0007 to $0.0310); Claude Haiku 5.5 wrote 223 tokens of reply, Gemini 3.1 Pro 588.

   • Claude Haiku 5.5

     Passed: Final answer 0.97: right.

     **Working:**
     
     - n = 8
     - Mean ad_spend = 6150 / 8 = 768.75
     - Mean signups = 434 / 8 = 54.25
     - Sum of cross-deviations (Σ(x−x̄)(y−ȳ)) = 23,912.5
     - Sum of squared x-deviations (Σ(x−x̄)²) = 624,687.5
     - Sum of squared y-deviations (Σ(y−ȳ)²) = 971.5
     
     r = 23,912.5 / √(624,687.5 × 971.5) ≈ 23,912.5 / 24,635.9 ≈ 0.971
     
     Final answer: 0.97

     608 tokens in, 1,298 out (1,075 of them reasoning) · 5.7 s · $0.0007 · 1 message on Pro · answered by anthropic/claude-haiku-5.5 via Anthropic · October 7, 2026

   • Gemini 3.1 Pro

     Passed: Final answer 0.97: right.

     To calculate the Pearson correlation coefficient ($r$), we use the formula:
     $r = \frac{n(\sum xy) - (\sum x)(\sum y)}{\sqrt{[n\sum x^2 - (\sum x)^2][n\sum y^2 - (\sum y)^2]}}$
     
     Given the data for ad_spend ($x$) and signups ($y$):
     - $n = 8$
     - $\sum x = 500 + 800 + 650 + 1200 + 900 + 300 + 1100 + 700 = 6,150$
     - $\sum y = 42 + 55 + 49 + 71 + 60 + 35 + 64 + 58 = 434$
     - $\sum xy = (500 \times 42) + \dots + (700 \times 58) = 357,550$
     - $\sum x^2 = (500^2) + \dots + (700^2) = 5,352,500$
     - $\sum y^2 = (42^2) + \dots + (58^2) = 24,516$
     
     Plugging these into the formula:
     Numerator: $8(357,550) - (6,150)(434) = 2,860,400 - 2,669,100 = 191,300$
     Denominator $x$: $8(5,352,500) - (6,150)^2 = 42,820,000 - 37,822,500 = 4,997,500$
     Denominator $y$: $8(24,516) - (434)^2 = 196,128 - 188,356 = 7,772$
     
     $r = \frac{191,300}{\sqrt{4,997,500 \times 7,772}}$
     $r = \frac{191,300}{\sqrt{38,840,570,000}}$
     $r = \frac{191,300}{197,080.11} \approx 0.97067$
     
     Final answer: 0.97

     505 tokens in, 2,496 out (1,908 of them reasoning) · 16.5 s · $0.0310 · 1 message on Pro · answered by google/gemini-3.1-pro-preview via Google · September 27, 2026

• Claude Fable 5.1 vs Gemini 4 Argon: 5 of 5 each; Claude Fable 5.1 answered 1.4× sooner at the median and Gemini 4 Argon cost 10.0× less.

• Claude Fable 5.1 vs Gemini 3.1 Pro: 5 of 5 each; Claude Fable 5.1 answered 1.8× sooner at the median and Gemini 3.1 Pro cost 1.8× less.

• Claude Fable 5.1 vs Gemini 3.8 Flash: Claude Fable 5.1 5 of 5, Gemini 3.8 Flash 4; Claude Fable 5.1 answered 1.1× sooner at the median and Gemini 3.8 Flash cost 10.2× less.

• Claude Opus 5.5 vs Gemini 4 Argon: 5 of 5 each; Claude Opus 5.5 answered 1.5× sooner at the median and Gemini 4 Argon cost 4.6× less. Gemini 4 Argon vs Claude Opus 5.5, on every job.

• Claude Opus 5.5 vs Gemini 3.1 Pro: 5 of 5 each; Claude Opus 5.5 answered 1.9× sooner at the median and cost 1.2× less. Claude Opus 5.5 vs Gemini 3.1 Pro (preview), on every job.

• Claude Opus 5.5 vs Gemini 3.8 Flash: Claude Opus 5.5 5 of 5, Gemini 3.8 Flash 4; Claude Opus 5.5 answered 1.2× sooner at the median and Gemini 3.8 Flash cost 4.7× less.

• Claude Sonnet 5.5 vs Gemini 4 Argon: 5 of 5 each; Claude Sonnet 5.5 answered 3.0× sooner at the median and Gemini 4 Argon cost 1.7× less.

• Claude Sonnet 5.5 vs Gemini 3.1 Pro: 5 of 5 each; Claude Sonnet 5.5 answered 3.8× sooner at the median and cost 3.3× less. Claude Sonnet 5.5 vs Gemini 3.1 Pro (preview), on every job.

• Claude Sonnet 5.5 vs Gemini 3.8 Flash: Claude Sonnet 5.5 5 of 5, Gemini 3.8 Flash 4; Claude Sonnet 5.5 answered 2.4× sooner at the median and Gemini 3.8 Flash cost 1.7× less.

• Claude Sonnet 5 vs Gemini 4 Argon: Claude Sonnet 5 4 of 5, Gemini 4 Argon 5; Claude Sonnet 5 answered 1.3× sooner at the median and Gemini 4 Argon cost 2.4× less.

• Claude Sonnet 5 vs Gemini 3.1 Pro: Claude Sonnet 5 4 of 5, Gemini 3.1 Pro 5; Claude Sonnet 5 answered 1.6× sooner at the median and cost 2.2× less. Claude Sonnet 5 vs Gemini 3.1 Pro (preview), on every job.

• Claude Sonnet 5 vs Gemini 3.8 Flash: 4 of 5 each; they took about as long and Gemini 3.8 Flash cost 2.5× less. Claude Sonnet 5 vs Gemini 3.8 Flash, on every job.

• Claude Haiku 4.5 vs Gemini 4 Argon: Claude Haiku 4.5 3 of 5, Gemini 4 Argon 5; Claude Haiku 4.5 answered 2.5× sooner at the median and cost 1.1× less.

• Claude Haiku 4.5 vs Gemini 3.1 Pro: Claude Haiku 4.5 3 of 5, Gemini 3.1 Pro 5; Claude Haiku 4.5 answered 3.2× sooner at the median and cost 6.2× less. Claude Haiku 4.5 vs Gemini 3.1 Pro (preview), on every job.

• Claude Haiku 4.5 vs Gemini 3.8 Flash: Claude Haiku 4.5 3 of 5, Gemini 3.8 Flash 4; Claude Haiku 4.5 answered 2.0× sooner at the median and cost 1.1× less. Claude Haiku 4.5 vs Gemini 3.8 Flash, on every job.

• Claude Haiku 5.5 vs Gemini 4 Argon: 5 of 5 each; Claude Haiku 5.5 answered 2.1× sooner at the median and cost 7.9× less.

• Claude Haiku 5.5 vs Gemini 3.1 Pro: 5 of 5 each; Claude Haiku 5.5 answered 2.6× sooner at the median and cost 43.1× less.

• Claude Haiku 5.5 vs Gemini 3.8 Flash: Claude Haiku 5.5 5 of 5, Gemini 3.8 Flash 4; Claude Haiku 5.5 answered 1.6× sooner at the median and cost 7.7× less.

Every Claude and Gemini reply above was checked the same way as every other model's, by the rules published with the prompts: how the data analysis prompts are scored, and each one in full.

• The lineups

  Claude: 6 models, Claude Fable 5.1, Claude Opus 5.5, Claude Sonnet 5.5, Claude Sonnet 5, Claude Haiku 4.5, and Claude Haiku 5.5. Gemini: 3 models, Gemini 4 Argon, Gemini 3.1 Pro (preview), and Gemini 3.8 Flash.

• Price per message

  The least expensive Claude model is Claude Haiku 5.5 (60 messages a day on Pro); the least expensive Gemini model is Gemini 3.8 Flash (250 messages a month on Pro).

• Context window

  Claude goes up to 1M tokens (Claude Fable 5.1); Gemini up to 1.05M tokens (Gemini 4 Argon).

• Images and PDFs

  Every model here reads images. Every model here takes a PDF as a whole file.

• On the Free plan

  Free's one-time trial of 5 messages covers Claude Haiku 5.5. Paid plans have them, with messages every month: Claude Fable 5.1 from Pro up.

In llmwise, a message to Claude or Gemini goes to the model's maker, or through OpenRouter when llmwise can't reach the maker directly. The Privacy Policy has the details.