Microsoft Office Tutorials and References

In Depth Information

A workbook with this example is available at this book's website. The filename is box

plot.xlsx.

Figure 17-10:
This box plot summarizes the data in columns A through D.

Table 17-1: Formulas Used to Create a Box Plot

Cell

Calculation

Formula

G2

25th Percentile =QUARTILE(A2:A26,1)

G3

Minimum

=MIN(A2:A26)