A**stem-and-leaf plot**is a chart we deserve to use to screen data by splitting up each value in a dataset right into a*stem*and a*leaf*.

You are watching: Make a stem and leaf plot in excel

Here is an example of a stem-and-leaf plot because that a offered dataset, produced by thecivicpride-kusatsu.net Stem-and-Leaf Plot Generator:

The*stem*for each worth is merely the first digit that the worth while the*leaf*is the 2nd digit the the value.

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

**Example: Stem-and-Leaf Plot in Excel**

Use the adhering to steps to develop a stem-and-leaf plot in Excel.

**Step 1: get in the data.**

Enter the data worths in a solitary column:

**Step 2: recognize the minimum and maximum values.**

**Step 3: Manually get in the “stems” based on the minimum and maximum values.**

**Step 4: calculation the “leaves” for the an initial row.**

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

Once you complete typing the formula and click Enter, girlfriend will acquire the complying with result:

**Step 5: Repeat the calculation for each row.**

To repeat this calculation because that each row, simply click on cell D7, hover over the bottom-right hand corner of the cell till a tiny **+**appears, climate double-click. This will certainly copy the formula to the rest of the rows in the Stem-and-Leaf plot:

To double check that your outcomes are correct, you have the right to verify 3 numbers:

**Make certain the variety of individual “leaves” matches the number of observations.**In our example, we have actually 10 total “leaves” which matches the 10 monitorings in our original dataset.

**Verify the minimum number.**The very very first leaf should match the minimum value in your dataset. In our example, we check out that the very first leaf is “4” and is paired with a stem that “1” which matches the minimum variety of “14” in our dataset.

**Verify the best number.**The an extremely last leaf should complement the maximum worth in her dataset. In our example, we check out that the last leaf is “5” and also is paired through a stem of “3” which matches the minimum number of “35” in ours dataset.

See more: How Long Is The Flight From Phoenix To Sacramento, Ca, Flights From Sacramento To Phoenix

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

**Additional Resources**

An introduction to Stem-and-Leaf Plots**An arrival to back to back Stem-and-Leaf Plots**