Chart tools Design tab > Char Layouts section > Add Chart Element > Legend….Turn on the legend to label your data sets.Chart tools Design tab > Chart Layouts section > Add Chart Element > Axis > Primary Horizontal.Turn off or delete the x values for the horizontal axis.Change the text to the units of your data, eg, seconds, cm….Chart tools Design tab > Char Layouts section > Add Chart Element > Axis Titles > Primary Vertical.

Click on it and replace the text with a meaningful description.

Inert tab > Charts section > Recommended Charts > All Charts tab > Box & Whisker.

TIP: Include the column headers and Excel will use these when you add a legend later on.

Select the two or more side-by-side columns of data that you want to plot on the same chart.

Here are the instructions for both the online and offline versions of Excel: Offline (You’ll probably miss LOTS of marks if you use only this technique.) There is a way to create horizontal box plots in Excel from the five-number summary, but it takes longer. If you need the summary statistics in a hurry, paste your data in this statistical calculator to get all the important stuff instantly. Older versions don’t have any box and whisker plot feature. Microsoft Excel 2016 and Excel Online will automatically draw vertical parallel box plots from your raw data. REMEMBER: To demonstrate that you know what the software is doing for you automatically, assignments usually ask you to show the working out for the five-number summary for at least one of your data sets. Some software makes box plots from your original data, like Microsoft Excel as I’ll describe below, while others ask for the five-number summary (Min, LQ, Median, UQ, Max).

Here are great explanations, advantages and limitations of measures of central tenancy.

Here’s an example of how to compare box plots and other types of charts.

Check out these couple of pages and you’ll have a much better idea of what to say about your graphs.

Some software also places a cross on the chart where the mean/average is.Īfter you prepare your box plots you’ll no doubt have to write about them. These five points make up the “five-number summary”. Here’s a quick explanation of why box and whisker plots are useful. Box and Whisker Plots, or just Box Plots, are a graphical summary of data spread (dispersion) and central tendency.

Excel box and whisker 2016