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

— —

Hong Zhou

Learn Data Mining Through Excel

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

Hong Zhou

$108.95 $97.84

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
02 October 2023

Microsoft programming; Data mining; Expert & knowledge-based systems

Use popular data mining techniques in Microsoft Excel to better understand machine learning methods. Most 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, and this book will show you exactly how.

This updated edition demonstrates how to work with data in a transparent manner using Excel. When you open an Excel file, data is visible immediately and you can work with it directly. You’ll see how to examine intermediate results even as you are still 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 often hidden in software tools and programming language packages.

Over the course of Learn Data Mining Through Excel, you will learn the data mining advantages the application offers when the data sets are not too large. You’ll see how to use Excel’s built-in features to create visual representations of your data, enabling you to present your findings in an accessible format. Author Hong Zhou walks you through each step, offering not only an active learning experience, but teaching you how the mining process works and how to find hidden patterns within the data.

Upon completing this book, you will have a thorough understanding of how to use an application you very likely already have to mine and analyze data, and how to present results in various formats.

What You Will Learn

Comprehend data mining using a visual step-by-step approach Gain an introduction to the fundamentals of data mining Implement data mining methods in Excel Understand machine learning algorithms Leverage Excel formulas and functions creatively 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.

By: Hong Zhou
Imprint: APress
Country of Publication: United States
Edition: 2nd ed.
Dimensions: Height: 254mm, Width: 178mm,
Weight: 574g
ISBN: 9781484297704
ISBN 10: 1484297709
Pages: 288
Publication Date: 02 October 2023
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

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: Naïve Bayes Classification.- Chapter 9: Decision Trees.- Chapter 10: Association Analysis.- Chapter 11: Artificial Neural Networks.- Chapter 12: Text Mining.- Chapter 13: Hierarchical Clustering and Dendrogram.- Chapter 14 Exploratory Data Analysis (EDA).- Chapter 15: After Excel.

Hong Zhou, PhD 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 nearly 20 years. His research interests include bioinformatics, data mining, software agents, and blockchain. Prior to his current position, he was as a Java developer in Silicon Valley. Dr. Zhou believes that learners 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.