learn-market-sizing-with-phoebe / Analyst session 1 of 6
Learn Market Sizing with Phoebe · Analyst session 1 of 6

Top-down: from public statistics to your segment

A top-down size starts from a number somebody else measured, usually a government, and narrows it link by link until it describes the customers you could actually serve. Every link is either a real statistic or an assumption, and the craft is knowing which is which. Tonight the chain runs on Japan's own rows: 34,553,907 two-or-more-person households from the 2020 Census, and what those households spend on tea in the Family Income and Expenditure Survey. Then the three ways a real table quietly changes your answer: who the survey asked, what its item names mean, and whose spending you assume everyone shares.

🟢 Analyst Data analysts and data scientists who build the size Hands-on in the browser 45 min
0-3 · Welcome 3-18 · The chain, the population, the items 18-40 · Build-along: the chain on real rows 40-45 · Q&A
Part 0

Where we start

The Analyst track builds the evidence half of a market size: defensible numbers, stated as ranges, with the method on the page. Six sessions: tonight top-down from public statistics; then bottom-up from your own data; then analogy and proxy when no table measures your market; then ranges and the tornado; then share realism; then the triangulation bench, where the two methods meet. Every widget computes in your browser. Kettle & Co, a direct-to-consumer tea brand, is constructed, and so are its shares and pilot numbers; the households and the tea spend are real rows from the Statistics Bureau of Japan.

🎫 Clear all three quiz questions to stamp your passport Live = presented in the 45 minutes Self-study = the full depth, after class ★ Build-along = everyone works it through

★ What you walk out with tonight. A top-down chain for Kettle & Co's premium loose-leaf tea bought online in Japan, written link by link with each link marked real or constructed and its source named, plus three notes on the table itself: the population it covers, the items you chose, and the place whose rate you used. The chain feeds the bench in Analyst session 6.

Part 1 · covers the top-down chain

A chain of links, each one real or assumed

5 min live

Top-down sizing multiplies a population by a rate and then by shares. Population times rate is usually measured by somebody else; the shares are usually yours. Writing the chain as separate links, each with its source, is what lets a reviewer argue with one link instead of rejecting the whole number.

THE TOP-DOWN CHAIN FOR KETTLE & CO, LINK BY LINK solid box = a real statistic · dashed box = a constructed assumption HOUSEHOLDS 34,553,907 2020 Census, two-or- more-person · real x LEAF SPEND 5,737 yen per household a year FIES 2023-2025 · real x PREMIUM 33% of leaf spend constructed x ONLINE 30% bought online constructed TOP-DOWN 19.63 bn yen a year households x spend alone: 198.24 bn yen a year every leaf-tea household counted as a customer Two real links, two assumed ones. The assumed links shrink the real product tenfold, so they carry the argument.
🔍 Click to zoom - the dashed links are where a reviewer should push, because nobody measured them
LiveThe four links, and where each comes from3 min▶

Population: 34,553,907 households. The 2020 Population Census counts 55,704,949 general households in Japan, of which 21,151,042 are one-person households (38.0 percent). The rest, 34,553,907, are two-or-more-person households. That subtraction is ours; both inputs are read from Table I-4-2 of the Census results outline.

Rate: 5,737 yen a year of leaf tea. The Family Income and Expenditure Survey publishes what an average two-or-more-person household spends on each item, averaged over 2023 to 2025. Green tea leaf 3,187 yen, black tea leaf 878, other tea leaf 1,672: together 5,737 yen.

Shares: premium 33 percent, online 30 percent. Neither is in any table. They are Kettle & Co planning assumptions, constructed for teaching, each with a low and a high: premium 25 to 40 percent, online 22 to 40 percent. A real team would source them from retailer panels, its own pilot or interviews, and would say which.

Multiplied through, the middle is 19.63 billion yen a year. Carry every assumption to its low together and to its high together and the range is 10.90 to 31.72. The widget below prints both, and so does the bench in Analyst session 6.

Self-studyWhy a chain beats a single "market is X" line2 min▶

A single figure can only be accepted or rejected. A chain can be repaired. When the head of BD says "30 percent online feels high", the analyst changes one link and reprints the size in a minute, and the conversation moves to the evidence for that one share. Writing the chain also exposes double counting: if the premium share was estimated from online orders, multiplying by an online share again counts the same filter twice.

Real world

Two real numbers, two guesses, one confident slide. Kettle & Co's first Japan slide said "19.6 billion yen, source: Statistics Bureau of Japan". The household count and the spend are from the Bureau; the two shares that cut the product by a factor of ten are not. The rewritten slide shows the chain with the shares marked as assumptions, and the BD lead now knows which two numbers to go and test. Constructed Kettle & Co example.

Part 2 · covers the survey population and its items

Who the table asked, and what its words mean

5 min live

A government table answers the question its designers asked, which is rarely yours. Two checks come before any multiplication: whose behaviour the table measured, and what each item name actually includes. Both change the answer more than most assumptions do.

