Trouble with Mean function

Question

Alexandra Brian 2017-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339525-trouble-with-mean-function

评论： Star Strider 2017-5-9

example.zip

Hi, I wrote the following code, but it is returning NaN for the output of AvgRule1. It should be the mean of X, when A < 1. I have attached the spreadsheet and the code I used to this post. Please let me know if you can help. Also, there is no NAN data in the spreadsheet. Here's the code:

clear all 
sheet = 1; 
A = xlsread('example1.xlsx', sheet, 'C:C'); %Choose row
X = xlsread('example1.xlsx', sheet, 'B:B');%Choose row
Y = xlsread('example1.xlsx', sheet, 'A:A');%Choose row
   P2SRule1 = X(A<1); %select X values where rule is true 
   AvgRule1 = mean(P2SRule1); %mean of matrix 
   avgDaysHeldRule1= mean(Y(A<1)); %Avg days heald where data meets conditions
   A = { AvgRule1, avgDaysHeldRule1}; %create a variable with all data needed for spreadsheet  
   sheet = 2; %sheet for desired output
   xlRange = 'B2'; %desired range for output
   xlswrite('example1.xlsx', A, sheet, xlRange) %add data to spreedsheet