Missing Data Handling
|
Introduction
This utility allows the user to process the data before any mining method is applied on it. It allows the user to detect the missing values in the data and handle them the way the user wants.
XLMiner™ considers a cell to be missing data if it is empty or contains an invalid formula. XLMiner™ can be prompted to treat a cell to be missing data if it contains a certain value specified by the user.
The user can specify how XLMiner™ should correct these missing values. A treatment can be assigned for every variable. The records with missing data can be either deleted fully or the missing values can be replaced. XLMiner™ provides options on how to replace the missing data, eg. by mean or median or mode or a value specified by the user. The available options depend on the type of variable.
See also: |