Microsoft Office Tutorials and References
In Depth Information
Examples of Functions for Descriptive Statistics
Examples of Functions for Descriptive Statistics
Descriptive statistics help describe a population of data. What is the
largest? The smallest? The average? Are data points grouped to the left of
the average or to the right of the average? How wide is the range of expected
values? Do many members of the population have values in the middle, or
are they evenly spread throughout the range? All these are measures of de-
scriptive statistics.
Many situations in a business environment involve finding basic information
about a data set, such as the largest or smallest value or the rank within a
data set.
Using
Using MIN
MIN oor MAX
MAX to Find the Smallest or Largest Numeric Value
to Find the Smallest or Largest Numeric Value
If you have a large data set and want to find the smallest or largest value
in a column, rather than sort the data set, you can use a function to find the
value. To find the smallest numeric value, you use MIN. To find the largest
numeric value, you use MAX.
Figure 14.1 shows a list of open receivables, by customer, for 59 customers.
Even though the function references say that you can find the MIN for only
Search JabSto ::




Custom Search