|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 6th, 2009, 03:26 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Normalize (or normalise depending on US/UK...)
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 
|
|
#2
October 6th, 2009, 11:57 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Normalize (or normalise depending on US/UK...)
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.) On Tue, 6 Oct 2009 07:26:01 -0700, Aj wrote: 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 Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins
|
|
#3
October 7th, 2009, 09:48 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Normalize (or normalise depending on US/UK...)
Marvellous, thanks.
Aj "Tushar Mehta" wrote: 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.) On Tue, 6 Oct 2009 07:26:01 -0700, Aj wrote: 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 Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins
|
|
#4
October 7th, 2009, 11:22 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Normalize (or normalise depending on US/UK...)
You are welcome.
On Wed, 7 Oct 2009 01:48:02 -0700, Aj wrote: Marvellous, thanks. Aj "Tushar Mehta" wrote: 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.) On Tue, 6 Oct 2009 07:26:01 -0700, Aj wrote: 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 Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
