Mean and Standard deviation of cell Array column wise

3 views (last 30 days)
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 Comments
Jan
Jan on 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.

Sign in to comment.

Accepted Answer

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

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!