+ Reply to Thread
Results 1 to 2 of 2

identify is the pattern which gives the highest % success

  1. #1
    Forum Contributor
    Join Date
    05-14-2007
    Location
    London
    MS-Off Ver
    office 365
    Posts
    118

    Brain teaser

    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
    Attached Files Attached Files
    Last edited by censura; 07-04-2007 at 05:07 AM.

  2. #2
    Forum Contributor
    Join Date
    01-10-2006
    Location
    Ahmedabad, India
    MS-Off Ver
    Office 2000
    Posts
    346
    It is not clear what exactly you want. I had a look at the table but I am still at loss. Can you elaborate to make it easier to me?

    A V Veerkar

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1