Creating Stem-and-Leaf Plots in Excel 2007:-


Stem-and-leaf plots became popular in the 1980s as a means of showing frequency distributions. Figure (given below) shows two stem-and-leaf plots of the same dataset.



(A stem-and-leaf plot shows the distribution of numbers in a population.)

In both of the plots in the above Figure, the number to the left of the line indicates groups of 10. The marks to the right of the line indicate how many members of the population occur in that group. In the bottom chart, you can see that one member of the population fell in the 10–19 range, one in the 20–29 range, one in the 30–39 range, and eight in the 40–49 range.

You sometimes see plots such as the bottom plot in the above Figure on the Internet because it is easier to create that plot in Excel than to create the top one. The true stem-and-leaf plot appears at the top of the figure. In this version, the digits to the right of the line indicate the final digit in each member of the population. These numbers are always sorted. The first row in the chart with 1|9 indicates that the only member in the population between 10 and 19 is a single member at 19. The next row of 2|2 indicates that there is one member of the population in the 20s and that member is 22. The fourth row contains 4|44568889. This indicates 8 members of the population fell in the 40s. The members were 44, 44, 45, 46, 48, 48, 48, and 49.