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




Custom Search