MATLAB: Can i find ‘mean’ of on column , based on second column

matrixmean

I have random matrix A 120×6. In last column I have only values 1 or 2. I want to find the min, max, median, and mean of first column for this rows, where in 6 column is 1.
6 8 2 9 5 2
1 8 6 10 5 2
1 10 2 7 2 1
3 3 2 7 2 1
2 10 8 3 1 1
2 1 4 6 4 1
10 9 2 2 9 2
3 8 5 2 5 1
4 3 9 8 6 2
4 8 4 7 7 2
10 1 4 9 7 2

Best Answer

Try this:
m = [...
6 8 2 9 5 2
1 8 6 10 5 2
1 10 2 7 2 1
3 3 2 7 2 1
2 10 8 3 1 1
2 1 4 6 4 1
10 9 2 2 9 2
3 8 5 2 5 1
4 3 9 8 6 2
4 8 4 7 7 2
10 1 4 9 7 2]
col6Is1 = m(:, 6) == 1
minOfColumn1 = min(m(col6Is1, 1))
maxOfColumn1 = max(m(col6Is1, 1))
medianOfColumn1 = median(m(col6Is1, 1))
meanOfColumn1 = mean(m(col6Is1, 1))