datasmells
datasmells copied to clipboard
Outliers
Description of Error: Data can have legit outliers, but sometimes it's more nefarious. Check yourself before you wreck yourself.
Things to look for: Sort or order all applicable fields. Double-check the veracity of any super-high or super-low numbers. Call to confirm with your data source if needed. Related: are there any negative values? This can indicate an import or calculation error. Calculate average and standard deviation of fields and inspect any values that aren't within two or three standard deviations.
Examples: