Data editing
 | This article, Data editing, has recently been created via the Articles for creation process. Please check to see if the reviewer has accidentally left this template after accepting the draft and take appropriate action as necessary.
Reviewer tools: Inform author |
Comment: MatthewVanitas (talk) 15:27, 9 June 2014 (UTC)
Statistical Data Editing
Data editing is defined as the process involving the review and adjustment of collected survey data. The purpose is to control the quality of the collected data.[1]
Editing Methods
Interactive editing
The term interractive editing is commonly used for modern computer-assisted manual editing. Most interactive data editing tools applied at 'National Statistical Institutes' (NSIs) allow one to check the specified editsduring or after data entry, and if necessary to correct erroneous data immediatedly. Several approaches can be followed to correct erroneous data:
- Recontact the respondent
- Compare the respondent's data to his data from previous year
- Compare the respondent's data to data from similar respondents
- Use the subject matter knowledge of the human editor
Interractive editing is a standard way to edit data. It can be used to edit both categorical and continuous data.[2]
Selective editing
Selective editing is an umbrella term for several methods to identify the influential errors, [note 1] and outliers [note 2]. Selective editing techniques aim to apply interactive editing to a well-chosen subset of the records, such that the limited time and resources available for interactive editing are allocated to those records where it has the most effect on the quality of the final estimates of publication figures. In selective editing, data is split into two streams
- The critical stream
- The noncritical stream
The critical stream consists of records that are more likely to contain influential errors. These critical records are edited in a traditional interactive manner. The records in the non critical stream which are unlikely to contain influential errors are not edited in a computer assisted manner.[3]
Macro editing
There are two forms of macro editing[4]
Aggregation method
This method is followed in almost every statistical agency before publication: verifying whether figures to be published seem plausible. This is accomplished by comparing quantities in publication tables with same quantities in previous publications. If an unusual value is observed, a micro-editing procedure is applied to the individual records and fields contributing to the suspicious quantity.
Distribution method
Data available is used to characterize the distribution of the variables. Then all individual values are compared with the distribution. Records containing values that could be considered uncommon (given the distribution) are candidates for further inspection and possibly for editing.
Automatic editing
In automatic editing records are edited by a computer without human intervention.[5]
Notes
References
- ^ UNECE
- ^ Waal, Ton de et al. "Handbook of Statistical Data Editing and Imputation". Wiley publication, 2011,p.15.
- ^ Waal, Ton de et al. "Handbook of Statistical Data Editing and Imputation". Wiley publication, 2011,p.16.
- ^ Waal, Ton de et al. "Handbook of Statistical Data Editing and Imputation". Wiley publication, 2011,p.16.
- ^ Waal, Ton de et al. "Handbook of Statistical Data Editing and Imputation". Wiley publication, 2011,p.16.