How to calculate zero mean and unit variance for entire vectors in a folder?

I am supposed to calculate zero mean and unit variance for a vector.These vector values are present in excel sheet.There are many such excel sheets in a folder, for all these excel sheets containing data for which I need to find out zero mean and unit variance are present in a folder. How can I write the code to calculate zero mean and unit variance for all these vectors in a folder at a time. Can u please help me with the code

Answer 1

[Thorsten]

1. Determine all excelfiles in the folder (hint: d = dir(',', '*.xls'))
2. loop over all these files and
3. read file (hint: D = xlsread(d(i).name);
4. compute mean and variance (hint: m = mean(D(:)), v = var(D(:));
5. exit loop if m == 0 && v == 1, in this case disp('found') (hint: break)

[Greg Heath]

 help zscore
 doc zscore

 help mapstd
 doc mapstd

Hope this helps.

Thank you for formally accepting my answer

Greg

[Image Analyst]

Greg, you put this in a comment, not an Answer so it can't be accepted. You should move it to an Answer.

krishnasri, you might find these entries in the FAQ helpful:

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

http://matlab.wikia.com/wiki/FAQ#Why_is_0.3_-_0.2_-_0.1_.28or_similar.29_not_equal_to_zero.3F