This article describes how to create a new variable(s) that is standardized and will have an average of 0 for each respondent, and will optionally have a standard deviation of 1 for each respondent. Please consider the data below:
For each column/variable in the data, this QScript will subtract the mean of the column from each entry and then divide by the standard deviation of the column to yield the following
Requirements
- A Displayr document that contains one or more Nominal - Multi, Ordinal - Multi, Numeric - Multi, Numeric - Grid, Nominal, Ordinal or Numeric variable sets.
Please note these steps require a Displayr license.
Method
To use this transformation:
- Select one or more Nominal - Multi, Ordinal - Multi, Numeric - Multi, Numeric - Grid, Nominal, Ordinal or Numeric variable sets in the Data Sources tree.
- Still in the Data Sources tree, either hover over any variable in your Data Sources tree > Plus (+) > Insert Variable(s) > Ready-Made New Variable(s) > Scale Variable(s) > Standardize Within Variable or else from the toolbar menu, select Anything > Data > Variables > New > Ready-Made New Variable(s) > Scale Variable(s) > Standardize Within Variable.
- OPTIONAL: If your document contains more than one data file you will be prompted to select the data file. Click OK.
- Next, you will be asked to select the variable sets you want to transform, and click OK.
- For each selected variable set, a new variable set containing the standardized data within the variable is created.
See Also
Scale Variable(s) to Standardize Within Case