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
ModModulo (which strips away the decimal part of the value)
PwrPower (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.


ADVANCED TRANSFORMATION
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

absAbsolute value
acosArcCosine
asinArcSine
atanArcTangent
ceilRounded up to the nearest integer
cosCosine
degConvert radians to degrees
expe^x
floorRounded down to the nearest integer
logNatural Log
maxMaximum of two values
minMinimum of two values
piRatio of circumference/diameter of a circle
powx^y
radConvert degrees to radians
rndrandom number from 0 to 1
roundRound value up or down to nearest integer
sinSine
sqrtSquare root
tanTangent

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

Comments