The data mining plugin for Microsoft Excel provides us with the ability to build a data mining model and handle a wide range of data from various data sources. The following are a few features provided by this add-in:
Analyze how values in a data column are influenced by values in all the other columns
Detect groups of rows with similar characteristics
Automatically populate a column with values based on a few examples you provide
Perform forecasting on a time series
Find rows that are unlike most other rows (interesting or anomalous)
Perform a scenario (goal-seeking or what-if) analysis
Create a powerful (yet easy-to-use) prediction calculator
Perform shopping basket analysis and identify cross-sales opportunities
The article at http://msdn.microsoft.com/en-in/library/dn282385.aspx provides more details about the data mining add-in for Excel. The link to download the data mining plugin for Excel 2007 is http://www.microsoft.com/en-us/download/details.aspx?id=7294...