How to Create a Stem-and-Leaf Plot in Excel


stem-and-leaf plot is a chart we can use to display data by splitting up each value in a dataset into a stem and a leaf.

Here is an example of a stem-and-leaf plot for a given dataset, created by the Statology Stem-and-Leaf Plot Generator:

Stem-and-leaf plot example

The stem for each value is simply the first digit of the value while the leaf is the second digit of the value.

Now let’s find out how to create a stem-and-leaf plot in Excel.

Example: Stem-and-Leaf Plot in Excel

Use the following steps to create a stem-and-leaf plot in Excel.

Step 1: Enter the data.

Enter the data values in a single column:

Raw data in a single column in Excel

Step 2: Identify the minimum and maximum values.

Step 3: Manually enter the “stems” based on the minimum and maximum values.

Stem and leaf plot example in Excel

Step 4: Calculate the “leaves” for the first row.

The following calculation shows how to compute the leaves for the first row. Don’t be intimidated by the length of the formula – it’s actually very simple, just repetitive.

Stem and leaf plot calculation in Excel

Once you finish typing the formula and click Enter, you will get the following result:

Stem and leaf plot calculation in Excel

Step 5: Repeat the calculation for each row.

To repeat this calculation for each row, simply click on cell D7, hover over the bottom-right hand corner of the cell until a tiny appears, then double-click. This will copy the formula to the rest of the rows in the Stem-and-Leaf plot:

Stem and leaf plot example in Excel

To double check that your results are correct, you can verify three numbers:

  • Make sure the number of individual “leaves” matches the number of observations. In our example, we have 10 total “leaves” which matches the 10 observations in our original dataset.
  • Verify the minimum number. The very first leaf should match the minimum value in your dataset. In our example, we see that the first leaf is “4” and is paired with a stem of “1” which matches the minimum number of “14” in our dataset.
  • Verify the maximum number. The very last leaf should match the maximum value in your dataset. In our example, we see that the last leaf is “5” and is paired with a stem of “3” which matches the minimum number of “35” in our dataset.

Once you verify these three numbers, you can be confident that your Stem-and-Leaf plot is correct.

Leave a Reply

Your email address will not be published. Required fields are marked *