Skip to content

Gemini 4 Carbon · Data analysis

Gemini 4 Carbon for data analysis: our test runs

Gemini 4 Carbon 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 November 17, 2026, Gemini 4 Carbon passed 5 of 5 of our data analysis prompts (both hard ones): tied 1st of 27 models. Each reply counted as 1 message on Pro, where it has 62 a month, and cost $0.0086 to run on average.

Prompt by prompt

Each of the 5 data analysis prompts, and how Gemini 4 Carbon's reply did.

Gemini 4 Carbon on each data analysis prompt
PromptResultCostTime
The region with the most revenueEverydayPassed: Final answer North, 1085.00: right.$0.006213.4 s
Average order value in AugustEverydayPassed: Final answer 300.00: right.$0.007919.0 s
Revenue change from July to AugustEverydayPassed: Final answer 67.4%: right.$0.006211.8 s
A median, filtered two waysHardPassed: Final answer 6.25: right.$0.00245.5 s
Correlation between ad spend and sign-upsHardPassed: Final answer 0.97: right.$0.020230.7 s

Every data analysis reply from Gemini 4 Carbon

  1. The region with the most revenue

    An everyday prompt: “The region with the most revenue”, in full.

    Passed: Final answer North, 1085.00: right.

    **Revenue by region:**
    
    * **West:** $(2 \times 45.00) + (1 \times 310.00) + (2 \times 120.00) + (5 \times 45.00) = 90.00 + 310.00 + 240.00 + 225.00 = 865.00$
    * **East:** $(1 \times 120.00) + (3 \times 45.00) + (1 \times 310.00) + (3 \times 120.00) = 120.00 + 135.00 + 310.00 + 360.00 = 925.00$
    * **North:** $(4 \times 45.00) + (2 \times 120.00) + (2 \times 310.00) + (1 \times 45.00) = 180.00 + 240.00 + 620.00 + 45.00 = 1085.00$
    
    Final answer: North, 1085.00

    989 tokens in, 1,039 out (731 of them reasoning) · 13.4 s · $0.0062 · 1 message on Pro · answered by google/gemini-4-carbon via Google AI Studio ·

  2. Average order value in August

    An everyday prompt: “Average order value in August”, in full.

    Passed: Final answer 300.00: right.

    **Orders in August 2026:**
    * 1007: $2 \times 120.00 = 240.00$
    * 1008: $1 \times 310.00 = 310.00$
    * 1009: $2 \times 310.00 = 620.00$
    * 1010: $5 \times 45.00 = 225.00$
    * 1011: $3 \times 120.00 = 360.00$
    * 1012: $1 \times 45.00 = 45.00$
    
    **Total revenue:** $240.00 + 310.00 + 620.00 + 225.00 + 360.00 + 45.00 = 1800.00$
    **Number of orders:** $6$
    **Average revenue:** $1800.00 / 6 = 300.00$
    
    Final answer: 300.00

    998 tokens in, 588 out (303 of them reasoning) · 19.0 s · $0.0079 · 1 message on Pro · answered by google/gemini-4-carbon via Google AI Studio ·

  3. Revenue change from July to August

    An everyday prompt: “Revenue change from July to August”, in full.

    Passed: Final answer 67.4%: right.

    **July 2026 Revenue:**
    * 1001: $2 \times \$45.00 = \$90.00$
    * 1002: $1 \times \$120.00 = \$120.00$
    * 1003: $1 \times \$310.00 = \$310.00$
    * 1004: $4 \times \$45.00 = \$180.00$
    * 1005: $3 \times \$45.00 = \$135.00$
    * 1006: $2 \times \$120.00 = \$240.00$
    * **Total July:** $\$1,075.00$
    
    **August 2026 Revenue:**
    * 1007: $2 \times \$120.00 = \$240.00$
    * 1008: $1 \times \$310.00 = \$310.00$
    * 1009: $2 \times \$310.00 = \$620.00$
    * 1010: $5 \times \$45.00 = \$225.00$
    * 1011: $3 \times \$120.00 = \$360.00$
    * 1012: $1 \times \$45.00 = \$45.00$
    * **Total August:** $\$1,800.00$
    
    **Percentage Change:**
    $$\frac{1800 - 1075}{1075} \times 100 = \frac{725}{1075} \times 100 \approx +67.44\%$$
    
    Final answer: 67.4%

    1,005 tokens in, 1,044 out (590 of them reasoning) · 11.8 s · $0.0062 · 1 message on Pro · answered by google/gemini-4-carbon via Google AI Studio ·

  4. A median, filtered two ways

    A hard prompt: “A median, filtered two ways”, in full.

    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 `hours_to_resolve` values in ascending order:
       2, 4, 5.5, 7, 9, 26
    
    3. Find the median (average of the two middle values for an even set of 6 numbers):
       (5.5 + 7) / 2 = 6.25
    
    Final answer: 6.25

    770 tokens in, 324 out (158 of them reasoning) · 5.5 s · $0.0024 · 1 message on Pro · answered by google/gemini-4-carbon via Google AI Studio ·

  5. Correlation between ad spend and sign-ups

    A hard prompt: “Correlation between ad spend and sign-ups”, in full.

    Passed: Final answer 0.97: right.

    Let $x$ be `ad_spend` and $y$ be `signups` ($n = 8$).
    
    1. **Means:**
       * $\bar{x} = \frac{500 + 800 + 650 + 1200 + 900 + 300 + 1100 + 700}{8} = \frac{6150}{8} = 768.75$
       * $\bar{y} = \frac{42 + 55 + 49 + 71 + 60 + 35 + 64 + 58}{8} = \frac{434}{8} = 54.25$
    
    2. **Sums of deviations from the mean:**
       * $\sum (x_i - \bar{x})(y_i - \bar{y}) = 23,912.5$
       * $\sum (x_i - \bar{x})^2 = 624,687.5$
       * $\sum (y_i - \bar{y})^2 = 971.5$
    
    3. **Pearson correlation ($r$):**
       $$r = \frac{23,912.5}{\sqrt{624,687.5 \times 971.5}} = \frac{23,912.5}{24,635.01} \approx 0.9707$$
    
    Final answer: 0.97

    724 tokens in, 1,873 out (1,513 of them reasoning) · 30.7 s · $0.0202 · 1 message on Pro · answered by google/gemini-4-carbon via Google AI Studio ·

