### Sample Transformer

Note: This module requires that one or more columns of data that are already listed in the STATDISK data window
BASIC TRANSFORMATION
If the column(s) of data is not already there, close this window and enter or open data sets so that they are listed in a column of the STATDISK Data Window. (To open a data set from Appendix B in the textbook, click on "Datasets" at the top. To manually enter a data set, click on Data, then click on Sample Editor. The data can also be copied into STATDISK from another application, such as Minitab or Excel.)

This module creates new data sets by mathematically altering existing data sets. The new data will thus have a known correlation with the original data.

First identify the "Source column," which is the column in the STATDISK Data Window. Select the operation:

 + Addition - Subtraction * Multiplication / Division Mod Modulo (which strips away the decimal part of the value) Pwr Power (exponent)

If you want to transform the source column using the same constant, select the "Constant" button.

If you want to transform the source column using values from another column, select the second column.

EXAMPLES:
To square every values in a column, select Pwr and enter a constant of 2.

To get the square root of values in a column, select Pwr and enter a constant of 0.5.

To add column 1 to column 2, use + with column 1 and column 2.

You can perform an advanced transformation by typing a valid transformation equation in the 'Equation' field and then clicking the 'Adv. Transform' button.

Valid transformation equations consist of using Operators or Functions in combination with Column data.

• To use Column data identify them as: Col1, Col2, Col3, etc. Do not refer to the columns by their title, only use this format.
• Refer to the list of Operators and Functions below for the variety of mathematical operations that can be performed.
• An example of a valid equation is: Col1*Col2/cos(Col4)
• You can use any number of combinations of Columns, Operators, or Functions to construct equations.
Operator
 + Add - Subtract * Mutilply / Divide % Mod \ Integer Divide + None - Negate ^ Exponent ( ) Group

Function

 abs Absolute value acos ArcCosine asin ArcSine atan ArcTangent ceil Rounded up to the nearest integer cos Cosine deg Convert radians to degrees exp e^x floor Rounded down to the nearest integer log Natural Log max Maximum of two values min Minimum of two values pi Ratio of circumference/diameter of a circle pow x^y rad Convert degrees to radians rnd random number from 0 to 1 round Round value up or down to nearest integer sin Sine sqrt Square root tan Tangent

Note: Using either transformation, the result can be copied to the STATDISK Data Window, and the result can be saved.