Grok 4.7 · Data analysis
Grok 4.7 for data analysis: our test runs
Grok 4.7 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 October 2, 2026, Grok 4.7 passed 5 of 5 of our data analysis prompts (both hard ones): tied 1st of 20 models. Each reply counted as 1 message on Pro, where it has 250 a month, and cost $0.0111 to run on average.
Prompt by prompt
Each of the 5 data analysis prompts, and how Grok 4.7's reply did.
| Prompt | Result | Cost | Time |
|---|---|---|---|
| The region with the most revenueEveryday | Passed: Final answer North 1085: right. | $0.0067 | 8.9 s |
| Average order value in AugustEveryday | Passed: Final answer 300.00: right. | $0.0072 | 9.1 s |
| Revenue change from July to AugustEveryday | Passed: Final answer 67.4%: right. | $0.0074 | 7.7 s |
| A median, filtered two waysHard | Passed: Final answer 6.25: right. | $0.0037 | 4.4 s |
| Correlation between ad spend and sign-upsHard | Passed: Final answer 0.97: right. | $0.0306 | 50.5 s |
Every data analysis reply from Grok 4.7
The region with the most revenue
An everyday prompt: “The region with the most revenue”, in full.
Passed: Final answer North 1085: right.
West: 90 + 310 + 240 + 225 = 865 East: 120 + 135 + 310 + 360 = 925 North: 180 + 240 + 620 + 45 = 1085 Final answer: North 1085
1,877 tokens in, 784 out (725 of them reasoning) · 8.9 s · $0.0067 · 1 message on Pro · answered by x-ai/grok-4.7 via xAI ·
Average order value in August
An everyday prompt: “Average order value in August”, in full.
Passed: Final answer 300.00: right.
August 2026 orders (6): - 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 = 1800.00 Average = 1800.00 / 6 = 300.00 Final answer: 300.00
1,884 tokens in, 865 out (716 of them reasoning) · 9.1 s · $0.0072 · 1 message on Pro · answered by x-ai/grok-4.7 via xAI ·
Revenue change from July to August
An everyday prompt: “Revenue change from July to August”, in full.
Passed: Final answer 67.4%: right.
July revenue: 90 + 120 + 310 + 180 + 135 + 240 = 1075. August revenue: 240 + 310 + 620 + 225 + 360 + 45 = 1800. Change: (1800 − 1075) / 1075 × 100 = 67.44186…%, which rounds to 67.4%. Final answer: 67.4%
1,889 tokens in, 893 out (799 of them reasoning) · 7.7 s · $0.0074 · 1 message on Pro · answered by x-ai/grok-4.7 via xAI ·
A median, filtered two ways
A hard prompt: “A median, filtered two ways”, in full.
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 ·
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.
Pearson r uses \[ r=\frac{n\sum xy-\sum x\sum y}{\sqrt{[n\sum x^2-(\sum x)^2][n\sum y^2-(\sum y)^2]}} \] with \(n=8\), \(x=\) ad_spend, \(y=\) signups. \(\sum x=6150\), \(\sum y=434\), \(\sum xy=357550\), \(\sum x^2=5352500\), \(\sum y^2=24516\). Numerator: \(8\cdot357550-6150\cdot434=191300\). Denominator parts: \(8\cdot5352500-6150^2=4997500\), \(8\cdot24516-434^2=7772\). \(\sqrt{4997500\cdot7772}\approx197080.11\). \(r=191300/197080.11\approx0.9707\), which rounds to \(0.97\). Final answer: 0.971,687 tokens in, 4,825 out (4,601 of them reasoning) · 50.5 s · $0.0306 · 1 message on Pro · answered by x-ai/grok-4.7 via xAI ·
How it compares on data analysis
Grok 4.7 beside the job's picks among every model. 16 models share the hard-problems pick, Grok 4.7 among 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 |
| Grok 4.7Our pick: hard problems (shared) | 5 of 5 | 250 a month on Pro | $0.0111 |
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.
Grok 4.7 next to each model on data analysis
Grok 4.7 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: Grok 4.7 answered 1.8× later (8.9 s to 4.9 s), cost 2.5× less, and passed 5 of 5 to its 5.
Against Claude Opus 5.5: Grok 4.7 answered 2.0× later (8.9 s to 4.6 s), cost 1.2× less, and passed 5 of 5 to its 5.
Against Claude Sonnet 5.5: Grok 4.7 answered 3.9× later (8.9 s to 2.3 s), cost 2.4× more, and passed 5 of 5 to its 5.
Against Claude Sonnet 5: Grok 4.7 answered 1.7× later (8.9 s to 5.3 s), cost 1.6× more, and passed 5 of 5 to its 4. Only Grok 4.7 passed Correlation between ad spend and sign-ups.
Against Claude Haiku 5.5: Grok 4.7 answered 2.7× later (8.9 s to 3.3 s), cost 31.0× more, and passed 5 of 5 to its 5.
Against Claude Haiku 4.5: Grok 4.7 answered 3.3× later (8.9 s to 2.7 s), cost 4.5× more, and passed 5 of 5 to its 3. Only Grok 4.7 passed Average order value in August; Correlation between ad spend and sign-ups.
Against GPT-6 Astra: Grok 4.7 answered 2.7× later (8.9 s to 3.3 s), cost 1.4× less, and passed 5 of 5 to its 5.
Against GPT-6.1 Sol: Grok 4.7 answered 3.0× later (8.9 s to 3.0 s), cost 7.0× more, and passed 5 of 5 to its 5.
Against GPT-6 Sol: Grok 4.7 answered 3.2× later (8.9 s to 2.8 s), cost 3.3× more, and passed 5 of 5 to its 5.
Against GPT-6 Luna: Grok 4.7 answered 3.6× later (8.9 s to 2.5 s), cost 63.2× more, and passed 5 of 5 to its 5.
Against Gemini 4 Argon: Grok 4.7 answered 1.3× later (8.9 s to 6.9 s), cost 3.9× more, and passed 5 of 5 to its 5.
Against Gemini 3.1 Pro (preview): Grok 4.7 answered within 10% of its time (8.9 s to 8.6 s), cost 1.4× less, and passed 5 of 5 to its 5.
Against Gemini 3.8 Flash: Grok 4.7 answered 1.7× later (8.9 s to 5.4 s), cost 4.0× more, and passed 5 of 5 to its 4. Only Grok 4.7 passed Correlation between ad spend and sign-ups.
Against DeepSeek V4.1 Flash: Grok 4.7 answered 10.3× later (8.9 s to 0.9 s), cost 13.1× more, and passed 5 of 5 to its 5.
Against DeepSeek V4 Pro: Grok 4.7 answered 2.2× later (8.9 s to 4.1 s), cost 3.9× more, and passed 5 of 5 to its 5.
Against Kimi K3: Grok 4.7 answered 2.5× later (8.9 s to 3.5 s), cost 1.6× more, and passed 5 of 5 to its 5.
Against GLM 5.3: Grok 4.7 answered 4.6× later (8.9 s to 1.9 s), cost 5.8× more, and passed 5 of 5 to its 5.
Against GLM 5.3 Flash: Grok 4.7 answered within 10% of its time (8.9 s to 9.8 s), cost 28.9× more, and passed 5 of 5 to its 4. Only Grok 4.7 passed Correlation between ad spend and sign-ups.
Against Mistral Large 4: Grok 4.7 answered 1.8× sooner (8.9 s to 15.8 s), cost 3.0× 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.
Grok 4.7, and data analysis, elsewhere
- Grok 4.7: price, limits and messages on every plan
- Grok 4.7 for coding: our test runs
- Grok 4.7 for writing: our test runs
- Grok 4.7 for math: our test runs
- Claude Fable 5.1 vs Grok 4.7
- GPT-6 Astra vs Grok 4.7
- Claude Sonnet 5 vs Grok 4.7
- Claude Haiku 4.5 vs Grok 4.7
- GPT-6 Sol vs Grok 4.7
- GPT-6 Luna vs Grok 4.7
- Gemini 3.1 Pro (preview) vs Grok 4.7
- Gemini 3.8 Flash vs Grok 4.7
- DeepSeek V4.1 Flash vs Grok 4.7
- DeepSeek V4 Pro vs Grok 4.7
- Grok 4.7 vs Kimi K3
- Grok 4.7 vs GLM 5.3
- Grok 4.7 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 Grok 4.7 good for data analysis?
In our test runs it passed 5 of 5 data analysis prompts, tied 1st 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 Grok 4.7 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.