Reply
Fri 27 Dec, 2013 03:43 pm
I want to be able to evaluate consecutive series and quantify in % if a series was complete or not. For example:
1:TRUE, 2:FALSe, 3:TRUE, 4:FALSE,5:TRUE, 6:TRUE
Suppose my series size=1 than I would evaluate the entire row as: 4 TRUE and 3 FALSE => 57%;
If my series size=2 than I would need to evaluate the entire row as: (1,2) FALSE, 3 TRUE, (4,5) TRUE and 6 TRUE - this is because I evaluate the series by 2 and it applies only when the first item from the series is false; In this case I do not know what % my entire row would have. Can you help me with this.
And also for a given row (for example of 20 items) - can I evaluate that I have positive results (TRUE) for specific series: 1,2,3,4,6 but not 5 for example?
@ThunderStorm,
Are you talking about using Excel? Math? A program?