Stem and Leaf Plot in Excel

Stem and Leaf Plots show the Spread & Shape of Data

  • Stem represents the first digits of the data points
  • Count represents a count of the number of data points with that first digit
  • Leaves represent the second digits in the data set (numbers 0-9)
  • Median is the mid point in the data set and is shown next to the leaf

To Use the QI Macros Stem and Leaf Plot Maker:

  1. Click on the QI Macros Menu, then Chart Templates and then Stem and Leaf Plot.
  2. A blank template will open.

stem and leaf plot template menu in QI Macros for Excel

 

  1. Type or cut and paste your data into the yellow shaded area.
  2. Then double click on the button to run the analysis.
  3. QI Macros sorts the data and calculates the results.
stem and leaf plot excel input area

Stem and Leaf Plot Results Explained

Stem and Leaf Plot in Excel using QI Macros

How points 80, 82, 86 and 88 are shown in the results:

  • Stem = the first digit = 8
  • Count = # of data points with 8 as the first digit = 4 data points
  • Leaves = second digits in the data set = 0268
  • Median is the mid point in the data set and is shown next to the leaf


Learn More ...

To create a Stem And Leaf Excel using QI Macros...
Try It Now!