#STEM AND LEAF PLOT GENERATOR HOW TO#

Verify the maximum number. The very last leaf should match the maximum 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 minimum number. The very first leaf should match the minimum value in your dataset.

In our example, we have 10 total “leaves” which matches the 10 observations in our original dataset.

Make sure the number of individual “leaves” matches the number of observations.

To double check that your results are correct, you can verify three numbers: This will copy the formula to the rest of the rows in the Stem-and-Leaf plot: 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. Step 5: Repeat the calculation for each row. Once you finish typing the formula and click Enter, you will get the following result: Don’t be intimidated by the length of the formula – it’s actually very simple, just repetitive.

#STEM AND LEAF PLOT GENERATOR HOW TO#

The following calculation shows how to compute the leaves for the first row.

Step 4: Calculate the “leaves” for the first row. Step 3: Manually enter the “stems” based on the minimum and maximum values. Step 2: Identify the minimum and maximum values. Use the following steps to create a stem-and-leaf plot in Excel.Įnter the data values in a single column: Now let’s find out how to create a stem-and-leaf plot in Excel. The stem for each value is simply the first digit of the value while the leaf is the second digit of the value. Here is an example of a stem-and-leaf plot for a given dataset, created by the Statology Stem-and-Leaf Plot Generator: A 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.

Stem and leaf plot generator