How do you solve a box and whisker plot problem

Order the data from least to greatest. Find the median or middle value that splits the set of data into two equal groups. If there is no one middle value, use the average of the two middle values as the median. Find the median for the lower half of the data set.

How do you calculate box plot whiskers?

The box in the box plot will show the median and the first and third quartiles. The length of the upper whisker is the largest value that is no greater than the third quartile plus 1.5 times the interquartile range. In this case, the third quartile plus 1.5 times IQR is 10 + 1.5*6 = 19.

How do you explain a box and whisker plot?

A box and whisker plot is defined as a graphical method of displaying variation in a set of data. In most cases, a histogram analysis provides a sufficient display, but a box and whisker plot can provide additional detail while allowing multiple sets of data to be displayed in the same graph.

How do you complete a box plot?

The five-number summary is the minimum, first quartile, median, third quartile, and maximum. In a box plot, we draw a box from the first quartile to the third quartile. A vertical line goes through the box at the median. The whiskers go from each quartile to the minimum or maximum.

How do you do a box plot in math?

Start by plotting points over the number line at the lower and upper extremes, the median, and the lower and upper quartiles. Next, construct two vertical lines through the upper and lower quartiles, and then constructing a rectangular box that encloses the median value point.

What does box plot tell you?

A boxplot is a standardized way of displaying the distribution of data based on a five number summary (“minimum”, first quartile (Q1), median, third quartile (Q3), and “maximum”). … It can also tell you if your data is symmetrical, how tightly your data is grouped, and if and how your data is skewed.

How do you report box plot results?

  1. Step 1: Assess the key characteristics. Examine the center and spread of the distribution. …
  2. Step 2: Look for indicators of nonnormal or unusual data. Skewed data indicate that data may be nonnormal. …
  3. Step 3: Assess and compare groups. If your boxplot has groups, assess and compare the center and spread of groups.

How do you make a two box and whisker plot in Excel?

  1. Select the two or more side-by-side columns of data that you want to plot on the same chart.
  2. Inert tab> Charts section> Other Charts > Box and Whisker.
  3. Change the Chart title.
  4. You might want to add an axis tile, legend and data labels. Make sure you have the chart selected (click on it) Chart tools > Chart > Labels.

How do you make a box and whisker plot from a data set?

To create a box-and-whisker plot, we start by ordering our data (that is, putting the values) in numerical order, if they aren’t ordered already. Then we find the median of our data. The median divides the data into two halves. To divide the data into quarters, we then find the medians of these two halves.

How do you calculate Q2?

Formula for Middle quartile (Q2) = N + 1 multiplied by (2) divided by (4) Formula for Upper quartile (Q3) = N + 1 multiplied by (3) divided by (4) Formula for Interquartile range = Q3 (upper quartile) – Q1 (lower quartile)

Article first time published on

How do you make a box and whisker plot on word?

  1. On the Insert tab, in the Illustrations group, click Chart.
  2. In the Insert Chart dialog box, on the All Charts tab, click Box & Whisker.

How do you make a box and whisker plot in Excel 2019?

Select the Insert tab. Select Recommended Charts in the Charts group (or select the dialog box launcher in the lower-right corner of the charts group) to open the Insert Chart dialog box. Select the All Charts tab in the Insert Chart dialog box. Select Box and Whisker and choose OK.

How do you make a side-by-side box plot?

  1. Next, highlight cells A1:C21.
  2. Next, click the Insert tab along the top ribbon. …
  3. Next, click All Charts and then click Box & Whisker. …
  4. The following side-by-side boxplots will automatically appear:
  5. Then click the green plus “+” sign in the top right corner of the plot.

How do I change the direction of a bar chart in Excel?

  1. Click on the chart to see Chart Tools on the Ribbon.
  2. Select the Format tab.
  3. Go to the Chart Elements drop down list and pick Vertical (Value) Axis.
  4. Click the Format Selection button to see the Format Axis window.
  5. On the Format Axis window tick the Values in reverse order checkbox.

How do you find the 75th percentile in a box and whisker plot?

  1. Draw a rectangular box whose bottom is the lower quartile (25th percentile) and whose top is the upper quartile (75th percentile).
  2. Draw a horizontal line segment inside the box to represent the median.
  3. Extend horizontal line segments (“whiskers”) from each end of the box out to the most extreme observations.