UUM ETD | Universiti Utara Malaysian Electronic Theses and Dissertation
FAQs | Feedback | Search Tips | Sitemap

The Impact of Missing Value Methods and Normalization Techniques on the Performance of Data Mining Models

Munirah, Yahya (2011) The Impact of Missing Value Methods and Normalization Techniques on the Performance of Data Mining Models. Masters thesis, Universiti Utara Malaysia.

[img] PDF
Restricted to Registered users only

Download (2MB)

Download (327kB) | Preview


In practice, the large datasets contain various types of anomalous records that significantly complicate the analysis problem. In particular, the prevalence of outliers, missing or incomplete data can completely invalidate the results obtained with standard analysis procedures, often with no indication that anything is wrong. High quality of decision making actually rely on high quality data, therefore data preprocessing has become the essential and important base of DM with no doubt because of no quality data, mean no quality mining results. Data preprocessing consists of interactive step such as data cleaning, data transformation, data reduction and data discretization. Data mining model have been used for extensive analysis in researches or data analysis work as it able to spot subtle relationships and associations. Logistic regression is an important statistical method for modeling and predicting categorical data. Another technique can be used in data mining task is neural network (NN) which have been successfully applied in a wide range of supervised and unsupervised learning applications. This study explored on the use of data preprocessing techniques such as missing values treatment namely Mean of Attributes and Mean of Target. The experimental results indicate that for the Logistic Regression models, models higher average accuracy is shown by data whose missing values were treated as Mean of Attribute. However, for NN models both missing value treatment did not affect the NN models. Prior to NNs training, the data needs to be transformed into form that is acceptable as input to Multi Layer Perceptron(MLP) network. Hence, several normalization techniques had been explored to compare which techniques suitable in each of the three datasets. There are several normalization techniques used for the experimental setup that is Min-Max normalization, Z-Score normalization and Sigmoidal normalization. For Wisconsin Breast Cancer data, Min-Max is preferable. However, for Pima Indians Diabetes and Thyroid Disease data set, Sigmoidal normalization is more preferable than the rest of the method. Hence, the experimental results indicate that the performance of DM models depends not only on the missing value and normalization techniques, it also depends on the amount of missing value in the whole data set.

Item Type: Thesis (Masters)
Uncontrolled Keywords: Data Preprocessing, Missing Values, Normalization, Data Mining Model
Subjects: Q Science > QA Mathematics > QA76 Computer software
Divisions: College of Arts and Sciences (CAS)
Depositing User: Mr Husni Ismail
Date Deposited: 01 Nov 2011 08:57
Last Modified: 27 Apr 2016 07:06
URI: http://etd.uum.edu.my/id/eprint/2499

Actions (login required)

View Item View Item