Hi. First time posting here and hopefully someone will have the solution to my question. I have 2 columns of data. Column A has a 3 digit number, example, .468, .523, etc. In column B, it is either yes or no. Column A represents a numeric value for a test, and column B is whether the test was positive or negative. THe file has over 500 lines. What Im looking for is a way to find which range has the highest % of yes returns. Please see below. Since the file is 500 + lines, Id like to be able to find, lets say which 40 period range has the most yes values. THen Id like to be able to change the range to say 50 data points. Is there a way in solver, what if analysis or a formula which can be used which will allow a different # of ranges? Perhaps if the yes and no are changed to numberic values, that may also be something which would help. Thanks in advance to anyone willing to assist here.
Col A Col B
.456 NO
.485 Yes
.492 Yes
.496 Yes
.499 No
Col A Col B
.456 NO
.485 Yes
.492 Yes
.496 Yes
.499 No