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:

histo_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:

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: