Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods

This book explains popular data mining methods using examples in Excel. It starts with some necessary Excel skills in the first chapter and then introduces linear regression as the first data mining method, followed by k-means clustering, linear discriminant analysis, cross-validation, logistic regression, k-nearest neighbors, naïve Bayes classification, decision trees, association analysis, artificial neural network, and text mining. The book ends with a summary chapter. In each chapter except for the last one, fundamental mathematical knowledge regarding each mining method is explained first, followed by Excel examples (available at https://github.com/hhohho/LearnData-Mining-through-Excel) and step-by-step instructions showing how to complete the data mining task. Each chapter ends with a “Review Points” section that highlights the skills introduced in the chapter.