How To Draw Box Plot In Excel

Download Article

Download Article

A box and whisker plot is a diagram that shows the statistical distribution of a prepare of data. This makes it easy to see how data is distributed along a number line, and information technology's easy to make one yourself!

Steps Download Commodity

1. i

   Gather your data. Let's say nosotros start the numbers 1, iii, ii, four, and v. These will exist used for adding examples.

2. 2

   Organize the data from least to greatest. Take all your numbers and line them up in guild, so that the smallest numbers are on the left and the largest numbers are on your correct. In our case, the order of the numbers is 1, ii, three, 4, and five.^[1]

   Advertisement

3. 3

   Find the median of the information set. The median is the middle number in the information set when the data set is written from least to greatest. (This is why we lined up all the numbers in Step two.) For the data set in our instance, three is the number that'due south exactly in the eye, and therefore is our median. The median is too chosen the 2d quartile.^[2]

   • In a data set with an odd amount of numbers, the median volition e'er accept the aforementioned amount of numbers on either side of it. For the information set one, ii, iii, 4, 5, the median number, 3, has two numbers before information technology and 2 numbers after it. That's how we can be certain that information technology's our median.
   • What if the information set yous're working with has an even amount of numbers? What if you had to find the median of ii, iv, 4, 7, 9, x, fourteen, 15? Yous find the median here by taking the two heart numbers and finding their average. In our example, y'all would take 7 and 9 — the two heart numbers — add them up and divide them by 2. 7 + 9 equals sixteen, and 16 divided past 2 equals eight. The median of this data set would exist 8.

4. 4

   Detect the first and tertiary quartiles. We've already found the second quartile of the data fix, which is our median. At present we need to find the median of the lower half of the information set; in our example information technology would exist the median of the two numbers to the left of 3. The median of ane and two is (i + 2) / 2 = i.five. Practice the same to notice the median of the 2 numbers to the right of 3. (4 + 5) / 2 = 4.v.^[3]

5. 5

   Draw a plot line. This should be long plenty to contain all of your data, plus a little extra on either side. Brand sure to identify the numbers at even intervals. If you're dealing with decimals, such as 4.5 and 1.5, be sure to label them also.

6. 6

   Mark your first, second, and tertiary quartiles on the plot line. Take the values of your outset, second, and tertiary quartiles and make a marking at those numbers on the plot line. The marking should exist a vertical line at each quartile, starting slightly above the plot line.^[4]

7. seven

   Make a box by cartoon horizontal lines connecting the quartiles. Connect the top or the first quartile to the tiptop of the third quartile, going through the second quartile. Connect the bottom of the showtime quartile to the bottom of the third quartile, making sure to get through the 2d quartile.^[v]

8. 8

   Mark your outliers. Observe the smallest, and so the largest, numbers in your data set and mark them on the plot line. Marker these points with a small dot. In the case of our example, the lower outlier is ane and the upper outlier is v.^[six]

9. 9

   Connect your outliers to the box with a horizontal line. The direct line that connects the outliers is informally called the "whiskers" of the box and whiskers plot.

10. 10

    Finished. Expect at a box and whiskers plot to visualize the distribution of numbers in whatsoever data set. You lot can easily run into, for instance, whether the numbers in the data set bunch more in the upper quartile by looking at the size of the upper box, likewise every bit the size of the upper whisker. Box and whisker plots are great alternatives to bar graphs and histograms.^[7]

    Advertisement

Add New Question

• Question

  How practice you know what the upper quadrant is?

  

  The upper quadrant would exist the prepare of numbers to the correct of your median, if they are in order from least to greatest.

• Question

  What if I take an even amount of numbers, and the two center numbers are the same?

  

  The median is the middle number or the average of the two numbers if you accept an even corporeality of numbers. If you lot have 2 that are the same, y'all practise not need to boilerplate since they are the same. If they weren't, yous would average the two to get the median.

• Question

  What'southward the lower extreme?

  

  The lower farthermost should be the lowest number in the data set, or the minimum number.

• Question

  What is the median for the set of numbers 0, 2, ,2 3, 4, 6, half-dozen, and 12?

  

  The information is ordered, then you just need to find the median or centre. When there is an fifty-fifty number of observations (data points), the middle is not necessarily part of the data set. That is the case here. Three and 4 are in the middle of the data set up simply the center point comes halfway between 3 and 4, so information technology would exist 3.5.

• Question

  What happens if the median of the first quartile is higher than your range of numbers?

  

  And so your starting time quartile is higher than your range. It doesn't make anything "happen". It doesn't thing either way, as range is non used when making a Box-and-Whisker Plot.

• Question

  If the same value is shown multiple times, do nosotros write information technology that number of times or just one time?

  

  Yous would write the number as many times as it occurs to make the results accurate.

• Question

  How to calculate the whisker in the box plot?

  

  The whisker is just the line that connects the two points on the side of your box, which are your highest and lowest number in your data set up.

• Question

  When I have an even number of data set, do I demand to include the median numbers?

  

  Yes, you just have to find the boilerplate of the two medians or centre numbers. For example, if the number set is {1,2,iii,4,5,5,6,viii}, then the two center numbers would be iv and five. Find the average of these two numbers to get the ultimate median of iv.5.

• Question

  I'1000 still dislocated nigh how to exercise these. Are they similar to histograms?

  

  No, they are not. A histogram us used to show frequency tabular array data. These plots are used to prove quartiles.

• Question

  How exercise I find the outlier of the plot?

  

  The outliers are merely the greatest and smallest numbers in the gear up.

Meet more answers

Ask a Question

200 characters left

Include your email address to get a bulletin when this question is answered.

Submit

Advertisement

Video

Thanks for submitting a tip for review!

Virtually This Article

Article Summary 10

To make a box and whisker plot, start by organizing the numbers in your data set from least to greatest and finding the median. Then, find the beginning quartile, which is the median of the starting time of the information set, and the 3rd quartile, which is the median of the end of the data ready. Once you've washed that, draw a plot line and marking the quartiles and the median on information technology. Finally, connect the quartiles and median with horizontal lines to make a box, so mark the outliers. To learn how to interpret a box and whisker plot, scroll downwardly!

Did this summary help you?

Thanks to all authors for creating a page that has been read 825,996 times.

Did this commodity help you?

Source: https://www.wikihow.com/Make-a-Box-and-Whisker-Plot

Posted by: carmichaelnower1967.blogspot.com

Share this post