Session 6.2 — Stem‑and‑Leaf Plot (with Excel Builder)

Paste numbers → get a clean stem‑and‑leaf plot • shows depth/median like Minitab • plus copy‑paste Excel formulas to build the same thing.
Input numbers Separate with commas, spaces, or new lines.

Stem‑and‑Leaf

Depth shows cumulative count from top (upper half) and from bottom (lower half). The ( ) marks the row containing the median.
DepthStemLeaves (sorted)Freq
Total n—

What’s a good stem choice?

Choose between ~5 and 20 stems so the shape is clear; unit = 10 (tens) is a common start for 2–3 digit data. You can split stems (L/U or 5‑way) for more detail. (Book §6.2 explains stems, leaves, and splitting.)

“Unit (E1)” — what it means & how to choose

Unit is the stem base. Each stem represents a block of size Unit. With Unit = 10: stem = QUOTIENT(value,10), leaf = MOD(value,10). Example: 154 → stem 15, leaf 4.

Rule of thumb: aim for about 10–15 stems (anything 5–20 is fine). Fewer = too chunky; more = too busy.

Quick picks

  • 10 → Tens (use for 2–3 digit integers like your alloy data 76–245).
  • 1 → Ones (use for small 1–2 digit integers).
  • 100 → Hundreds (use for 4‑digit data).
  • Decimals? Either scale: =ROUND(A2*10,0) then Unit=10, or keep values and pick Unit that groups sensibly.

Excel link

Put your chosen unit in cell E1 so all formulas reference it ($E$1). Change E1 once → entire table updates.