Standard deviation ignoring 0s in matrix

2012 7 24
2 个回答
回答已采纳
6 次查看（30 天）

0 个投票

Hi all, I have a 295x34 matrix called Absy. I want to take the standard deviation of all the columns, however some columns contain many zeros. I want to ignore the zeros and take the standard deviation (as zeros are only their due to some columns being different size).
Thank you.

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

 采纳的回答

Matt Kindig
Matt Kindig 2012-7-24

1 个投票

One easy way would be to convert all zeros to NaN, and then use the nanstd function to ignore the NaNs in the std calculation.
Absy(Absy==0)=NaN;
s = nanstd(Absy,[],1); %column by column std deviation

更多回答（1 个）

Jan
Jan 2012-7-24
编辑：Jan 2012-7-24

0 个投票

x = rand(295, 34);
x(rand(size(x)) < 0.1) = 0;
index = (x ~= 0);
sumnz = sum(index, 1);
meanx = sum(x, 1) ./ sumnz;
xm = bsxfun(@minus, x, meanx);
xm(~index) = 0;
s = sqrt(sum(xm .* xm, 1) ./ (sumnz - 1));
[NOT TESTED]

类别

在 帮助中心 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by