![blank costume plot template blank costume plot template](https://i.pinimg.com/736x/6a/29/55/6a2955e0a4675862936245a4942feac9--theatre-charts.jpg)
Find the third quartile, Q 3, using =QUARTILE( range,3) or =PERCENTILE( range,0.75).Find the median, Q 2, using =MEDIAN( range) or QUARTILE( range,2) or =PERCENTILE( range,0.5).Find the first quartile, Q 1, using =QUARTILE( range,1) or =PERCENTILE( range,0.25).You may want to check out my article on percentiles for more details about how percentiles are calculated.
![blank costume plot template blank costume plot template](https://i.pinimg.com/originals/24/4d/be/244dbec39a2d4713cecb1fb00db8eea8.jpg)
The upper edge of the box plot is the third quartile or 75th percentile. The lower edge of the box plot is the first quartile or 25th percentile. The box part of a box and whisker plot represents the central 50% of the data or the Interquartile Range (IQR). An example box and whisker plot from the Box Plot Template showing the IQR, whiskers, and max/min outliers.