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.