PiscesLogoSmallerStill  Data transformations

Top  Previous  Next

The values in the Working Data grid can be transformed using a variety of functions. From the Working data window select Transform in the Type of Adjustment panel.

 

transform

 

The possible relative measures available within CAP are given below. Select the transformation to be made and click on Submit to make the change. The transformation options within CAP are itemised below.

 

Reload raw data - This will cause the working data to revert to the raw data.

Log(10) - Each value is transformed to the log to base 10. This cannot be done for numbers <= 0.

Log10(x+1) - Each value is transformed by adding 1 and then calculating the log to base 10. This is used when the data contains zero values.

Log e - Each value is transformed to the log to base e (natural logs). This cannot be done for numbers <= 0.

Log e (x+1) - Each value is transformed by adding 1 and then calculating the log to base e. This is used when the data contains zero values.

Square root - the square root of each number is calculated. This cannot be done for negative numbers.

Arcsin - The Arcsin of each value is calculated. A transformation often used for percentage data.

Arcsin root - The Arcsin of the square root of each number is calculated.

Power - Each value, x, is transformed to xa, where a is chosen by the user.

Add constant - A constant value, chosen by the user, is added to each value.

Subtract constant - A constant value, chosen by the user is subtracted from each value.

Multiply by constant - Each value is multiplied by a constant value chosen by the user.

Divide by constant - Each value is divided by a constant value chosen by the user.