Use popular data mining techniques in Microsoft Excel to better understand machine learning methods. Most 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, and this book will show you exactly how.
This updated edition demonstrates how to work with data in a transparent manner using Excel. When you open an Excel file, data is visible immediately and you can work with it directly. You’ll see how to examine intermediate results even as you are still 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 often hidden in software tools and programming language packages.
Over the course of Learn Data Mining Through Excel, you will learn the data mining advantages the application offers when the data sets are not too large. You’ll see how to use Excel’s built-in features to create visual representations of your data, enabling you to present your findings in an accessible format. Author Hong Zhou walks you through each step, offering not only an active learning experience, but teaching you how the mining process works and how to find hidden patterns within the data.
pon completing this book, you will have a thorough understanding of how to use an application you very likely already have to mine and analyze data, and how to present results in various formats.
Author(s): Hong Zhou
Edition: 2
Publisher: Apress
Year: 2023
Language: English
Pages: 289
Table of Contents
About the Author
About the Technical Reviewer
Chapter 1: Excel and Data Mining
Why Excel?
Why the Second Edition?
Prepare Some Excel Skills
Formula
Autofill or Copy
Absolute Reference
Paste Special and Paste Values
IF Function Series
Reinforcement Exercises
Review Points
Chapter 2: Linear Regression
General Understanding
Learn Linear Regression Through Excel
Learn Multiple Linear Regression Through Excel
Reinforcement Exercises
Review Points
Chapter 3: K-Means Clustering
General Understanding
Learn K-Means Clustering Through Excel
Reinforcement Exercises
Review Points
Chapter 4: Linear Discriminant Analysis
General Understanding
Solver
Learn LDA Through Excel
Reinforcement Exercises
Review Points
Chapter 5: Cross-Validation and ROC
General Understanding of Cross-Validation
Learn Cross-Validation Through Excel
General Understanding of ROC Analysis
Learn ROC Analysis Through Excel
Reinforcement Exercises
Review Points
Chapter 6: Logistic Regression
General Understanding
Learn Logistic Regression Through Excel
By Means of Maximizing Log Likelihoods
By Means of Minimizing Log Losses
Reinforcement Exercises
Review Points
Chapter 7: K-Nearest Neighbors
General Understanding
Learn K-NN Through Excel
Experiment 1
Experiment 2
Experiment 3
Experiment 4
Reinforcement Exercises
Review Points
Chapter 8: Hierarchical Clustering and Dendrogram
General Understanding
Draw a Dendrogram in Excel Without Add-ins
Learn Hierarchical Clustering Through Excel
Reinforcement Exercises
Review Points
Chapter 9: Naive Bayes Classification
General Understanding
Learn Naïve Bayes Through Excel
Exercise 1
Exercise 2
Reinforcement Exercises
Review Points
Chapter 10: Decision Trees
General Understanding
Learn Decision Trees Through Excel
Learn Decision Trees Through Excel
A Better Approach
Apply the Model
Reinforcement Exercises
Review Points
Chapter 11: EDA, Data Cleaning, and Feature Selection
Learn Exploratory Data Analysis Through Excel
Learn Data Cleaning Through Excel
Feature Selection
Normalization and Standardization
Correlation
Learn Feature Selection Through Excel
Reinforcement Exercises
Review Points
Chapter 12: Association Analysis
General Understanding
Learn Association Analysis Through Excel
Reinforcement Exercises
Review Points
Chapter 13: Artificial Neural Network
General Understanding
Learn Neural Network Through Excel
Experiment 1
Experiment 2
Reinforcement Exercises
Review Points
Chapter 14: Text Mining
General Understanding
Learn Text Mining Through Excel
Word Embedding and ChatGPT
Reinforcement Exercises
Review Points
Chapter 15: After Excel
Index
df-Capture.PNG
