How to normalize numeric data?

Altair Forum User

Is there any good functionality to get normalized values of the existing column data?
Suppose I have a column of numeric values such as

Raw value
7854
71652
11734
23394
42404
20826
23472

Now I want get a new column of normalized value.

Raw value	Norm. value
7854	0
71652	1
11734	0.060817
23394	0.243581
42404	0.541553
20826	0.203329
23472	0.244804

It would be perfect if both min/max-based and average/variance-based normalization are possible. Does anybody have an idea?

Thanks.

------------------------------
Akitake Oguchi
------------------------------