Mean and Standard deviation of cell Array column wise

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 件のコメント

Jan
Jan 2018 年 9 月 19 日
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 2018 年 9 月 19 日
Thank you for advice. I follow this in future

サインインしてコメントする。

 採用された回答

Jan
Jan 2018 年 9 月 19 日

0 投票

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

その他の回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeElementary Math についてさらに検索

質問済み:

2018 年 9 月 19 日

コメント済み:

2018 年 9 月 19 日

Community Treasure Hunt

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

Start Hunting!

Translated by