Normalize data set between 0 and 1

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

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

Sign in to comment.

Answers (3)

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
Star Strider on 17 Oct 2017
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
Steven Lord on 4 Feb 2021
If you're using release R2018a or later, see the normalize function.

Asked:

on 17 Oct 2017

Commented:

on 6 Feb 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!