Proceedings ArticleDOI
A Simple Approach of Data Mining in Excel
Hewen Tang
- pp 1-4
TLDR
An approach of data mining with Excel using the XLMiner add-in is described, which can be implemented easily, not only by people with specialty knowledge but also by people without specialty knowledge.Abstract:
Data mining is a new method of data analysis, especially very large datasets analysis. Nowadays it is becoming more and more popular in data handling. It is a rapidly growing field, whose development is driven by strong research interests as well as urgent practical, social, and economical needs. However, it generally requires much specialty knowledge. It is not easy for people without specialty knowledge to handle very large datasets with data mining. This paper describes an approach of data mining with Excel using the XLMiner add-in. Using this approach, data preparation can be easily accomplished in Excel. Almost every one can use Excel experienced. Therefore, data mining in Excel can be implemented easily, not only by people with specialty knowledge but also by people without specialty knowledge. This paper presents an example of mining association rules to illustrate all the steps of this approach.read more
Citations
More filters
Journal ArticleDOI
A Simple Approach to Clustering in Excel
TL;DR: This paper shows a way to perform clustering in Microsoft Excel 2007 without using macros, through the innovative use of what-if analysis, and shows that, image processing operations can be done in excel and all operations except displaying an image do not require a macro.
Journal ArticleDOI
Lightweight adaptive Random-Forest for IoT rule generation and execution
TL;DR: A lightweight comprehensive IoT rules generation and execution framework using Random-Forest as the machine learning platform for rules discovery and real-time anomaly detection and to allow RF adaptation to IoT is proposed.
Journal ArticleDOI
A Tools-Based Approach to Teaching Data Mining Methods
TL;DR: A data mining course in an Information Systems program has an analytical component, a tools-based, hands-on component, and a rich collection of data sets, and the application of mining models for decision support and prediction.
References
More filters
Book
Data Mining: Concepts and Techniques
TL;DR: This book presents dozens of algorithms and implementation examples, all in pseudo-code and suitable for use in real-world, large-scale data mining projects, and provides a comprehensive, practical look at the concepts and techniques you need to get the most out of real business data.
Posted Content
Principles of data mining
TL;DR: This paper gives a lightning overview of data mining and its relation to statistics, with particular emphasis on tools for the detection of adverse drug reactions.
Journal ArticleDOI
Data mining: an overview from a database perspective
TL;DR: In this paper, a survey of the available data mining techniques is provided and a comparative study of such techniques is presented, based on a database researcher's point-of-view.
Book
Data preparation for data mining
TL;DR: A twenty-five-year veteran of what has become the data mining industry, Pyle shares his own successful data preparation methodology, offering both a conceptual overview for managers and complete technical details for IT professionals.