I have an Excel spreadsheet with multiple vectors of 3 numbers. I would like to normalize those vectors so that they are within the same range.
v1 = { 0, 5, 75 } -- [0, 75] v2 = { 2, 4, 6 } -- [2, 6] v3 = { 0, 50, 75 } -- [0, 75]
In the example above the results we obtained for v1 and v3 were between 0 and 75, but v2 is between 2 and 6. I would like those vectors to be on the same scale.
Could someone please help me with that? Is there an Excel function for that?
Thanks!