IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.

X
Icon


Blog Image

The Field Statistics Primer

Quick Reference Guide for Working with Numeric/Date/Time Field Stats


Although “Pop Kurtosis” sounds like it could be a music genre from the ’60’s, in IDEA it is one of the many statistics automatically calculated on your population in IDEA’s Field Statistics. Each of the IDEA field statistics is described in the IDEA help feature; but we’ve captured that information in these easy to reference tables for you.

Numeric Statistic Description
Net Value Total of the positive values minus the negative values in the field.
Absolute Value Total of the absolute of the values in the field.
# of Records Total number of records in the database.
# of Zero Items Number of records with a zero value in the field.
Positive Value Total of debit (positive) values in the field.
Negative Value Total of credit (negative) values in the field.
# of Positive Records Number of records with debit (positive) values in the field.
# of Negative Records Number of records with credit (negative) values in the field.
# of Data Errors Number of records with errors in the field.
# of Valid Values Total number of records minus the number of records with errors in the field.
Average Value Average of values, such as net value/number of records, in the field.
Minimum Value Lowest value in the field.
Maximum Value Highest value in the field.
Record # of Min Record number of the record that contains the minimum value in the field. If more than one record contains the minimum value, the record number of the first record that contains the minimum value in the field will be displayed.
Record # of Max Record number of the record that contains the maximum value in the field. If more than one record contains the maximum value, the record number of the first record that contains the maximum value in the field will be displayed.
Sample Std Dev A numeric value that represents the distribution of data in a selected sample.
Sample Variance A numeric value that indicates the dispersion of data around its mean value in a selected sample.
Pop Std Dev A numeric value that represents the distribution of the data.
Pop Variance A numeric value that indicates the dispersion of data around its mean value.
Pop Skewness A numeric value that indicates the asymmetry of the data.
Pop Kurtosis A numeric value that indicates the shape of the distribution of data values.

 

Date Statistic Description
# of Valid Values Total number of records minus the sum of number of records with errors in the field and number of records with zero values.
# of Zero Items Number of records with a zero value in the field.
# of Records Total number of records in the database.
# of Data Errors Number of records with errors in the field.
Earliest Date Earliest date in the field. useful for testing cut-off dates.
Latest Date Latest date in the field. useful for testing cut-off dates.
Record # of Earliest Record number of the record that contains the earliest date in the field. If more than one record contains the earliest date, the record number of the first record that contains the earliest date in the field will be displayed.
Record # of Latest Record number of the record that contains the latest date in the field. If more than one record contains the latest date, the record number of the first record that contains the latest date in the field will be displayed.
Most Common Day The day of the week that most frequently appears in the date values in the field.
Most Common Month The month that most frequently appears in the date values in the field.
Items in Month Number of records with values that contain the particular month.
Items on Day Number of records with values that contain the particular day of the week.

 

Time Statistic Description
# of Records Total number of records in the database.
# of Valid Values Total number of records minus the sum of number of records with errors in the field and number of records with zero values.
# of Data Errors Number of records with errors in the field.
# of Zero Items Number of records with a zero value in the field.
Latest Time Latest time value in the field.
Earliest Time Earliest time value in the field.
Most Common Hour The hour that most frequently appears in the time values in the field.
Most Common Minute The minute that most frequently appears in the time values in the field.
Most Common Second The second that most frequently appears in the time values in the field.
# of Records in AM The number of records in the field that have a time value that falls before 12 noon.
# of Records in PM The number of records in the field that have a time value that falls after 12 noon.
# of Records Before 6 AM The number of records with a time value that falls before 06:00 in the morning.
# of Records After 6 PM The number of records with a time value that falls after 06:00 in the evening.
Average Time The average time value for the field.
# of Records Less Than a Day The number of records in the field that are less than 24 hours in duration.
# of Records More Than a Day The number of records in the field that are equal to or more than 24 hours in duration.

If you have questions about this or other IDEA functions, please give our help desk a call at 888-641-2800 Option 4. Or email us at [email protected]

 


CaseWare IDEA , Tech Tip



Posted By

By Danny Betancourt


Related Posts
Sharing IDEA Data Using IDEA's ODBC Driver
Jul 18 Importing data into IDEA is a popular topic. But sometimes, it might be useful to take those IDEA databases and work on them in another application such as Tabl...
Conducting Attribute Testing with Data Analysis Software
Oct 18 Question:   As an internal auditor, we are approached on a regular basis by software providers offering products that do not appear to have real differ...
Prime Areas for Fraud Schemes
Jul 20 Where to Look and How to Find Them Fraud is on the rise. And if you don’t know what fraud looks like, you’re not likely to find it. While most oc...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×