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