更新时间：2021-06-24 15:11:32
coverpage
Title Page
Copyright and Credits
Hands-On Machine Learning with Microsoft Excel 2019
Dedication
About Packt
Why subscribe?
Packt.com
Contributors
About the author
About the reviewer
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Reviews
Section 1: Machine Learning Basics
Implementing Machine Learning Algorithms
Technical requirements
Understanding learning and models
Learning by example – the linear regression model
Focusing on model features
Studying machine learning models in practice
Comparing underfitting and overfitting
Evaluating models
Analyzing classification accuracy
Building the confusion matrix
Calculating the Area Under Curve (AUC)
Calculating the Mean Absolute Error (MAE)
Calculating the Mean Squared Error (MSE)
Summary
Questions
Further reading
Hands-On Examples of Machine Learning Models
Understanding supervised learning with multiple linear regression
Understanding supervised learning with decision trees
Deciding whether to train outdoors depending on the weather
Entropy of the target variable
Entropy of each feature with respect to the target variable
Frequency table
Entropy calculation
Comparing the entropy differences (information gain)
Understanding unsupervised learning with clustering
Grouping customers by monthly purchase amount
Section 2: Data Collection and Preparation
Importing Data into Excel from Different Data Sources
Importing data from a text file
Importing data from another Excel workbook
Importing data from a web page
Importing data from Facebook
Importing data from a JSON file
Importing data from a database
Data Cleansing and Preliminary Data Analysis
Cleansing data
Visualizing data for preliminary analysis
Understanding unbalanced datasets
Correlations and the Importance of Variables
Building a scatter diagram
Calculating the covariance
Calculating the Pearson's coefficient of correlation
Studying the Spearman's correlation
Understanding least squares
Focusing on feature selection
Section 3: Analytics and Machine Learning Models
Data Mining Models in Excel Hands-On Examples
Learning by example – Market Basket Analysis
Learning by example – Customer Cohort Analysis
Implementing Time Series
Modeling and visualizing time series
Forecasting time series automatically in Excel
Studying the stationarity of a time series
