Source: Box Plot in Excel () How to Make Box Plot in Excel? (with an Example) You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked The five numbers represented by the boxplot: The whiskers’ ends depict the minimum and maximum.
The box of the boxplot shows first to the third quartile with a line at the second quartile i.e., median. These extended lines are called whiskers in the boxplot. Extended lines are drawn outside the first and third quartiles to depict the minimum and maximum.
In a boxplot, the numerical data is shown using five numbers as a summary: Minimum, Maximum, First Quartile, Second Quartile (Median), Third Quartile.īetween the first and third quartiles, a box is drawn along with an additional line that is drawn along the second quartile to mark the median. It indicates how the values in the dataset are spread out. A box plot in excel is a pictorial representation or a chart that is used to represent the distribution of numbers in a dataset.
