清空筛选条件
清空筛选条件

How to calculate average with taking into account only certain values

1 次查看（过去 30 天）
afrya
afrya 2014-3-31
评论： afrya 2014-4-3
Hello,
I'm working with a large matrix that contains a lot of zero values.When I transform this matrix from a list table to a cross table, I have more zero values in it.I want to keep all the initial values in it and and supress all the zero values added from matlab for the calculation of the average.Here is an example of what I want to do:
x=
0.6000 0.6000 5.0000
0.6000 0.8000 6.0000
0.6000 0.8500 0
0.6000 0.8200 0
0.8000 0.8000 9.0000
0.8000 0.9000 2.0000
List table to cross table
NaN 0.6000 0.8000 0.8200 0.8500 0.9000
0.6000 5.0000 6.0000 0 0 0 Average=(5+6+0+0)/4=2,75
0.8000 0 9.0000 0 0 2.0000 Average=(9+2)/2=5,5
Thanks in advance

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

回答（1 个）

Image Analyst
Image Analyst 2014-3-31
I don't know what the cross table stuff means, but to get the mean of an array going across columns, you can do this:
xRowMeans = sum(x, 2) ./ sum(x ~= 0, 2)
  5 个评论
显示 3更早的评论
Image Analyst
Image Analyst 2014-3-31
I don't know what the calcul is but you can do this:
rowMeans = sum(calcul, 2) ./ sum(calcul ~= 0, 2)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by