0
   

Evaluate consecutive series

 
 
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?
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 0 • Views: 187 • Replies: 1
No top replies

 
jespah
 
  1  
Reply Sat 28 Dec, 2013 07:32 am
@ThunderStorm,
Are you talking about using Excel? Math? A program?
0 Replies
 
 

 
  1. Forums
  2. » Evaluate consecutive series
Copyright © 2026 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 05/15/2026 at 07:11:26