As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Guide on Constructing Box Plots Using Excel

A box plot, a visual representation that summarizes certain data statistics, is an excellent method for observing data distribution and identifying outliers. This guide illustrates how to craft a box plot in Excel.

Creating a Basic Box Plot

Begin by selecting your data set, either the entire set or a subset. Next, navigate to the "Insert" tab in Excel's ribbon and select "Insert Statistic Chart." In the "Choose a Statistic Chart" dialog box, opt for "Box Plot" and proceed by clicking "OK." Excel will generate the default box plot based on your selected data. To modify the data range or the appearance of the box plot, navigate through the "Format" menu.

Generating a Box Plot with Multiple Data Sets

For a box plot featuring multiple data sets, follow a different approach. After selecting your data, use the same steps to initiate the box plot. To add another dataset, access the "Format" menu, select "Series," and proceed to add more data using the "Add" button in the "Series" dialog box.

Constructing a Box Plot with a Logarithmic Scale

When aiming for a box plot with a logarithmic scale, the process alters slightly. After selecting your data, follow the steps to initiate the box plot. To change the scale to logarithmic, access the "Scale" menu and choose "Logarithmic" from the "Type" drop-down menu in the "Scale" dialog box.

Creating a Box Plot with a Customized Scale

For a box plot with a customized scale, the process differs. After data selection, initiate the box plot. To modify the scale, access the "Scale" menu, opt for "Custom" from the "Type" drop-down menu in the "Scale" dialog box. Then, input the desired values for "Minimum" and "Maximum" in the text boxes. If needed, assign values for "Major Unit" and "Minor Unit" for a logarithmic scale and click "OK" upon completion.