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
------------------------------
Altair Employee