Reliable Six Sigma & SPC Excel Add-in

- Home
- Contact
- 888-468-1537

**My Cart**

*0*

- 888-468-1537

- Why QI Macros
- About Us
- Our Customers
- Customer Testimonials and Reviews
- SPC Software for Excel
- SPC Software Comparison
- Hassle Free Guarantee

- Key Tools
- Control Chart
- Histogram with Cp Cpk
- Pareto Chart
- Box and Whisker Plot
- Lean Six Sigma Templates
- Fishbone Diagram
- Gage R&R MSA
- Data Mining Tools
- Statistical Analysis

- Training
- Free Yellow Belt Training
- Free White Belt Training
- Free QI Macros Training Resources
- Free QI Macros & Six Sigma Webinars
- Free Excel Training Videos
- QI Macros & Excel One-Day Workshop
- Lean Six Sigma "Lite" Yellow Belt

- Services
- Lean Six Sigma Consulting
- Lean Six Sigma Coaching
- What is Lean Six Sigma?
- Do-It-For-Me Data Analysis
- Certification

- Support
- Tech Support
- Purchasing Info and W9
- QI Macros FAQs
- Upgrade History
- Submit Enhancement Request

- FREE Resources
- QI Macros How To Articles
- Excel Tips and Tutorials
- Breakthrough Improvement
- Lean Six Sigma Articles
- Lean Six Sigma White Papers
- KnowWare Articles
- Partners / Lean Six Sigma Links
- News and Media
- Blog

- Store
- QI Macros Software
- QI Macros Quantity Discounts
- Chart Templates for Excel
- Lean Six Sigma Books & Whitepapers
- KnowWare Products

- Order Now

CLOSE

CLOSE

## Lean Six Sigma

Charts & Templates

in QI Macros

Most Popular Charts

Lean Tools

Improvement Tools

Diagrams

DOE, Gage RR, FMEA

Formulas | Calculators

Planning | PM Tools

Chart Templates

Lean Six Sigma Quick Reference Card

CLOSE

FREE 30-day Trial” >

## Lean Six Sigma

Charts & Templates

in QI Macros

Most Popular Charts

Lean Tools

Improvement Tools

Diagrams

DOE, Gage RR, FMEA

Formulas | Calculators

Planning | PM Tools

Chart Templates

Lean Six Sigma Quick Reference Card

**QI Macros Reviews **

CNET Five Star Review

Industry Leaders

Our Customers

# Stem and Leaf Plot – Excel Template

## What is a Stem and Leaf Plot?

A stem and leaf plot shows the spread and distribution of a data set:

**Stems**represent the first digits of the data points**Count**represents 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

### Stem and Leaf Plot Example Created Using QI Macros add-in for Excel

**It’s Super Easy to Use QI Macros Stem and Leaf Plot Maker**

QI Macros installs a new menu on Excel’s Toolbar. To generate a plot:

- Open the
**Stem and Leaf Plot Template**by clicking on QI Macros menu / Chart Templates / Stem and Leaf Plot - Input or cut and paste your data into the yellow input area.
- Double click on the update plot button and QI Macros will sort the data and populate the stems and leaves.

### Why Would I Use a Stem and Leaf Plot?

A stem and leaf plot can help show the distribution of your data. It is similar to a histogram that is turned on its side. Let’s use the average temperature data from the above example to better illustrate the relationship.

**Stem and Leaf Plot Results**

**Rotate Results**

**Histogram of the Same Data**

Bin width = 10

Many people use stem and leaf plots because histograms seem too hard to create. But both are easy to make using QI Macros.

### Learn More …

- Back to Back Stem and Leaf Plot
- Tornado Chart
- Histogram with Cp and Cpk

### QI Macros Add-in for Excel – PC and Mac Compatible

### Affordable

- Only
**$249 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

FREE 30-day Trial”>Download Free QI Macros Trial

- Home
- About Us
- Store

- QI Macros SPC Software for Excel
- in Seconds

FREE 30-day Trial” title=”Free QI Macros Trial”>Free 30 Day Trial - On-line Tech Support

- QI Macros Reviews
- SPC Software Comparison
- Free QI Macros Training

- Contact Us
- Sitemap
- Google+

**KnowWare International, Inc.**

2696 S. Colorado Blvd., Ste. 555

Denver, CO 80222 USA

Toll-Free: 1-888-468-1537

Local: (303) 756-9144

©

2018 KnowWare International Inc. All Rights Reserved. Legal Info | Terms of Use