How it compares on data analysis

Gemini 4 Carbon beside the job's picks among every model. 22 models share the hard-problems pick, Gemini 4 Carbon among them.

Gemini 4 Carbon beside other models on data analysis
ModelPassedOn ProCost per reply
GPT-6.1 TerraOur pick: hard problems (shared), best value5 of 5250 a month on Pro$0.0008
GPT-6 LunaOur pick: hard problems (shared), everyday5 of 560 a day on Pro$0.0001
Gemini 4 CarbonOur pick: hard problems (shared)5 of 562 a month on Pro$0.0086
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: 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.

Gemini 4 Carbon next to each model on data analysis

Gemini 4 Carbon 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.2: Gemini 4 Carbon answered 3.9× later (13.4 s to 3.4 s), cost 2.1× less, and passed 5 of 5 to its 5.

  • Against Claude Fable 5.1: Gemini 4 Carbon answered 5.3× later (13.4 s to 2.5 s), cost 2.6× less, and passed 5 of 5 to its 5.

  • Against Claude Opus 5.5: Gemini 4 Carbon answered 4.4× later (13.4 s to 3.1 s), cost 1.3× less, and passed 5 of 5 to its 5.

  • Against Claude Sonnet 5.5: Gemini 4 Carbon answered 6.2× later (13.4 s to 2.1 s), cost 2.1× more, and passed 5 of 5 to its 4. Only Gemini 4 Carbon passed Correlation between ad spend and sign-ups.

  • Against Claude Sonnet 5: Gemini 4 Carbon answered 4.2× later (13.4 s to 3.2 s), cost 1.2× more, and passed 5 of 5 to its 4. Only Gemini 4 Carbon passed Correlation between ad spend and sign-ups.

  • Against Claude Haiku 5.5: Gemini 4 Carbon answered 8.6× later (13.4 s to 1.6 s), cost 30.1× more, and passed 5 of 5 to its 5.

  • Against Claude Haiku 4.5: Gemini 4 Carbon answered 5.2× later (13.4 s to 2.6 s), cost 3.4× more, and passed 5 of 5 to its 4. Only Gemini 4 Carbon passed Correlation between ad spend and sign-ups.

  • Against GPT-6.2 Astra: Gemini 4 Carbon answered 4.3× later (13.4 s to 3.1 s), cost 1.5× less, and passed 5 of 5 to its 5.

  • Against GPT-6 Astra: Gemini 4 Carbon answered 2.8× later (13.4 s to 4.8 s), cost within 10% of it, and passed 5 of 5 to its 5.

  • Against GPT-6.2 Sol: Gemini 4 Carbon answered 4.6× later (13.4 s to 2.9 s), cost 2.7× more, and passed 5 of 5 to its 5.

  • Against GPT-6.1 Sol: Gemini 4 Carbon answered 3.1× later (13.4 s to 4.4 s), cost 4.2× more, and passed 5 of 5 to its 5.

  • Against GPT-6 Sol: Gemini 4 Carbon answered 3.3× later (13.4 s to 4.0 s), cost 4.8× more, and passed 5 of 5 to its 5.

  • Against GPT-6.1 Terra: Gemini 4 Carbon answered 4.1× later (13.4 s to 3.3 s), cost 10.9× more, and passed 5 of 5 to its 5.

  • Against GPT-6 Luna: Gemini 4 Carbon answered 3.4× later (13.4 s to 4.0 s), cost 84.6× more, and passed 5 of 5 to its 5.

  • Against Gemini 4 Argon: Gemini 4 Carbon answered 1.6× later (13.4 s to 8.4 s), cost 2.9× more, and passed 5 of 5 to its 5.

  • Against Gemini 4 Hydrogen: Gemini 4 Carbon answered 2.2× later (13.4 s to 6.0 s), cost 1.4× more, and passed 5 of 5 to its 5.

  • Against Gemini 3.1 Pro (preview): Gemini 4 Carbon answered 1.7× later (13.4 s to 7.9 s), cost within 10% of it, and passed 5 of 5 to its 5.

  • Against Gemini 3.8 Flash: Gemini 4 Carbon answered 3.4× later (13.4 s to 4.0 s), cost 7.5× more, and passed 5 of 5 to its 4. Only Gemini 4 Carbon passed Correlation between ad spend and sign-ups.

  • Against DeepSeek V4.1 Flash: Gemini 4 Carbon answered 9.4× later (13.4 s to 1.4 s), cost 7.7× more, and passed 5 of 5 to its 5.

  • Against DeepSeek V4 Pro: Gemini 4 Carbon answered 2.6× later (13.4 s to 5.2 s), cost 2.6× more, and passed 5 of 5 to its 5.

  • Against Grok 4.7: Gemini 4 Carbon answered 1.9× later (13.4 s to 7.2 s), cost 1.2× less, and passed 5 of 5 to its 5.

  • Against Kimi K3.1 Pro: Gemini 4 Carbon answered 4.1× later (13.4 s to 3.3 s), cost 1.5× more, and passed 5 of 5 to its 5.

  • Against Kimi K3: Gemini 4 Carbon answered 2.7× later (13.4 s to 4.9 s), cost 1.3× more, and passed 5 of 5 to its 5.

  • Against GLM 5.3: Gemini 4 Carbon answered 11.8× later (13.4 s to 1.1 s), cost 4.5× more, and passed 5 of 5 to its 5.

  • Against GLM 5.3 Flash: Gemini 4 Carbon answered 18.1× later (13.4 s to 0.7 s), cost 35.9× more, and passed 5 of 5 to its 4. Only Gemini 4 Carbon passed Correlation between ad spend and sign-ups.

  • Against Mistral Large 4: Gemini 4 Carbon answered 1.5× later (13.4 s to 9.1 s), cost 3.2× more, and passed 5 of 5 to its 5.

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.

Gemini 4 Carbon, and data analysis, elsewhere

Questions

Is Gemini 4 Carbon good for data analysis?

In our test runs it passed 5 of 5 data analysis prompts, tied 1st of the 27 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 Gemini 4 Carbon use?

1 message each on Pro, where it has 62 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. Every plan is month to month: cancel in two clicks. Sign in with an email link, no password.