Anomalies in Excel data

If you have data kept in your Excel spreadsheets, and if you want to detect for anomalies in these data, what do you do?

Manually, we do sample the data and derive a set of rules to filter out data that do not agree with our manually-crafted rules. However, if there are too many criterias to be considered, the rules might become complex.

A possible way to solve this is to make use of the Decision Trees (which I will discuss in a later article).

Bogdan Crivat and Jamie MacLennan have an excellent article here.

Check out
http://techadvisor.info/doc/14413