Database statistics simplified; the atD functions make short work of statistical calculations.

Database Statistics Simplified

When you store information in a 1-2-3 database, you can easily sort the information, find specific entries, or copy entries from the database. But that's not all you can do. Using the collection of database statistical @functions, or @D functions, you can calculate the sum, average, variance, standard deviation, maximum, minimum, and the total number of database entries.

These functions are similar to some of the standard @functions, sun as @SUM, @AVG, and @MIN. The critical difference is the @D functions let you specify the criteria that a record must meet in order to be included in the calculation.

For example , if you're working with a database of employee salaries, you might wish to sum the salaries of all employees in a particular department. Or in a database of sales revenues, you might calculate the average sales for a particular region or the lowest regional sales for a specific product. The @D functions handle these types of calculations.

A SAMPLE DATABASE

The @D functions are easiest to learn when you use them on an actual database. So before continuing, …