Assume that there are n rows with seven variables, 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.
The normalized value of ei for variable E in the ith row is calculated as:
where
Emin = the minimum value for variable E
Emax = the maximum value for variable E
If Emax is equal to Emin then Normalized (ei) is set to 0.5.
See also: