Data editing: Difference between revisions

Revision as of 13:45, 30 August 2020

Revision as of 20:16, 30 August 2020

Line 1:

'''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.<ref>[{{Cite web|url=http://www.unece.org/stats/editing.html |title=UNECE]}}</ref> Data editing can be performed manually, with the assistance of a computer or a combination of both.<ref>http{{Cite web|url=https://wwwwww150.statcan.gc.ca/n1/edu/power-pouvoir/ch3/editing-edition/5214781-eng.htm|title=Statistics: Power from Data! Data editing|website=www150.statcan.gc.ca}}</ref>

{{Cleanup bare URLs|date=August 2020}}

'''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.<ref>[http://www.unece.org/stats/editing.html UNECE]</ref> Data editing can be performed manually, with the assistance of a computer or a combination of both.<ref>http://www.statcan.gc.ca/edu/power-pouvoir/ch3/editing-edition/5214781-eng.htm</ref>

==Editing methods==

Line 11 ⟶ 10:

*Compare the respondent's data to data from similar respondents

*Use the subject matter knowledge of the human editor

Interactive editing is a standard way to edit data. It can be used to edit both [[categorical data|categorical]] and [[continuity (mathematics)|continuous]] data.<ref>Waal, Ton de et al. "Handbook of Statistical Data Editing and Imputation". Wiley publication, 2011,p.15.</ref> Interactive editing reduces the time frame needed to complete the cyclical process of review and adjustment.<ref name="auto1">{{Cite web|url=http://www.unece.org/fileadmininfo/DAM/stats/publications/editing/SDE1chAece-homepage.pdfhtml|title=UNECE Homepage|website=www.unece.org}}</ref>

===Selective editing===

Line 18 ⟶ 17:

*The critical stream

*The non-critical 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.<ref name="auto">Waal, Ton de et al. "Handbook of Statistical Data Editing and Imputation". Wiley publication, 2011,p.16.</ref>

===Macro editing===

There are two methods of macro editing:<ref>Waal, Ton de et al. name="Handbook of Statistical Data Editing and Imputationauto". Wiley publication, 2011,p.16.</ref>

====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.<ref>http: name="auto1"//www.unece.org/fileadmin/DAM/stats/publications/editing/SDE1chB.pdf</ref>

====Distribution method====