I've never posted on this forum, so I hope this question is valid...
I have sets of data that are composed of these values (simplified)
data1: 1396.53, 1, 1396.53, 106.85, 1, 55.6949 data2: 370.155, 1, 370.155, 16.2414, 1, 13.3966
The idea is to get the average of each column, then apply a weighting to give each the same scale. For example, the averages come out to be:
Averages: 883.3425, 1, 883.3425, 61.5457, 1, 34.54575
Then the goal would be to apply weights to put each column on roughly the same scale:
(883.3425 * 0.01) + (1) + (883.3425 * 0.01) + (61.5457 * 0.1) + (1) + (34.54575 *0.1)
I'm rather poor with thinking of algorithms, so I cant quite find a systematic way of calculating the weights. I hope this question makes sense and thank you for your help!