I have three same scaled variables (Strategy 1: Stay, Strategy 2: Move, Strategy 3: Move far) which I want to compare in a heatmap for different locations. For each strategy an operator earns a specific amount of income (interval scaled). The data is built up like this:
Location | Strategy 1 | Strategy 2 | Strategy 3 Location A | 10 | 20 | 30 Location B | 30 | 20 | 10 Location C | 10 | 30 | 20 Location D | ... | ... | ...
Now I want to normalize the variables into an ordinal structure to make them comparable in a heatmap, like Strategy 1: -1 < Strategy 2: 0 < Strategy 3: 1
Examples of desired normalized ordinal value:
For Location A: 0 < val < 1
For Location B: -1 < val < 0
- For Location C: 0 < val < 1
The ordinal value of one location should be close to the maximum value for one location and be influenced by the income of the second best strategy. The third best strategy should have a low influence.
Is there any practice that allows this, or do you have other suggestions to solve this problem? Thanks!