Heres a list of steps on how to make a box and whisker plot in Excel: 1. How to make a box and whisker plot in Excel Any data points that lie beyond the whiskers are outliers of the data set. The whiskers are lines that extend to the smallest and largest values. The first and third quartiles make up the “box” element of a box and whisker plot, and the median represents a straight line thats somewhere in the middle of the box. These five numbers are the smallest value, first quartile, median, third quartile and largest value. Some other types of data that an individual may want to display using a box and whisker plot include: What is a box and whisker plot?Ī box and whisker plot is a graph that shows the skewness and locality of a data set by displaying its data in terms of five essential numbers. For example, a scientist may graph the results of a medical trial using this kind of plot. You may use this kind of plot to graph one data set, but a box and whisker plot is particularly beneficial when you have several data sets that relate to one another but come from independent sources. Its helpful to use box and whisker plots in many statistical applications. In Excel, click Insert > Insert Statistic Chart >Box and Whisker as shown in the following illustration.

Select your data-either a single data series, or multiple data series.If the data set is extremely large it may be easier if columns or rows are hidden). Use your mouse to select the data you want included (holding down the control key allows non-contiguous ranges of data to be selected. This tutorial will show you how to make and edit a Box and Whisker Chart in Excel How to Make a Box and Whisker chart in Excel Step 1: Select the data you want displayed in the Box and Whisker chart An outlier is a value that falls outside the expected range of values they usually appear as a singular dot on the chart. The whiskers are lines that extend from the boxes to the minimum and maximum values. The box shows the value of the first quartile at the bottom of the box, the value of the third quartile at the top of the box type of chart and the median value inside the box. The box and whisker chart graphically depicts numerical data through their statistical quartiles (minimum, first quartile, median, third quartile and maximum). The other two, Histogram and Pareto charts, have their own tutorial. The Box and Whisker chart is the third statistical chart included in the chart toolbox starting with Excel 2016. How to Make a Box and Whisker Chart in Excel

Excel box and whisker 2016