You have no doubt heard of histograms but how about a rootogram? Thought not! Well, when I finally get to finish Excel 2007 with Excel Master, you can read about them and learn how to generate them.

In short, though, a rootogram is a histogram with one difference: instead of having the count or frequency on the vertical axis, it has the square root of the frequency on the vertical axis.

The book explains why we might need to put the square root data on the vertical axis of course but in the meantime, here is a graphic showing the difference between a histogram and a rootogram:


Then there are hanging rootograms.

With baited breath you will be waiting for the publication of Excel 2007 with Excel Master.

Duncan Williamson

Leave a Reply

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

You are commenting using your 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: