22 IDEA Version Nine Tutorial
By default, the Field Statistics window displays the statistics for Numeric fields. In this case, field
statistics appear for the CREDIT_LIM field, the only Numeric field in the database.
To view field statistics for the Date fields and Time fields in a database, click Date and Time in
the Field Type area of the Field Statistics window. In the current database, there are no Date
or Time fields. If the database contained more than one Date, Numeric, or Time field, multiple
date, numeric, or time field statistics would appear together on the same screen for easy
comparison of values.
Study the field statistics for the CREDIT_LIM field.
View the record with the maximum value by clicking the value in the Maximum Value field.
The Maximum Value of CREDIT_LIM dialog box appears, displaying the record from the
database that constitutes the maximum value. You may save or print the record. Click Done.
In the Properties window, click Data to return to viewing the database.
Selecting a Random
Objective: To select a random sample of records for testing.
On the Analysis tab, in the Sample group, click Random.
In the Number of records to select box, enter 10.
Accept the random number seed provided by IDEA.
IDEA uses the random number seed to start the algorithm for calculating the random numbers.
If a sample needs to be extended, then entering the same random number seed but with a
larger sample size produces the same original selection plus the required additional records.
Accept the defaults in the Starting record number to select and the Ending record number
to select boxes.
IDEA sets the defaults as the first and last records; in this case 1 and 341.
Leave the Allow duplicate records check box unselected.