Normalizing is simply a way to scale a set of values (in a spreadsheet column) to a smaller, more interpretable range (i.e., 1-10, 0-1, or 0%-100%). Two examples of normalizing data in Excel are shown below. Google search on ‘normalize in Excel’ for more help.
a.) Enter the data in column A, starting at cell A1.
b.) In Cell C1, enter: =AVERAGE(A1:A12), where 12 is last row of data in column A.
c.) In Cell C2, enter: =STDEV(A1:A12).
d.) In Cell B1, enter: =STANDARDIZE(A1,C$1,C$2). In OpenOffice Spreadsheet use this formula: =STANDARDIZE(A1;C$2;C$2). The formula tells Excel to normalize the value in cell A1 using the Mean and Standard Deviation. Said another way, STANDARDIZE subtracts the second number from the first and divides the difference by the third number inside the parenthesis.
e.) Drag the formula from A1 down through the dataset. These are the standardized values.
a.) Enter data in column A starting with cell A1. Example dataset extends from A1 to A12.
b.) In cell B1, =sum(A1:A12).
c.) In cell C1, = A1*(100/$B$1).
d.) Drag-copy the formula down through C12. These are the standardized values. You many need to change the cell format (i.e., percent), depending on the normalized range you chose.