Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to draw a box chart in Excel, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

This paper introduces a graph used to observe the sequence-box diagram (also known as box chart). # make a form #

Applicable scenarios for box diagrams

Box chart is suitable for displaying sequential data, through which we can observe the concentration trend and discreteness of sequential data.

A box chart is a graph composed of five statistics: maximum, minimum, median, upper quartile and lower quartile. Next, we use a box chart to show the student performance data of the following students:

The box diagram is shown in the following figure:

It can be seen that a total of 6 data and 5 line segments are shown in the box chart. Next, we will explain what they represent in turn.

"maximum and minimum": in Excel, the maximum and minimum values in a box chart actually refer to the maximum and minimum values after removing the abnormal values, and then use them as the upper and lower boundaries of the overall graph.

There is also a box diagram in which the upper and lower boundary lines of the graph are represented by the boundary lines that distinguish the outliers. At this point, the upper and lower boundary line is also called the outlier cutoff point, which is calculated as follows:

Upper outlier cut-off point = upper quartile + 1.5*IQR (IQR is quartile difference)

Lower outlier truncation point = lower quartile-1.5*IQR (IQR is quartile difference)

Therefore, the point outside the cutoff point of the outlier is the outlier, such as point 30 in the figure.

Median: the number that represents the trend position in the data set, indicating that most of the data are concentrated near which number, that is, the majority of students' scores are around 75.5.

Quartile difference (IQR): IQR = Q3 (upper quartile)-Q1 (lower quartile).

The quartile represents the degree of discretization of 50% of the data in the middle of a set of data, through which we can measure the representativeness of the median. If the IQR is large, the middle 50% of the data is relatively scattered, and the median representation is not good; if the IQR is small, the middle 50% of the data is relatively concentrated, and the median representation is better.

In addition, we can also observe the overall dispersion of the data through the overall length of the graph, that is, the range.

So, how to draw a box diagram?

Drawing Box Diagram with Excel

Next, let's take a look at how to draw a box diagram in Excel:

The Excel box chart also marks the average of this set of data by default, so the distribution of the data can also be judged by the relative position of the average and the median. If the average is above the median, the data is deviated to the right; if the average is below the median, the data is deviated to the left.

In this group of data, because Xiao Qian's score is only 30, it is an outlier in this group of data, which leads to the left deviation of the data, that is, "pull down the average score!"

Thank you for reading this article carefully. I hope the article "how to draw a Box Diagram in Excel" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.