6.3. Excel 2007: Data Mining Analyze Tab, Analysis Tools
The Analyze tab is where most people will accomplish data mining within Excel. This is because the data mining tasks are fairly easy to use, and simply need an Excel table of data to work with. Both pattern analysis and predictive analysis can be done with these Analyze tasks, and they don't require any previous knowledge of data mining.
6.3.1. Excel Table: Analyze Key Influencers
Figure 6-5 shows how we start the Analyze Key Influencers data mining task. For reference purposes, this data mining tool uses the Microsoft Research Naïve Bayes algorithm, which calculates the conditional probability between a target column selected, and all other columns (obviously something we can't do manually!). ...
Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
