Normalization of data

%3CLINGO-SUB%20id%3D%22lingo-sub-1411372%22%20slang%3D%22en-US%22%3ENormalization%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1411372%22%20slang%3D%22en-US%22%3EHey%2C%20i%20am%20stuck%20in%20normalization%20of%20data%20whose%20values%20are%20between%200-1.%20The%20function%20STDEVA%20and%20its%20associates%20assumes%20data%20to%20be%20a%20population%20stat%20which%20in%20my%20case%20is%20not.%20I%20use%20STANDARDIZE%20function%20to%20normalise%20the%20data.%20Is%20there%20a%20any%20way%20to%20normalize%20data%20ranging%200-1%20in%20excel%3F%20I%20would%20appreciate%20the%20help.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1411372%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGeneral%20Comment%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415808%22%20slang%3D%22en-US%22%3ERe%3A%20Normalization%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415808%22%20slang%3D%22en-US%22%3EAssuming%20you%20need%20to%20convert%20your%20data%20so%20that%20all%20values%20range%20between%200%20and%201%20and%20you%20want%20the%20conversion%20to%20be%20linear...%20Suppose%20your%20data%20is%20in%20cells%20A1%3AA100%2C%20this%20formula%20copied%20down%20for%20as%20many%20cells%20as%20your%20range%20of%20values%20is%20converts%20those%20numbers%20to%200-1%20values%3A%3CBR%20%2F%3E%3D(A1-MIN(%24A%241%3A%24A%24100))%2F(MAX(%24A%241%3A%24A%24100)-MIN(%24A%241%3A%24A%24100))%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
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.
1 Reply
Highlighted
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))