0
$\begingroup$

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!

  • 0
    Do you want the minimum and maximum of all of them to be the same, and the relative sizes of the entries to be maintained? (Note: {...} usually denotes *sets*, not vectors)2011-08-08
  • 0
    I don't know where this question should go, but it's not here. It's a question about Excel, not about math.2011-08-08
  • 1
    Arturo, this is exactly what I need.2011-08-08
  • 0
    While you can multiply a vector by a scalar (just multiply all the entries by some fixed number), you can't change the min and the max to arbitrary specified things unless you are willing to do some other operation. For example, if the min is $0$, it will always be $0$ after multiplication. The kinds of "normalization" that would make sense depend on what your data represents. There are an infinite number of things you could do, but more context is needed to know the "right" thing to do.2011-08-08

1 Answers 1