Cargando…

Learn data mining through Excel : a step-by-step approach for understanding machine learning methods /

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. Th...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Zhou, Hong (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Berkeley, CA] : Apress, [2020]
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Intro
  • Table of Contents
  • About the Author
  • About the Technical Reviewer
  • Acknowledgments
  • Introduction
  • Chapter 1: Excel and Data Mining
  • Why Excel?
  • Prepare Some Excel Skills
  • Formula
  • Autofill or Copy
  • Absolute Reference
  • Paste Special and Paste Values
  • IF Function Series
  • Review Points
  • Chapter 2: Linear Regression
  • General Understanding
  • Learn Linear Regression Through Excel
  • Learn Multiple Linear Regression Through Excel
  • Review Points
  • Chapter 3: K-Means Clustering
  • General Understanding
  • Learn K-Means Clustering Through Excel
  • Review Points
  • Chapter 4: Linear Discriminant Analysis
  • General Understanding
  • Solver
  • Learn LDA Through Excel
  • 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
  • Review Points
  • Chapter 6: Logistic Regression
  • General Understanding
  • Learn Logistic Regression Through Excel
  • Review Points
  • Chapter 7: K-Nearest Neighbors
  • General Understanding
  • Learn K-NN Through Excel
  • Experiment 1
  • Experiment 2
  • Experiment 3
  • Experiment 4
  • Review Points
  • Chapter 8: Naïve Bayes Classification
  • General Understanding
  • Learn Naïve Bayes Through Excel
  • Exercise 1
  • Exercise 2
  • Review Points
  • Chapter 9: Decision Trees
  • General Understanding
  • Learn Decision Trees Through Excel
  • Learn Decision Trees Through Excel
  • A Better Approach
  • Apply the Model
  • Review Points
  • Chapter 10: Association Analysis
  • General Understanding
  • Learn Association Analysis Through Excel
  • Review Points
  • Chapter 11: Artificial Neural Network
  • General Understanding
  • Learn Neural Network Through Excel
  • Experiment 1
  • Experiment 2
  • Review Points
  • Chapter 12: Text Mining
  • General Understanding
  • Learn Text Mining Through Excel
  • Review Points
  • Chapter 13: After Excel
  • Index