WHO THE SURVEY ASKED Japan's general households, 2020 Census WHAT "TEA" MEANS IN THE TABLE yen per household a year, FIES 2023-2025 two-or-more-person leaf 5,737 bottled tea drinks 8,633 34,553,907 households the survey's population 21,151,042 one-person 38.0%, not in this table tea total 14,370 the four items add up exactly 60% of the tea total is drinks in a bottle or can Sizing "tea" from the total would count convenience-store bottles Kettle never sells. Sizing every household at the same rate assumes 21 million people living alone buy like families.
🔍 Click to zoom - both bars are real, and both hide a choice the table made for you before you opened it
LiveThe population: two-or-more-person households only3 min▶

The survey table used here covers two-or-more-person households. One-person households are measured as a separate survey population and are not in the rows. So the honest chain multiplies the survey rate by the 34,553,907 households the rate describes, not by all 55,704,949.

The widget lets you include one-person households "at the same spend". Do it and the top-down moves from 19.63 to 31.64 billion yen a year. That option is an assumption, and it is labelled as one: there is no row here that says how much a person living alone spends on leaf tea. If your segment is young professionals living alone, this is the link to go and source properly, not to default.

LiveThe items: read the names, then the totals2 min▶

The survey's tea group has four items: green tea leaf, black tea leaf, other tea leaf, and bottled and canned tea drinks. Bottled drinks are 8,633 of the 14,370 yen, 60 percent of the group. A loose-leaf brand that sizes "tea" from the group total starts two and a half times too high before any share is applied.

"Other tea leaf" is the survey's catch-all leaf item. It is tempting to guess what is in it; do not put the guess in the chain. Name the item as the table names it and say whether you included it.

Self-studyPublished tables do not always add up2 min▶

In the national row the four tea items add to the tea total exactly. In 15 of the 52 city rows they differ from the published total by 1 or 2 yen, because each figure is a rounded average published on its own. A validation check that demands exact equality fails on real data and teaches the team to switch checks off. Write the tolerance into the check instead: the engine behind these widgets accepts up to 2 yen and fails beyond it.

Part 3 · covers extrapolating one place's rate

Whose spending did you assume everyone shares?

5 min live

The table also publishes a rate for each of 52 prefectural capitals and designated cities. That is useful for choosing where to launch, and dangerous when one city's rate is multiplied by the whole country. A launch team based in the most tea-loving city in Japan will size Japan from its own street.

ONE CHAIN, THREE PLACES' RATES leaf tea yen per household a year, bar length to scale · top-down in bn yen a year Naha National average Shizuoka 3,279 yen 11.22 5,737 yen 19.63 9,694 yen 33.16 Same households, same shares. Only the place whose rate is used changed. Shizuoka's leaf spend is 1.69 times the national average. Its rate describes Shizuoka, not Japan.
🔍 Click to zoom - the national row is the only one whose rate describes the households you multiplied it by
LiveShizuoka, Naha, and the national row3 min▶

Green tea leaf spend runs from 7,697 yen a year per household in Shizuoka, the highest city, to 1,246 yen in Naha, the lowest, against 3,187 nationally. Across all leaf items Shizuoka households spend 9,694 yen, 1.69 times the national 5,737.

Apply Shizuoka's leaf rate to every two-or-more-person household in Japan and the top-down prints 33.16 billion yen a year instead of 19.63. Apply Naha's and it prints 11.22. Nothing else in the chain moved. City rows are the right tool for "where should Kettle launch first?"; the national row is the right tool for "how big is Japan?".

Self-studyWhen a regional rate is the right one2 min▶

If the decision is a regional launch, size the region with its own rate and its own household count, and say so in the chain. The mistake is only the mix: a local rate multiplied by a national population. The same mix happens in other forms, such as sizing a country from the spend of the customers who found you first, who are rarely average.

Real world

The launch team's home town. Kettle & Co's first Japan hire lives in Shizuoka and builds the sizing from "what households around here spend". The number comes out 1.69 times too high for Japan, and nobody notices because the source line still says "official survey". The fix is one dropdown: the national row. Constructed Kettle & Co example; the survey figures are real.

Build-along

Run the chain on the real rows

★ 22 min · everyone builds

The widget below holds the national row and all 52 city rows of the survey's drinks table, plus the Census household counts. It recomputes the chain the moment you change a control. Work the five steps in order and write down what the widget prints at each one; the shares are constructed, so once you move a slider your numbers will differ from the ones quoted here.

WHICH CONTROL MOVES WHICH LINK every control in the widget changes exactly one link, except category households spend per household x premium share x online share Population Category Place the two sliders also switches the premium link on or off Change one control at a time. Two at once and you cannot say which link moved the size.
🔍 Click to zoom - the amber link is the one three of the four controls reach; it is where a top-down chain is most often wrong

Step 1 · Read the default chain. Category premium loose-leaf, population two-or-more-person households, place the national row, both sliders at their middles. Copy each link and its tag, real or constructed, into your notes.

★ Step 1 · what the widget printsTop-down: 19.63 billion yen a year (range 10.90 to 31.72) households 34,553,907 real spend per household (leaf) 5,737 yen a year real x premium share 33% constructed x share bought online 30% constructed

