How to perform 0 to 1 Normalization in excel

excel normalization
user3415874 picture user3415874 · Apr 9, 2014 · Viewed 95.6k times · Source

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.

Answer

Nicholas Flees picture Nicholas Flees · Apr 9, 2014

Try this:

=(G9-MIN($G$9:$G:$12))/(MAX($G$9:$G$12)-MIN($G$9:$G$12))

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More