Calculating Mean, Median, STD from an excel documents that has 68 sheets and in each sheet there are 20 columns

I have a code that reads the excel document. and created a matrix with 68 tables each one represents one of my sheets.

I need to calculate the average from all the rows in coloumn 13:16 in each of these sheets.

%My Code for reading the excel document.

[status,sheets,xlFormat]=xlsfinfo('Majorfaults_300m_10profiles.xlsx')

for k=1:numel(sheets)

data{k}=xlsread('Majorfaults_300m_10profiles.xlsx',sheets{k});

end

...........................................................................................

%%The following is what I have so far to calculate the values but it is not returning right values and only 24 values rather than 68

for k=1:68 %68 tables (sheets from my excel document)

for n = 1:4 % 4 coloums in each sheet where the values need to be calculated

for i = 13:16 %the coloums in the excel sheet the values are calculated from

minimum(n)= min( data{k}(3:end,i));

maximum(n)= max( data{k}(3:end,i));

average(n)= mean( data{k}(3:end,i));

medi(n)= median( data{k}(3:end,i));

end

end

end

Answer 1

[Mathieu NOE]

hello Sophie

you can do everything within the first for loop

I assumed that the min/max / med / average computation muts give 4 values per sheet as you want these results per column

results are stored as cell arrays - other options are also doable

%My Code for reading the excel document.
[status,sheets,xlFormat]=xlsfinfo('Majorfaults_300m_10profiles.xlsx');
for k=1:numel(sheets)
    data=xlsread('Majorfaults_300m_10profiles.xlsx',sheets{k});
    data_extract = data(3:end,13:16); %the colums in the excel sheet the values are calculated from
    minimum{k}= min(data_extract,[],1);
    maximum{k}= max(data_extract,[],1);
    average{k}= mean(data_extract,1);
    medi{k}= median(data_extract,1);
 
end

[Sophie Freunek]

Hey Mathieu,

Thank you so much for your answer.

I get an error message when i run the code you provided:

**Unable to perform assignment because

brace indexing is not supported for

variables of this type.

Error in Plotting (line 24)

minimum{k}= min(data_extract,[],1);

Also, the min/max / med / average computation muts give 4 values per coloumn per sheet.

[Mathieu NOE]

hello Sophie

can you share the excel file which triggered the issue ?

tx

[Mathieu NOE]

FYI

this is the dummy excel file I created to test my code

with your data it would be easier to fix this little problem

[Sophie Freunek]

Hello Mathieu,

Thank you for going through the trouble. please find the sheet attached to this message.

and thank you again for the help.

[Mathieu NOE]

hello Sophie

I have not find any issue on my side

the 3 sheets have been properly processed

the 4 columns results are in each variable cell (one cell = 4 results per sheet) , like :

minimum{1} = 1.0000 0 1.0000 -755.6919

minimum{2} = 10.0000 11.8800 16.3431 -761.9711

minimum{3} = -1.0000 -1.0000 -3.0000 -5.0766

same logic for the other variables

code :

clc
clearvars

%My Code for reading the excel document.
%  Filename = 'Majorfaults_300m_10profiles.xlsx';
Filename = 'For Nildem.xlsx';

[status,sheets,xlFormat]=xlsfinfo(Filename);

for k=1:numel(sheets)
    data=xlsread(Filename,sheets{k});
    data_extract = data(3:end,13:16); %the colums in the excel sheet the values are calculated from
    %the coloums in the excel sheet the values are calculated from
    minimum{k}= min(data_extract,[],1);
    maximum{k}= max(data_extract,[],1);
    average{k}= mean(data_extract,1);
    medi{k}= median(data_extract,1);
    
end

[Sophie Freunek]

Great! thank you so much for your help and time :D

[Mathieu NOE]

My pleasure !