Microsoft Office Tutorials and References

In Depth Information

**Analyzing Data with Percentiles and Bins**

Figure 9-20:

Preparing

to plot the

frequency

distribution.

Figure 9-21:

Displaying

a frequency

distribution

as a column

chart.

MIN and MAX

Excel has two functions — MIN and MAX — that return the lowest and

highest values in a set of data. These functions are simple to use. The functions

take up to 255 arguments, which can be cells, ranges, or values.

Figure 9-22 shows a list of home sales. What are the highest and lowest

values? Cell F4 displays the lowest price in the list of sales, with this formula:

=MIN(C4:C1000). Cell F6 displays the highest price with this formula:

=MAX(C4:C1000).