X
Audimation Services has been acquired by Caseware International Learn More.
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]
This website has been designed for modern browsers. Please update. Update my browser now