Summary and Info
A common problem that requires a data mining solution is anomaly detection - that is, finding those values that "do not fit" based on the patterns present in the rest of the data. You'll see how to solve this problem using SQL Server 2005 Data Mining for an Excel worksheet.This solution doesn't require any separate treatment of the data; it works directly in your workbook after a few mouse clicks. The code that accompanies this article is an Excel addinyou can install in Microsoft Excel and use for detecting anomalies in any Excel worksheet.
More About the Author
The Crivăț River is a left tributary of the river Ialomița in Romania. It discharges into the Ialomița in Crivățu.
Review and Comments
Rate the Book
Detect Anomalies in Excel Spreadsheets 0 out of 5 stars based on 0 ratings.