Details

Learn Data Mining Through Excel


Learn Data Mining Through Excel

A Step-by-Step Approach for Understanding Machine Learning Methods

von: Hong Zhou

56,99 €

Verlag: Apress
Format: PDF
Veröffentl.: 13.06.2020
ISBN/EAN: 9781484259825
Sprache: englisch

Dieses eBook enthält ein Wasserzeichen.

Beschreibungen

<div><div><div><p>Use popular data mining techniques in Microsoft Excel to better understand machine learning methods.</p><p>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.<br></p><p>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.<br></p><p>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.<br></p><p><br></p><p><b>What You Will Learn</b><br></p></div><div><ul><li>Comprehend data mining using a visual step-by-step approach</li><li>Build on a theoretical introduction of a data mining method, followed by an Excel implementation</li><li>Unveil the mystery behind machine learning algorithms, making a complex topic accessible to everyone</li><li>Become skilled in creative uses of Excel formulas and functions</li><li>Obtain hands-on experience with data mining and Excel</li></ul></div><div><br></div></div></div><div><br></div><div><b>Who This Book Is For</b></div><div><br></div><div>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.&nbsp;</div><div><br></div><div><br></div>
<p>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 Neighbors.- Chapter 8: Naive Bayes Classification.- Chapter 9: Decision Trees.- Chapter 10: Association Analysis.- Chapter 11: Artificial Neural Network.- Chapter 12: Text Mining.- Chapter 13: After Excel.</p>
<div><b>Hong Zhou, PhD</b>&nbsp;is a professor of computer science and mathematics and has been teaching courses in computer science, data science, mathematics, and informatics at the University of Saint Joseph for more than 15 years. His research interests include bioinformatics, data mining, software agents, and blockchain.&nbsp;Prior to his current position, he was as a Java developer in Silicon Valley.&nbsp;Dr. Zhou believes that learners&nbsp;can develop a better foundation of data mining models when they visually experience them step-by-step, which is what Excel offers. He has employed Excel in teaching data mining and finds it an effective approach for both data mining learners and educators.<br></div><div><br></div>
<div><div><p>Use popular data mining techniques in Microsoft Excel to better understand machine learning methods.</p><p>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.<br></p><p>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.<br></p><p>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 ofdata 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.&nbsp;<br></p><p>What You Will Learn:<br></p></div><div><ul><li>Comprehend data mining using a visual step-by-step approach</li><li>Build on a theoretical introduction of a data mining method, followed by an Excel implementation</li><li>Unveil the mystery behind machine learning algorithms, making a complex topic accessible to everyone</li><li>Become skilled in creative uses of Excel formulas and functions</li><li>Obtain hands-on experience with data mining and Excel</li></ul></div><div>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.<br></div></div><div><br></div><div><b>Hong Zhou, PhD</b>&nbsp;is a professor of computer science and mathematics and has been teaching courses in computer science, data science, mathematics, and informatics at the University of Saint Joseph for more than 15 years. His research interests include bioinformatics, data mining, software agents, and blockchain.&nbsp;Prior to his current position, he was as a Java developer in Silicon Valley.&nbsp;Dr. Zhou believes that learners&nbsp;can develop a better foundation of data mining models when they visually experience them step-by-step, which is what Excel offers. He has employed Excel in teaching data mining and finds it an effective approach for both data mining learners and educators.<br></div>
Requires no additional Excel add-ins, and leverages Excel's built-in features Gives you a solid understanding of the popular data mining algorithms Presents a step-by-step approach to reinforce understanding

Diese Produkte könnten Sie auch interessieren:

Tuning the Snowflake Data Cloud
Tuning the Snowflake Data Cloud
von: Andrew Carruthers
PDF ebook
56,99 €
MLOps with Ray
MLOps with Ray
von: Hien Luu, Max Pumperla, Zhe Zhang
PDF ebook
62,99 €