IBM Support

Z Score or Min/Max rescaling within subgroups

Question & Answer


Question

I wish to rescale a set of continuous variables to Z scores (having a mean of 0 and standard deviation (SD) of 1) and also to a set of min/max scores (having a minimum value of 0 and a maximum value of 100, within each value of a group variable (REGION). I wanted to use the Automatic Data Preparation procedure (Transform->Prepare data for modeling) in IBM SPSS Statistics to perform the rescaling.I had sorted the file by REGION and defined REGION as a Split File variable. However, when I ran Automatic Data Preparation (ADP), my output included the following warning: "This procedure ignores split file specifications." I do not see a Factor box within the ADP dialogs. Is there a way to force ADP to rescale the variables within subgroups? If not, how can I perform these rescalings within subgroups in SPSS .

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21650978

Page Feedback