How to calculate the mean value and standard deviation of 3 specific columns?

1 次查看（过去 30 天）

Danai Varvatsouli 2020-5-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/525374-how-to-calculate-the-mean-value-and-standard-deviation-of-3-specific-columns

评论： Sriram Tadavarty 2020-5-14

I have an excel file with a table 1442x31. I have extracted the 3 columns I want to calculate on a different table, named cols. Cols table size is 1439x3

And I want to calculate the mean and standard deviation of each of these columns.

I tried these:

mean_val = mean(cols);
stan_dev = std(cols); 

But the result on both of mean and std was [NaN NaN NaN].

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sriram Tadavarty 2020-5-14

在 MATLAB Online 中打开

Implies the values have some NaN entries.

Try once

mean_val = mean(cols,'omitnan');
stan_dev = std(cols,'omitnan'); 

Hope this helps

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by