Menu
I have an excel file with a column containing some numbers i need to normalize the distribution between 0 and 1 using this formula x-min(distribution)/max(distribution)-min(distribution). any help will be appreciated.
836
Standardization (Or Z-score normalization)Step 1: Calculate the mean/average of the distribution. It can be done using the AVERAGE() function. The mean value comes out to be 161.8 and is stored in the B14 cell. Step 2: Calculate the standard deviation of the distribution which can be done using the STDEV() function.
To change the data to negative numbers, type “-1” in an empty cell and copy it using Ctrl-C. Then, select all of the cells containing the data you want to scale, right-click on them, then choose Paste Special. Again, select Multiply and click OK. All the values will change from positive to negative.
Try this:
=(G9-MIN($G$9:$G:$12))/(MAX($G$9:$G$12)-MIN($G$9:$G$12))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
