Back-to-back Stem and Leaf Plot Template in Excel
Create a double or two-sided stem and leaf plot in seconds.
A stem and leaf plot shows the spread and distribution of a data set.
- Stem represents the first digits of the data points
- Leaves represent the second digits in the data sets (numbers 0-9)
- Median is the mid point in the data set and is shown next to the leaf
A back-to-back stem and leaf plot shows two data sets. The data sets share the same stem and have their own set of leaves.
Example of a double stem and leaf plot created by QI Macros add-in for Excel
It's easy to create both single and double stem and leaf plots using QI Macros
QI Macros installs a new menu on Excel's tool-bar. To create a stem and leaf plot:
- Click on QI Macros > Chart Templates > Stem and Leaf Plot to open the template:
- The template will open and contains some pre-populated sample data.
- Input or cut and paste your data into the yellow input areas:
- Double click on the Update Plot button and QI Macros will perform the analysis and create the two-sided plot:
When Should I Use a Back-to-Back Stem and Leaf Plot?
Use a back-to-back or double sided stem and leaf plot when you want to compare the spread and distribution of two data sets. You can also use side by side histograms for the same purpose or lay the plots on their sides for a different view:
Learn More ...
Why Choose QI Macros?
Affordable
- Only $329 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free