Normalize data set between 0 and 1
Show older comments
I have a data set in excel sheet and my task is to normalize these data between 0 and 1 .I 1st try to get max or min value but give me in exponential format although i try format short format long but does not give right value..help me
1 Comment
Ameetha
on 4 Feb 2021
DID YOU GET THE SOLUTION FOR THIS? IF SO PLS GIVE ME THE CODE TO NORMALIZE VALUES BETWEEN O AND 1 after reading from various columns of an excel sheet in matlab
Answers (3)
Image Analyst
on 17 Oct 2017
If you have the Image Processing Toolbox, you can normalize an array to between 0 and 1 by doing this:
normalizedData = mat2gray(data);
Star Strider
on 17 Oct 2017
0 votes
The format is not important with respect to the calculations. The values you want from your imported Excel data, and the minimum and maximum, retain their full precision regardless of how they are displayed.
If you want to change the Command Window format of your numbers, see the documentation for the format (link) function.
Steven Lord
on 4 Feb 2021
0 votes
1 Comment
Image Analyst
on 6 Feb 2021
or rescale(). Is one better than the other?
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!