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.

stem_leaf_1

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

stem_leaf_2

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

stem_leaf_3a

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

stem_leaf_3b

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

stem_leaf_4

All of this uses some not very clever IF statements!

Looks fine though!

Duncan Williamson

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: