Box and whisker chart

- [Man] We're looking at a worksheet called box and whisker. … This is on our chapter seven exercise file. … That's an unusual name, … but it's a valuable chart. … And on this worksheet, … we see data in columns A, B, and C. … We've got sales persons in four major states here. … And they're sorted by I.D. number. … The statistics we see in columns E through I … are valuable. … We don't truly need these here, … but it's going to help us explain how to read … a box and whisker chart. … We'll click within the data over in the left hand side. … It is surrounded by empty cells, … so we don't have to highlight it. … And we'll simply, on the insert tab, … go to the histogram icon, … this is a statistical type cart, … and there's box and whisker. … We see the preview below. … Use this chart type to display variation … within a set of data. … And because I do have the data up there, … I want to line up these images … with the data above. … And again, I remind us, and again I'll say … we don't really need to have those statistics there, …