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

Zhou, Hong

商品描述

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.

 

商品描述(中文翻譯)

使用Microsoft Excel中的流行數據挖掘技術,以更好地理解機器學習方法。

軟件工具和編程語言包將數據輸入並直接提供數據挖掘結果,對工作機制沒有洞察力,並在輸入和輸出之間形成了一個鴻溝。這就是Excel可以幫助的地方。

Excel允許您以透明的方式處理數據。當您打開Excel文件時,數據立即可見,您可以直接使用它。在進行挖掘任務時,可以檢查中間結果,深入了解數據如何被操作和獲得結果。這些是模型構建過程中的關鍵方面,在軟件工具和編程語言包中是隱藏的。

本書通過Excel教授您數據挖掘。您將學習到當數據集不太大時,Excel在數據挖掘中的優勢。它可以為您提供數據挖掘的視覺表示,從而增加對結果的信心。您將手動進行每一步,這不僅提供了一個積極的學習體驗,還教您挖掘過程的工作方式以及如何找到數據內部隱藏的模式。

您將學到什麼:

- 通過視覺逐步方法理解數據挖掘
- 在理論介紹數據挖掘方法之後,進行Excel實現
- 揭示機器學習算法背後的神秘,使複雜的主題對每個人都可理解
- 熟練使用Excel公式和函數的創造性用法
- 獲得數據挖掘和Excel的實踐經驗

本書適合對學習數據挖掘或機器學習感興趣的任何人,尤其是對數據科學有視覺學習需求和熟練使用Excel的人,他們希望探索數據科學主題和/或擴展Excel技能。建議具備基本或初級水平的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 more than 15 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.

 

作者簡介(中文翻譯)

Hong Zhou博士是一位計算機科學和數學教授,已在聖約瑟大學教授計算機科學、數據科學、數學和信息學課程超過15年。他的研究興趣包括生物信息學、數據挖掘、軟件代理和區塊鏈。在目前的職位之前,他曾在矽谷擔任Java開發人員。周博士認為,學習者在逐步視覺體驗數據挖掘模型時可以建立更好的基礎,這正是Excel所提供的。他在教授數據挖掘時使用Excel,並發現這對於數據挖掘學習者和教育工作者都是一種有效的方法。