Assume that there are n rows with seven variables (columns), A, B, C, D, E, F and G, in the data. We use variable E as an example in the calculations below. The remaining variables in the rows are normalized in the same way.
Without rescaling (Baseline variable = None)
The normalized value of ei for variable E in the ith row is calculated as:
where
p = the number of records used to calculate the mean
Rescaling by a baseline variable
If we select variable A as baseline variable, the normalized value of ei for variable E in the ith row is calculated as:
where
p = the number of rows used to calculate the mean
aj = the value for variable A in the jth record
See also: