Forum Discussion
Normalization of data
Hey, i am stuck in normalization of data whose values are between 0-1. The function STDEVA and its associates assumes data to be a population stat which in my case is not. I use STANDARDIZE function t...
Assuming you need to convert your data so that all values range between 0 and 1 and you want the conversion to be linear... Suppose your data is in cells A1:A100, this formula copied down for as many cells as your range of values is converts those numbers to 0-1 values:
=(A1-MIN($A$1:$A$100))/(MAX($A$1:$A$100)-MIN($A$1:$A$100))
=(A1-MIN($A$1:$A$100))/(MAX($A$1:$A$100)-MIN($A$1:$A$100))