Reliable Six Sigma & SPC Excel Add-in

- Home
- Contact
- 888-468-1537

**My Cart**

*0*

- 888-468-1537

- Why QI Macros
- About Us
- Our Customers
- Customer Testimonials and Reviews
- SPC Software for Excel
- SPC Software Comparison
- Hassle Free Guarantee

- Key Tools
- Control Chart
- Histogram with Cp Cpk
- Pareto Chart
- Box and Whisker Plot
- Lean Six Sigma Templates
- Fishbone Diagram
- Gage R&R MSA
- Data Mining Tools
- Statistical Analysis

- Training
- Free Yellow Belt Training
- Free White Belt Training
- Free QI Macros Training Resources
- Free QI Macros & Six Sigma Webinars
- Free Excel Training Videos
- QI Macros & Excel One-Day Workshop
- Lean Six Sigma "Lite" Yellow Belt

- Services
- Lean Six Sigma Consulting
- Lean Six Sigma Coaching
- What is Lean Six Sigma?
- Do-It-For-Me Data Analysis
- Certification

- Support
- Tech Support
- Purchasing Info and W9
- QI Macros FAQs
- Upgrade History
- Submit Enhancement Request

- FREE Resources
- QI Macros How To Articles
- Excel Tips and Tutorials
- Breakthrough Improvement
- Lean Six Sigma Articles
- Lean Six Sigma White Papers
- KnowWare Articles
- Partners / Lean Six Sigma Links
- News and Media
- Blog

- Store
- QI Macros Software
- QI Macros Quantity Discounts
- Chart Templates for Excel
- Lean Six Sigma Books & Whitepapers
- KnowWare Products

- Order Now

CLOSE

CLOSE

## Lean Six Sigma

Charts & Templates

in QI Macros

Most Popular Charts

Lean Tools

Improvement Tools

Diagrams

DOE, Gage RR, FMEA

Formulas | Calculators

Planning | PM Tools

Chart Templates

Lean Six Sigma Quick Reference Card

CLOSE

FREE 30-day Trial” >

## Lean Six Sigma

Charts & Templates

in QI Macros

Most Popular Charts

Lean Tools

Improvement Tools

Diagrams

DOE, Gage RR, FMEA

Formulas | Calculators

Planning | PM Tools

Chart Templates

Lean Six Sigma Quick Reference Card

**QI Macros Reviews **

CNET Five Star Review

Industry Leaders

Our Customers

# Stem and Leaf Plot – Excel Template

## What is a Stem and Leaf Plot?

A stem and leaf plot shows the spread and distribution of a data set:

**Stems**represent the first digits of the data points**Count**represents 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

### Stem and Leaf Plot Example Created Using QI Macros add-in for Excel

**It’s Super Easy to Use QI Macros Stem and Leaf Plot Maker**

QI Macros installs a new menu on Excel’s Toolbar. To generate a plot:

- Open the
**Stem and Leaf Plot Template**by clicking on QI Macros menu / Chart Templates / Stem and Leaf Plot - Input or cut and paste your data into the yellow input area.
- Double click on the update plot button and QI Macros will sort the data and populate the stems and leaves.

### Why Would I Use a Stem and Leaf Plot?

A stem and leaf plot can help show the distribution of your data. It is similar to a histogram that is turned on its side. Let’s use the average temperature data from the above example to better illustrate the relationship.

**Stem and Leaf Plot Results**

**Rotate Results**

**Histogram of the Same Data**

Bin width = 10

Many people use stem and leaf plots because histograms seem too hard to create. But both are easy to make using QI Macros.

### Learn More …

- Back to Back Stem and Leaf Plot
- Tornado Chart
- Histogram with Cp and Cpk

### QI Macros Add-in for Excel – PC and Mac Compatible

### Affordable

- Only
**$249 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

FREE 30-day Trial”>Download Free QI Macros Trial

- Home
- About Us
- Store

- QI Macros SPC Software for Excel
- in Seconds

FREE 30-day Trial” title=”Free QI Macros Trial”>Free 30 Day Trial - On-line Tech Support

- QI Macros Reviews
- SPC Software Comparison
- Free QI Macros Training

- Contact Us
- Sitemap
- Google+

**KnowWare International, Inc.**

2696 S. Colorado Blvd., Ste. 555

Denver, CO 80222 USA

Toll-Free: 1-888-468-1537

Local: (303) 756-9144

©

2018 KnowWare International Inc. All Rights Reserved. Legal Info | Terms of Use