XLMiner’s Missing Data Handling utility allows you to detect missing values in the data set and handle them in a specified way.  XLMiner considers an observation to be missing data if the cell is empty or contains an invalid formula. It is also possible to treat cells containing specific data as missing.

XLMiner offers several different methods for remedying the missing values.  Each variable can be assigned a different treatment. For example, the entire record could be deleted if there is a missing value for one variable, while the missing value could be replaced with a specific value for another variable.  The available options depend on the variable type.

The following examples explore the various ways in which XLMiner treats missing or invalid values in a data set.