I don't know if anyone here can help although the problem seems simple the solution is not.
I have a table of inputs (b-J) and a Results column A (1 or 0)
columns b-j inputs provide a prediction of the result in column A and the table shows if correct Match if not Wrong
What i would like to identify is the pattern which gives the highest % success
Ie it could be column b on its own or b,f,g,j.
It is not the highest number of matches although i would like to also know for each pattern the number of occurances ie
a,b = 45% 45 occorances
b,j,k,l=65% 23 occurances
etc
I have attached the table which i hope clarifiys what i am talking about
The actual table has 500+ rows
thank you
Bookmarks