Cleaning data and spreadsheets

Know why data may need to be ‘cleaned’ before further processing, including issues that arise on spreadsheets and apply techniques to clean data in context.

In the pre-processing stage: consideration of genuine and other outliers and anomalies, or removal of extraneous symbols or notation when using technology (e.g. spreadsheets or statistical software). See also 2c.03.