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

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
 
T

Tushar Mehta

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
 
A

Aj

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help...... 4
Help with this challenging VBA coding 3
Graphing Database Growth Rate 1
Outlook connector crashes outlook 0
Outlook crashes with Outlook connector 2002 0

Top