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:
- Click on the QI Macros Menu, then Chart Templates and then Stem and Leaf Plot.
- A blank template will open.
- Type or cut and paste your data into the yellow shaded area.
- Then double click on the button to run the analysis.
- QI Macros sorts the data and calculates the results.
Stem and Leaf Plot Results Explained
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...
To create a Stem And Leaf Excel using QI Macros...
