How to normalize 60x3 vector to zero mean and unit variance

I have vector size of 60x3 in an excel sheet, I need to find the zero mean and unit variance of all the values in that sheet and write back the result into another excel sheet. Can u please help me in writing the code.

Answer 1

[Walter Roberson]

New_Array = (The_Array - mean(The_Array(:))) . / var(The_Array(:));

This assumes that the array as a whole is to have zero mean and unit variance, rather than each row or column to independently have zero mean and unit variance. If you want the columns done independently:

(The_Array - repmat(mean(The_Array), size(The_Array,1), 1)) ./ repmat(var(The_array), size(The_Array,1), 1);

[Roger Stafford]

It should be

New_Array = (The_Array - mean(The_Array(:))) . / std(The_Array(:));

to get unit variance or unit standard deviation which is the same thing.

[krishnasri]

D=xlsread('30Aed.xlsx');
New_Array = (D - mean(D(:))) . / std(D(:));
xlswrite('30Anorm',New_Array);
when i write the above code, it is giving an error message:  Unexpected MATLAB operator .  in line 2.. can u please help me resolve this

[Walter Roberson]

New_Array = (D - mean(D(:))) ./ std(D(:));

I was writing on my phone, which loves to add extra spaces :(

[krishnasri]

I didn't get your answer. can you please write it clearly..

[Walter Roberson]

D=xlsread('30Aed.xlsx');
New_Array = (D - mean(D(:))) ./ std(D(:));
xlswrite('30Anorm',New_Array);

The only difference from what you had is to change the ". /" to "./" with no space.

[krishnasri]

Okay got it.. Thanq...

[Luis]

Actually you should divide by the standard deviation (std), not the variance (var)

(The_Array - repmat(mean(The_Array), size(The_Array,1), 1)) ./ repmat(std(The_array), size(The_Array,1), 1);