Example A: inflation
Did inflation after 2020 hit ASEAN harder than the G7?
The mean adds the country results and divides by the number of countries. The median is the middle country result when sorted. Each country counts equally, regardless of its population or economy.
What you will make
Annual inflation, 2020 to 2025
Thin lines show countries. Bold lines show each group's median for that year.
Cumulative price rise, 2020 to 2025
● ASEAN ● G7
Laos (LAO) and Myanmar (MMR) run off the typical scale. The axis stops at 40%; labels show their full values.
Charts need JavaScript and the chart download. The table and CSV remain available.
The numbers behind the answer
Peak is the highest annual rate in 2021 to 2023. Cumulative rise compounds all six annual rates, including 2020. Group rows summarise country results, with equal weight for each country. Missing results say “no data” and are excluded from group summaries.
| Country or summary | Group | Peak 2021-23 | Cumulative 2020-25 |
|---|---|---|---|
| ASEAN mean | ASEAN | 9.6% | 42.6% |
| ASEAN median | ASEAN | 6.0% | 17.8% |
| G7 mean | G7 | 7.2% | 21.6% |
| G7 median | G7 | 8.0% | 20.7% |
| Brunei | ASEAN | 3.7% | 7.2% |
| Cambodia | ASEAN | 5.3% | 17.8% |
| Indonesia | ASEAN | 4.1% | 16.7% |
| Laos | ASEAN | 31.2% | 133.4% |
| Malaysia | ASEAN | 3.4% | 10.8% |
| Myanmar | ASEAN | 27.6% | 187.7% |
| Philippines | ASEAN | 6.0% | 25.2% |
| Singapore | ASEAN | 6.1% | 17.4% |
| Thailand | ASEAN | 6.1% | 8.1% |
| Timor-Leste | ASEAN | 8.4% | 24.1% |
| Vietnam | ASEAN | 3.3% | 19.9% |
| Canada | G7 | 6.8% | 20.7% |
| France | G7 | 5.9% | 18.6% |
| Germany | G7 | 8.7% | 25.1% |
| Italy | G7 | 8.7% | 20.4% |
| Japan | G7 | 3.3% | 11.9% |
| United Kingdom | G7 | 9.1% | 28.3% |
| United States | G7 | 8.0% | 26.1% |
Data: IMF World Economic Outlook, April 2026 vintage (WEO_2026_APR_VINTAGE). Fetched 10 Oct 2026.
Try it yourself
Download the CSV
✅ Free pending testSave this file to your Downloads folder. CSV means a plain table that a spreadsheet can open.
I have downloaded inflation.csv. Explain how to open it in a spreadsheet without changing the original file.A file named inflation.csv with 18 country rows, group labels, and yearly inflation rates.
Upload it and ask for a line chart
⚠️ Free, limit: free upload and message caps pending testOpen your AI chat. Attach the CSV with the plus or attachment button, then paste this prompt. If you reach a free limit, save your chat and return when it resets.
Use only the attached inflation.csv. Check the row count, groups, years, and missing values first.
Make a line chart of annual inflation for ASEAN versus the G7, 2020 to 2025.
Show all 18 countries as thin muted lines and each group's yearly median as a bold line.
Label the years and the annual inflation rate in percent. Keep missing values as gaps.
Explain the chart in two short sentences. If you cannot draw it here, give me spreadsheet steps.A chart with 18 country lines and two bold group medians. Laos and Myanmar stand out.
Compare the peak and total rise
⚠️ Free, limit: free message cap pending testUsing the same CSV, make a table by country and group.
Peak inflation is the highest annual rate in 2021, 2022, or 2023.
Cumulative rise is 100 × (the product of (1 + annual rate/100) for every year 2020 through 2025, minus 1).
Include the 2020 rate. Do not add annual rates together. If a required year is missing, report no data.
For each group, show BOTH the unweighted mean and median of country peaks and country cumulative rises.
Exclude missing results from group summaries and report the number included. Round only the final results to one decimal place.One row per country, plus ASEAN mean, ASEAN median, G7 mean, and G7 median rows. Compare them with the table above.
Ask the AI to check itself
⚠️ Free, limit: free message cap pending testWhich countries drive the difference? Does the answer change with the median?
Use the CSV and show the mean and median side by side.
Explain what Laos and Myanmar do to the ASEAN mean.
Distinguish a typical country's experience from the group average. Do not claim these data prove what caused inflation.The reply explains why the ASEAN mean is higher while its median is lower than the G7 median.
Ask for a one-page policy memo
⚠️ Free, limit: free message cap pending testWrite a one-page policy memo answering: Did inflation after 2020 hit ASEAN harder than the G7?
Use only the CSV and the checked calculations. Lead with the answer.
Report both group means and medians, identify the countries driving the difference, and explain the limits of this comparison.
Suggest two policy questions to investigate, without claiming that the data prove a cause.
Cite IMF World Economic Outlook, April 2026 vintage (WEO_2026_APR_VINTAGE), fetched 10 Oct 2026. Use plain English.A short memo with a clear answer, checked numbers, caveats, and two questions for further research.
Example memo, written by Grok from the CSV and checked by Claude
Did inflation after 2020 hit ASEAN harder than the G7?
To: Regional economic policy team
From: Policy analyst
Date: October 2026
Bottom line. Only on the mean, and only because of Myanmar and Laos. Cumulative CPI inflation from 2020 to 2025 (product of (1 + r/100) minus 1) averages 42.6% in ASEAN and 21.6% in the G7, 21 percentage points higher. Medians reverse that: 17.8% in ASEAN (Cambodia) and 20.7% in the G7 (Canada). Drop Myanmar (187.7%) and Laos (133.4%) and the ASEAN mean falls to 16.3%, about 5 percentage points under the G7, with a median of 17.4%.
Who drives the gap. G7 rises are bunched: Japan 11.9%, France 18.6%, Italy 20.4%, Canada 20.7%, Germany 25.1%, the United States 26.1%, the United Kingdom 28.3%. Seven ASEAN members finish under the G7 median: Brunei 7.2%, Thailand 8.1%, Malaysia 10.8%, Indonesia 16.7%, Singapore 17.4%, Cambodia 17.8%, Vietnam 19.9%. Timor-Leste (24.1%) and the Philippines (25.2%) sit inside the upper G7 range. Only Laos and Myanmar exceed the UK. In 2022 the ASEAN median was 5.8% and the G7 median 8.0%, while the ASEAN mean was 8.6% because Myanmar hit 27.2% and Laos 23.0%. In 2025 medians were close (ASEAN 1.7%, G7 2.3%), but Myanmar was still 22.0% and Laos 7.7%.
Policy implications.
- Do not brief ASEAN inflation from the regional mean. Two countries create the whole gap with the G7.
- For the other nine, the price level rose by about as much as the G7 or less. Brunei, Thailand, and Malaysia stayed near or below 11%, so an inflation-first stance fits them poorly.
- Watch Laos and Myanmar separately. Their rates stay high after the 2022 peak, which points to domestic drivers this file cannot name.
Caveats.
- Each country counts once. The file has no population or GDP weights, so Brunei equals Indonesia.
- Figures are annual headline CPI only: no core split, no monthly path, and no flag for whether 2025 is an estimate. Compounding annual rates approximates the CPI level, not welfare. Myanmar’s numbers are rounded more coarsely than the other rows.
Check the AI against the CSV
⚠️ Free, limit: free message cap pending testOpen the CSV yourself. Check one peak and one cumulative rise before sharing your memo.
Help me spot-check two numbers against inflation.csv.
1. Show Canada's 2021, 2022, and 2023 rates and identify the peak.
2. Show Cambodia's six annual rates from 2020 through 2025 and the multiplication that gives its cumulative price rise.
Show the unrounded calculation, then round the result to one decimal place.
Tell me exactly which cells to check in my spreadsheet. Do not fill missing values.Your checks match Canada’s peak of 6.8% and Cambodia’s cumulative rise of 17.8%. If they differ, fix the calculation before using the memo.