How to calculate the mean from cell when each cell is a different double.

Hi Im reading excel files and storing them into data{k} so my data is 1x34 cell and each cell is a double, with variable column number and fixed row 13, now i want to calculate mean of 34 files for column and row 1 and do the same for the rest.I tried cell2mat but this doesnt work as i have different values for columns.

     folder='E:\Engine image\E100 cycles\All Excel Files';
filetype='*.xlsx';  
f=fullfile(folder,filetype);
d=dir(f);
for k=1:numel(d);
  data{k}=xlsread(fullfile(folder,d(k).name));
end

Answer 1

[Andrei Bobrov]

EDIT

m = numel(data);
[ii,~]= cellfun(@size,data);
a = nan(max(ii),size(data{1},2),m);
for jj = 1:m
    a(1:ii(jj),:,jj) = data{jj};
end
out = nanmean(a,3);

[mohsen moslemin]

i think this makes it easier to explain i have 34 excel like this what i want is to read them all, what ive done so far now i want to average each value from 34 data, eventually i should have same matrix but each value is the average of 34 values.

Answer 2

[Azzi Abdelmalek]

cellfun(@(x) mean(x,2),data,'un',0)

[mohsen moslemin]

Hi thanks, This would get mean for all the data, my data is 1x34 and each of those 34 are double like 19x13, 25x13, 20x13 ... if its not clear, what i have is 34 excel files that each one have 13 rows and each row have between 16-27 columns, i want to get the mean for each row from all of those 34 excel files,

[Azzi Abdelmalek]

Have you tested my code?

[mohsen moslemin]

Yes but this is really i want,

i have 34 excel like this what i want is to read them all, what ive done so far now i want to average each value from 34 data, eventually i should have same matrix but each value is the average of 34 values.

[Azzi Abdelmalek]

This is not clear, to make your problem clear, you can post a short example, and also post the expected result, you haven't specified clearly what mean we have to calculate. You said also, that your matrices are not the same sizes

[mohsen moslemin]

Azzi abdelmalek, thanks for your comments sorry this is actually m first time in here so i apologize if something wasn't clear enough.