Mean and Standard deviation of cell Array column wise
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Ahmad Bilal
am 19 Sep. 2018
Kommentiert: Ahmad Bilal
am 19 Sep. 2018
Hi, I have 48x1 cell array that consists of decimal numbers. Now i want to take mean and standard deviation of this complete dataset. Can anybody suggest me what is the possible solution for that??? I have written the following code :
A = readtable('Sampledata.xlsx','Range','A1:A51');
tau_ground = table2array(A);
tau_ground(1:2)=[];
for i=1:48
M = str2double(cell2mat(tau_ground(i)));
end
result_avg = mean(M{:},1);
result_std = std(M);
2 Kommentare
Jan
am 19 Sep. 2018
Today I've selected your code with the mouse and pressed the "{} Code" button, such that it is readable. Please do this by your own in the future. Thanks.
Akzeptierte Antwort
Jan
am 19 Sep. 2018
A = readtable('Sampledata.xlsx','Range','A1:A51');
tau_ground = table2array(A);
M = str2double(tau_ground(3:end));
mean(M)
std(M)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Creating and Concatenating Matrices finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!