Hong Zhou – författare

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

Master Excel in less than two weeks with this unique project-based book! Let’s face it, we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and get up to speed quickly. Whether you are just getting started with Excel or are an experienced user, this book will elevate your knowledge and skills. For a beginner, the micro examples in each chapter will warm you up before you dive into the projects. For experienced users, the projects, especially those with table setup considerations, will help you become more creative in your interactions with Excel.

Readers will benefit from building eight unique projects, each covering a different topic, including a word game, a food nutrition ranking, a payroll (tax withholding) calculation, an encryption, a two-way table, a Kaplan-Meier analysis, a data analysis via a pivot table and the K-means Clustering data mining method. Through these projects, you will experience firsthand how Excel skills are organized together to accomplish tasks that sound complex and daunting when first described.

Who This Book Is For

People who are interested in learning Excel as quickly and efficiently as possible. While Excel beginners and intermediate users are the primary audience, experienced Excel users might also discover new skills and ways of working with Excel.

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

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.

Foreign aid has connected China and the international community through many channels, and created new types of strong partnerships throughout the world. As a recipient country, China and donors have engaged in an unprecedentedly deep level of cooperation on development-related issues. China’s development experience has resulted in key changes to the relationships and partnerships between China and donors, from receiving foreign aid to entering into development cooperation. China has provided valuable experiences for other developing countries, experiences that are all the more relevant because they have revealed key factors at work in developing recipient countries. This has also led China to form closer cooperative relationships with other developing countries with regard to development issues. In short, foreign aid has changed China.

This book analyzes the changes in and development of China’s Foreign Aid Policy and Mechanisms over the past 60 years. It offers readers a thorough introduction to China’s Aid to Africa; its Aid to Southeast Asian Countries; its Aid Policy Toward Central Asian Countries; and its Aid to Latin America and the Caribbean Region, as well as their respective influence. 

Combining field research and surveys at the grass-roots level, the book argues that China’s foreign aid policy is intended to help other countries and has changed the strategic pattern of Western countries imposing blockades on New China, and has thus played a key role in expanding and strengthening China’s economic and political ties with many developing countries, restoring its legitimate seat in the United Nations and promoting the cause of cooperation with regard to international development. 

Focusing on concrete examples rather than abstruse theories, the book further argues that foreign aid requires practical policies, suitable expertise and technologies; at the same time, international development – a field largely overlooked by scholars of international relations – can offer profound principles to shape international relations and foreign aid. 

This book provides insight on processing mechanics during ship and offshore structure, and researchers, scientists, and engineers in the field of manufacturing process mechanics can benefit from the book. This book is written by subject experts based on the recent research results in FE computation on accuracy fabrication of ship and offshore structures based on processing mechanics. In order to deal with actual engineering problems during construction of ship and offshore structure, it proposes advanced computational approaches such as thermal elastic–plastic and elastic FE computations and employed to examine physical behavior and clarifies generation mechanism of mechanical response. As such, this book provides valuable knowledge, useful methods, and practical algorithms that can be considered in manufacturing process mechanics.