1. Editing methods
    Interactive editing  Selective editing  Macro editing  Aggregation method  Distribution method  Automatic editing 

2. See also

3. Notes

4. References

Editing methods

Interactive editing

The term interactive 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 edits during or after data entry, and if necessary to correct erroneous data immediately. 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

Interactive editing is a standard way to edit data. It can be used to edit both categorical and continuous data.^[3] Interactive editing reduces the time frame needed to complete the cyclical process of review and adjustment.^[4]

Selective editing

Selective editing is an umbrella term for several methods to identify the influential errors, ^[5] and outliers.^[6] 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 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.^[7]

Macro editing

There are two methods of macro editing:^[8]

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.^[9]

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.^[10]

Automatic editing

In automatic editing records are edited by a computer without human intervention^[11]. Prior knowledge on the values of a single variable or a combination of variables can be formulated as a set of edit rules which specify or constrain the admissible values

See also

• Data cleansing
• Data pre-processing
• Data wrangling

Notes

References

• The Return of the Condor Heroes (1998 TV series)
• The Return of the Devil's Son
• The Return of the Dove to the Ark
• The Return of the Fabulous Hofner Bluenotes
• The Return Of The Fabulous Hofner Blue Notes
• The Return of the Frog
• The Return of the G.O.A.T.
• The Return Of The Green Goblin
• The Return of the Hunters
• The Return of the King (1980)
• The Return of the King (2003 film)
• The Return of the Lloigor
• The Return of the Marvelettes
• The Return of The Marvelettes
• The Return of the Musketeers (2009)
• The Return of the Musketeers (film)
• The Return of the Musketeers, or The Treasures of Cardinal Mazarin
• The Return of the Prodigal Son
• The Return of the Prodigal Son (album)
• The Return of the Psychopath
• The Return of the Rat
• The Return of the Repressed: The John Fahey Anthology
• The Return of the Riddle Rider
• The Return of the Scarlet Pimpernel
• The return of the shadow