Loop through the vector 6x5800 and save data in excel file.Hi

Hi there,

i'm a biginner with matlab and i would like to import 6x5800 vector from excel to matlab and then want to counting the mean in every columns i imported.

then save the new value in the excel again.

Thanks for your respons

SA

Answer 1

[Mark Sherstan]

Try this out (data file attached). When dealing with large data sets its better to use .csv then .xlsx.

clear all

data = dlmread('data2.csv');

for ii = 1:length(data)
    out(ii) = mean(data(:,ii));
end

csvwrite('dataOut.csv',out)