Use Excel to Create a Box and Whiskers Boxplot and 5 Number Summary

The charting tool in Excel makes creating a Boxplot very simple. It will also give you the 5 number summary: The Min, Max, and Quartiles 1, 2, and 3. And it will give you the Mean as an added bonus. This video is 3 minutes, but it takes about 30 seconds to create a Boxplot in Excel.