Box and whisker

One drawback of Microsoft Excel is that it does not have a function that easily allows for a box-and-whisker diagram to be generated. By ‘fudging’ together a stacked bar chart with error bars, this image was generated using Excel alone. The benefit is that I can just ‘copy and paste’ new data and the diagrams will update automatically.

I am pleased with the outcome, and the idea is that I will use it as the basis of a ‘starter’ in a lesson, as well as lessons in the future. However, I question whether the effort involved in achieving this is worthwhile.

I guess only time will tell how many times it is used.

Advertisements

Author: ttsjl

I'm short and need to put on some weight

1 thought on “Box and whisker”

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