Matrix Manipulation Average of specific column

1 次查看（过去 30 天）

Brady Wayne Robinson 2018-9-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/420950-matrix-manipulation-average-of-specific-column

评论： Brady Wayne Robinson 2018-9-27

I have data in excel that is 17 columns by 4800 rows. I need to find all the numbers in each column separately that are greater then 10 and then find there average. This needs to be done for each 17 columns. Just unsure how to do this. Thank You!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

the cyclist 2018-9-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/420950-matrix-manipulation-average-of-specific-column#answer_338614

编辑：the cyclist 2018-9-27

在 MATLAB Online 中打开

If A is the array with your values, then

A10 = (A > 10);
meanA = sum(A.*A10)./sum(A10)

5 个评论
显示 3更早的评论隐藏 3更早的评论

the cyclist 2018-9-27

I don't quite follow your explanation.

I suggest you ...

open up a new question
give a very small illustrative example (e.g. maybe just 4x3) what the input matrix looks like
explain what you expect for the output, and why

It's helpful if you define the input matrix in actual MATLAB code, and not just explain what it is like.

Brady Wayne Robinson 2018-9-27

say I have an array A A=[10 20 3 5 6 4 7 10] We can see that the first and last columns both contain a number that is greater than or equal to 10. I need to know what row that happens in. Here it is easy because there is only one row, but I am dealing with 4800 rows. So I need to find the specific rows where the 6th column and the 8th column both are greater or equal to ten with in the same row. row 189 6th column=11 row 189 8th column=13 therefore row 189 would be a row I need to note. I need to find every row where this is true.

请先登录，再进行评论。

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