Data - Standardize

Ribbon bar. Select the Data tab. In the Transformations group, click Standardize to display the Standardization of Values dialog box, which is used to standardize variables in the active spreadsheet.

Classic menus. From the Data menu, select Standardize to display the Standardization of Values dialog box, which is used to standardize variables in the active spreadsheet.

Click the Variables button to display the Select Variables dialog box, which is used to select the variables to be standardized.

By default, all cases are used in computing means and standard deviations for each variable. However, you can use case selection conditions to compute the mean and standard deviation for a subset of the cases in the active spreadsheet. As an example of this type of subset standardization, you can standardize values once for Males and then for Females in order to obtain standardized scores according to their respective (different) group means and standard deviations. To do so, click the Cases button to display the Spreadsheet Case Selection Conditions dialog box. Here, you specify new case selection conditions or open existing conditions. For more information about case selection conditions, see Case Selection Conditions - Overview.

By default, each selected case contributes equally to the computation of the variable means and standard deviations. To change this, click the Weight button to display the Spreadsheet Case Weights dialog box, where you select a weighting variable. By specifying one variable as containing weights, the influence of each case can be varied by an amount proportional to the value of the weight variable for the case.