Microsoft Office Tutorials and References

In Depth Information

**Creating a box plot**

Figure 8-47: Calculating the area under this curve requires

complex formulas.

Figure 8-48: Calculating the area under a sine curve, with varying numbers of

data points

Creating a box plot

A box plot (sometimes known as a
quartile plot
or a
box and whisker plot
) is often

used to summarize data. Figure 8-49 shows a box plot created for four groups of

data. Each group has a diagram, the height of which represents the numerical range

of the data (minimum and maximum values). The “boxes” represent the 25th

through the 75th percentile. The horizontal line inside the box is the median value

(or 50th percentile). This type of chart enables the viewer to make quick

comparisons among groups of data.