I don’t know anyone who uses stem and leaf diagrams or stem and leaf plots but they appear all over the place in statistics books and web sites. Today I read on twitter about stem and leaf diagrams and they said how difficult is to program them.

Now, I am not the world’s most astute Excel programmer but I had a go, with some success I have to say. Nevertheless, they are not easy to do in the sense that we cannot just drop the data onto a work sheet and expect a stem and leaf diagram to appear .

This is what I got:

A basic set of numbers to show quiz results for some students: a screenshot of the diagram on a web site on the right and my effort on the left of it.


The number of press ups (push ups) done by competitors in a press ups competition!


Now some data where there can be two results of any value: eg, 82 82 and 91 91 …


this diagram is based on specific data, so I have organised the numbers and then created the diagram


Finally, some data where there can be three results of any value


All of this uses some not very clever IF statements!

Looks fine though!

Duncan Williamson

2 Responses to “Stem and Leaf Diagrams”

  1. Hi there just wanted to give you a quick heads up. The words in your article seem to be running off the screen in Internet explorer. I’m not sure if this is a format issue or something to do with browser compatibility but I figured I’d post to let you know. The style and design look great though! Hope you get the issue fixed soon. Thanks

    • I was aware of that but I am not sure how to deal with it. Word Press customer support is not so good so it may be a while before I can sort it out.

      Thanks for telling me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: