Book description
Use popular data mining techniques in Microsoft Excel to better understand machine learning methods.
Software tools and programming language packages take data input and deliver data mining results directly, presenting no insight on working mechanics and creating a chasm between input and output. This is where Excel can help.
Excel allows you to work with data in a transparent manner. When you open an Excel file, data is visible immediately and you can work with it directly. Intermediate results can be examined while you are conducting your mining task, offering a deeper understanding of how data is manipulated and results are obtained. These are critical aspects of the model construction process that are hidden in software tools and programming language packages.
This book teaches you data mining through Excel. You will learn how Excel has an advantage in data mining when the data sets are not too large. It can give you a visual representation of data mining, building confidence in your results. You will go through every step manually, which offers not only an active learning experience, but teaches you how the mining process works and how to find the internal hidden patterns inside the data.
What You Will Learn
- Comprehend data mining using a visual step-by-step approach
- Build on a theoretical introduction of a data mining method, followed by an Excel implementation
- Unveil the mystery behind machine learning algorithms, making a complex topic accessible to everyone
- Become skilled in creative uses of Excel formulas and functions
- Obtain hands-on experience with data mining and Excel
Table of contents
- Cover
- Front Matter
- 1. Excel and Data Mining
- 2. Linear Regression
- 3. K-Means Clustering
- 4. Linear Discriminant Analysis
- 5. Cross-Validation and ROC
- 6. Logistic Regression
- 7. K-Nearest Neighbors
- 8. Naïve Bayes Classification
- 9. Decision Trees
- 10. Association Analysis
- 11. Artificial Neural Network
- 12. Text Mining
- 13. After Excel
- Back Matter
Product information
- Title: Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods
- Author(s):
- Release date: June 2020
- Publisher(s): Apress
- ISBN: 9781484259825
You might also like
book
Intro to Python for Computer Science and Data Science: Learning to Program with AI, Big Data and The Cloud
This is the eBook of the printed book and may not include any media, website access …
book
Excel 2019 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to …
book
Analytical Skills for AI and Data Science
While several market-leading companies have successfully transformed their business models by following data- and AI-driven paths, …
book
Storytelling with Data: A Data Visualization Guide for Business Professionals
Don't simply show your data—tell a story with it! Storytelling with Data teaches you the fundamentals …