This article describes how to transform the data for each selected variable set and create a new variable set that contains the transformed data after scaling the values for each case so that the data values all lie between 0 and 1. Consider the data below:
For each row in the data, the QScript will subtract the minimum of the row from each entry and then divide by the range (the maximum value minus the minimum value) or the row 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 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) > Unit Interval Within Case or else from the toolbar menu, select Anything > Data > Variables > New > Ready-Made New Variable(s) > Scale Variable(s) > Unit Interval Within Case.
- 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, click OK.
- For each selected variable set, a new variable set is created.
See Also
Scale Variable(s) to Unit Interval Within Variable