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, …