Mean and Standard deviation of cell Array column wise

2 vues (au cours des 30 derniers jours)
Ahmad Bilal
Ahmad Bilal le 19 Sep 2018
Commenté : Ahmad Bilal le 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 commentaires
Jan
Jan le 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.
Ahmad Bilal
Ahmad Bilal le 19 Sep 2018
Thank you for advice. I follow this in future

Connectez-vous pour commenter.

Réponse acceptée

Jan
Jan le 19 Sep 2018
A = readtable('Sampledata.xlsx','Range','A1:A51');
tau_ground = table2array(A);
M = str2double(tau_ground(3:end));
mean(M)
std(M)

Plus de réponses (0)

Catégories

En savoir plus sur Loops and Conditional Statements dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by