Normalize (or normalise depending on US/UK...)

  • Thread starter Thread starter Aj
  • Start date Start date
A

Aj

I have some data from different graphs that I need to normalise. I have taken
a look through some of the other questions posted, but none of the answers
fit my work.

I have data (see example below) that plots grey scale against distance. I
need to normalise the greyscale data so that I can compare different data
sets (long explanation of why). Basically, the max needs to be 1 and the min
0. Is it possible to construct a formula to do this, or is there one already
that I have missed?

Aj

ums Gray Level
0 282
0.0757216 280
0.1514433 328
0.227165 377
0.3028866 415
0.3786083 535
0.45433 805
0.5300516 1062
0.6057733 1395
0.681495 1443
0.7572166 1381
0.8329383 1071
0.9086599 875
0.9843816 551
1.060103 414
1.135825 344
1.211547 317
1.287268 272
1.36299 240
 
One way to set the min. to 0 and the max. to 1 would be to subtract
the min. from each number and then divide the result by the new max.
(i.e., the original max. - min.)

So, adjusted number = (orignal number - min.)/(max. - min.)

I have some data from different graphs that I need to normalise. I have taken
a look through some of the other questions posted, but none of the answers
fit my work.

I have data (see example below) that plots grey scale against distance. I
need to normalise the greyscale data so that I can compare different data
sets (long explanation of why). Basically, the max needs to be 1 and the min
0. Is it possible to construct a formula to do this, or is there one already
that I have missed?

Aj

ums Gray Level
0 282
0.0757216 280
0.1514433 328
0.227165 377
0.3028866 415
0.3786083 535
0.45433 805
0.5300516 1062
0.6057733 1395
0.681495 1443
0.7572166 1381
0.8329383 1071
0.9086599 875
0.9843816 551
1.060103 414
1.135825 344
1.211547 317
1.287268 272
1.36299 240
Click to expand...
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
 
Marvellous, thanks.

Aj

Tushar Mehta said:
One way to set the min. to 0 and the max. to 1 would be to subtract
the min. from each number and then divide the result by the new max.
(i.e., the original max. - min.)

So, adjusted number = (orignal number - min.)/(max. - min.)


Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
Click to expand...
 
Back
Top