MATLAB: Where is the mistake in coding

I separate input data (in file panel.xlsx) into groups based on 4 conditions (in file criteria.xlsx), namely:
  1. Province (64 values)
  2. Number of employees (3 ranges): 2-10; 11-49; 50-10000
  3. Industry ID (89 values)
  4. Year (2 ranges): 2005-2007; 2008-2010
Then i want to calculate mean for each group and assign this mean to every observation in each group. Above is my code, could you please point out what's wrong in the code and fix it. Thank you very much! And i already attach two files used for calculation.
clear all
clc
A=xlsread('criteria.xlsx');
B=xlsread('panel.xlsx');
for i=1:89
    for j=1:64
        for k=1:3
            for h=1:2
                  rowsToAverage = (B(:,5) == A(i,1)) && (B(:,4) == A(j,2)) && (A(k,4) > B(:,2) > A(k,3)) && (A(h,5) < B(:,1) < A(h,6)) && ~isnan(B(:,3));
                  meanOfBigNumbers= mean(B(rowsToAverage, 3));
                  B(rowsToAverage, 6) = meanOfBigNumbers;
              end
          end
      end
  end
xlswrite('panel.xlsx',B)

Best Answer

(B(:,5) == A(i,1)) is a vector calculation. You cannot combine vector values with other values using && like you do. You will need to switch to & instead of &&
Related Question