calculation mean as index for columns

Hi,

I want o calculation mean for 12850x22 matrix. First of all I calculated some values with for loop, after normalized data. But I could not calculate true means for colums.

I m trying this:

%import table from same directory
T = readtable("T.xlsx", "UseExcel", false);
%convert table to matrix except first column
T = T{:,2:23};
cols = size(T,2);

for i = 2:cols
    res(:,i-1) = T(:,i)./T(:,1);
    res_norm = normalize(res,'norm',Inf);
    res_mean = mean(res); %but these are not true means, I need index number but how? 
end

Answer 1

[Image Analyst]

Why not

meanOfThisColumn = mean(T{:,i});  % Braces for T, not parentheses.

You forgot to attach T.xlsx. I'll check back later.

[expert]

Hi

Thank you for your response. But there is an error with this command:

Brace indexing is not supported for variables of this type.

Error in Untitled4 (line 10)
    res_m = mean(res{:,i});

I attached file.

[Image Analyst]

See how important it is to include relevant data in advance?

Try this:

T = readtable('T.xlsx', 'UseExcel', false);
% Convert table to matrix except first column and first row.
numbers = T{2 : end, 2 : end};
columnMeans = mean(numbers, 1)