## Command Line Usage

 1. colmask irng:=2 cond:=sd nSD:=2; //Mask the cell values in column 2 which outlie 2SD from the mean 

2. colmask irng:=3 cond:=gt val:=0.3; //mask cells in column 3 which is greater than 0.3 

## Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input irng

Input

Range

<active>
Specify the Range need to be masked.
Condition cond

Input

int

0
Specify under what conditions the input data range should be masked.

Option list:

• sd:Outliers by Std. Deviation
Mask the values outlying the standard deviation from mean of the input range.
• gt:>
Mask the cell values which are greater than the value specified by val.
• ge:>=
Mask the cell values which are greater than or equal to the value specified by val.
• lt:<
Mask the cell values which are little than the value specified by val.
• le:<=
Mask the cell values which are little than or equal to the value specified by val.
• eq:=
Mask the cell values which equal to the value specified by val.
nSD nSD

Input

int

1
This variable is available only when the cond is set to sd. The number n sepecified here means that the values outlying n standard deviation(s) from mean will be masked.

Option list:

• 1
Mask the cell values which outlie 1SD from the mean.
• 2
Mask the cell values which outlie 2SD from the mean.
• 3
Mask the cell values which outlie 3SD from the mean.
• 4
Mask the cell values which outlie 4SD from the mean.
• 5
Mask the cell values which outlie 5SD from the mean.
• 6
Mask the cell values which outlie 6SD from the mean.
Value val

Input

double

<unassigned>
This variable is available only when cond is not set to sd.
Use Absolute Values to Test abs

Input

int

0
This variable is available only when cond is not set to sd. It specifies whether to use the absolute values to test the condition.

Input

int

0
This variable specifies whether to keep the existing mask or not.

## Description

This function masks the input values which match the condition.

## Examples

1. The following steps will show you a simple example to mask data outlying one standard deviation from the mean of a set of random numbers.
1. Create a new workbook.
2. Select Format: Worksheet... to open the Worksheet Properties dialog box. Go to the Size tab and change the Row Number to 10000. Click OK button.
3. Highlight column A and right click on it. In the fly-out menu, select Fill Column with: Normal Random Numbers to fill the first column with normal random numbers.
4. Right click on this column and select Mask Cells by Condition... from the fly-out menu to open the colmask dialog box.
5. Keep the default setting and click OK button to execute. You will get values outlying 1SD masked by red.
2. The following scripts will show you how to mask the sunspot numbers outlying 1SD from mean in 256 years sunspot number record.
newbook;
string fn$=system.path.program$+"\Samples\Signal Processing\Average Sunspot.dat";
impasc fname:=fn\$;
colmask irng:=2 cond:=sd;