Forum Discussion

RJ4197's avatar
RJ4197
Copper Contributor
May 22, 2020

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 to normalise the data. Is there a any way to normalize data ranging 0-1 in excel? I would appreciate the help.
General Comment

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 25, 2020
    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))

Resources