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)
Search JabSto ::




Custom Search