Learn data mining through Excel : a step-by-step approach for understanding machine learning methods
著者
書誌事項
Learn data mining through Excel : a step-by-step approach for understanding machine learning methods
(Books for professionals by professionals)
Apress, c2020
- : pbk
大学図書館所蔵 件 / 全1件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes index
内容説明・目次
内容説明
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
Who This Book Is For
Anyone who is interested in learning data mining or machine learning, especially data science visual learners and people skilled in Excel, who would like to explore data science topics and/or expand their Excel skills. A basic or beginner level understanding of Excel is recommended.
目次
Chapter 1: Excel and Data Mining
Chapter 2: Linear Regression
Chapter 3: K-Means Clustering
Chapter 4: Linear discriminant analysis
Chapter 5: Cross validation and ROC
Chapter 6: Logistic regression
Chapter 7: K-nearest neighborsChapter 8: Naive Bayes classification
Chapter 9: Decision Trees
Chapter 10: Association analysisChapter 11: Artificial Neural network
Chapter 12: Text Mining
Chapter 13: After Excel
「Nielsen BookData」 より