Step 2 · Change the category to "Tea, all of it". The spend link jumps to the survey's whole tea group, bottled drinks included, and the premium link disappears because the frame is no longer premium. Write down the new size, then put the category back.

★ Step 2 · the category moves the rateTop-down: 148.96 billion yen a year (range 109.24 to 198.62) spend per household (tea, all of it) 14,370 yen a year real question to write next to it: does Kettle sell what this link counts?

Step 3 · Change the population to "All households, one-person included". The households link becomes 55,704,949, and the widget says out loud that this assumes one-person households spend the same. Note the size, and note that the assumption is now in your chain.

★ Step 3 · the population moves the baseTop-down: 31.64 billion yen a year (range 17.58 to 51.13) households 55,704,949 (one-person included: assumes the same spend) the survey rate describes 34,553,907 of them

Step 4 · Set the population back, then change the place to Shizuoka, then Naha. Read the hint line under the chain: it tells you the rate now describes one city. Then set the place back to the national row.

★ Step 4 · one city's rate, a whole countryShizuoka spend 9,694 yen Top-down 33.16 (range 18.42 to 53.59) Naha spend 3,279 yen Top-down 11.22 (range 6.23 to 18.13) national spend 5,737 yen Top-down 19.63 (range 10.90 to 31.72)

Step 5 · Move each slider once, then write the chain as a sentence. Drag the premium share to where you believe it sits and read the new size; do the same for the online share. Then write the chain the way it will go in the sizing brief, one clause per link, each with its source or the word "assumed".

★ Step 5 · the chain in one sentence"34,553,907 two-or-more-person households (2020 Census) x 5,737 yen a year of leaf tea each (FIES, 2023-2025 average, national row) x ____ premium share (assumed, source to find: __________) x ____ bought online (assumed, source to find: __________) = ____ billion yen a year, range ____ to ____." Your numbers will differ from 19.63 as soon as you move a slider.

Keep the sentence. It is the top-down half of the triangulation bench in Analyst session 6. Analyst session 2 builds the other half from Kettle & Co's own pilot, from the bottom up, and the gap between the two is where the learning is.

Homework

Before Analyst session 2

30 min
  1. Find the official table for your own market: a household expenditure survey, a business census, an import statistic. Write its exact name, table id, year and the population it covers.
  2. List its items that sit near your product, and mark which ones your product actually competes in. Check whether the items add up to the published total, and by how much they miss.
  3. Write your chain in the step 5 format, with every link tagged real or assumed. Count the assumed links.
  4. For the assumed link that shrinks the size most, write the cheapest way you could source it in a week: a retailer panel, a pilot, ten interviews.
Check yourself

Three questions

Clear all three and Analyst session 1 gets stamped in your passport.

1 · The survey's tea spend describes two-or-more-person households. Which household count belongs in the chain?

A rate describes the population it was measured on. Including one-person households at the same spend moves the top-down from 19.63 to 31.64, and that move is an assumption, not a statistic.

2 · A loose-leaf brand sizes "tea" from the survey's tea total of 14,370 yen. What went wrong?

Read the item names before the totals. The tea group includes bottled drinks, 8,633 of the 14,370 yen.

3 · The chain uses Shizuoka's leaf spend for every household in Japan and prints 33.16 instead of 19.63. What is the error?

City rows answer "where first?". The national row answers "how big is Japan?". Mixing them inflated the size 1.69-fold without changing any assumption.

Sources covered

What this session teaches, and where it came from

✓55,704,949 general households; 21,151,042 one-person (38.0%); 34,553,907 two-or-more-personStatistics Bureau of Japan, 2020 Population Census, Basic Complete Tabulation on Population and Households, Table I-4-2; read at source; the last figure by subtraction
✓Tea total 14,370 yen; green 3,187, black 878, other leaf 1,672, bottled 8,633; Shizuoka 9,694 and 7,697, Naha 1,246Statistics Bureau of Japan, Family Income and Expenditure Survey, two-or-more-person households, item ranking by prefectural capital and designated city, 2023-2025 average (drinks); read at source
✓Top-down 19.63 (10.90 to 31.72); 148.96 for all tea; 31.64 with one-person households; 33.16 Shizuoka, 11.22 NahaComputed by the widget engine on the real rows; the premium and online shares are constructed
◐Spend of one-person householdsA separate survey population, not read; the "all households" option is labelled as an assumption

Every fact on this page, and its verification tier, is recorded in the course's source map.

Analyst session 1 cheat sheet · pin this

Population x rate x sharesWrite each link separately, tagged real or assumed, with its source.
Match the populationMultiply a rate by the households it was measured on: 34,553,907, not 55,704,949.
Read item names60% of the tea group is bottled drinks. Leaf is 5,737 of 14,370 yen.
National row for a countryShizuoka's rate prints 33.16, Naha's 11.22, Japan's 19.63.
Tolerate rounding15 city rows miss their total by 1 or 2 yen. Check with a tolerance.
Assumed links carry itTwo shares cut 198.24 to 19.63. Source those first.