




At the end of this step, you will get the below result.In addition, use the cells to determine the differences according.At first, go to any blank ( in this case, Cell E5) and insert the following formula.Next, we want to create a box using the 5 sets of numbers. By the side of the Statistics and Differences columns we have the Value columns ( Column E and Column H) where the values will be input. In this dataset, we have Total Marks in Column B, Statistics in Column D, and Differences in Column G. To do so, we have to arrange a dataset first. If you follow the steps correctly, you should learn how to make a box plot in excel on your own. Step-by-Step Procedures to Make a Box Plot in Excel Maximum: It is the maximum number of the dataset.Third Quartile: It marks the 75th percentile of the dataset and stays in the middle of the median and maximum values of the dataset.Median (also known as the second Quartile): It is the 50th percentile of the dataset and stays in the middle.First Quartile: It is displayed as the 25th percentile of the dataset and It stays between a minimum value and the median of the dataset.Minimum: It indicates the smallest value in the dataset.The values in a vertical box are explained below. It mainly works with 5 sets of numbers: Minimum, First Quartile, Median (also known as the second Quartile), Third Quartile, and Maximum. It can be drawn vertically or horizontally. A box plot is a way of representing different numbers graphically.
