Re: Complex Array sorting issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Group = a subset set of valid Question responses eg answer was "1"
Largest Group = Largest set of validQuestion responses = the most common
grouping of question responses where the answer was "1" for all Questions
answered
The challenge is how to show what the questions were tho

The suggested page is like many other resources in this area and only
considers a simple data set. Its easy to show distribution of answers - I'm
looking to show distribution of sets of answers

"Héctor Miguel" wrote:

hi, !

please, excuse me, but I can't get the criteria you used to consider...
- the "largest group"
- the "most/next common group"

is the row-position of the answers relevant for the criteria ? (if so... how/why ?)

didn't you find any helpful tip in the suggested page ?
-> Ranking Data In List (and associated topics)
http://www.cpearson.com/Excel/rank.aspx

regards,
hector.

__ OP __
if data was as follows:

Q1,Q2,Q3,Q4
1,1,0,0
1,1,0,1
1,0,1,0
1,0,0,0

Then result set would be
Q1,Q2,Q4 is largest group
Q1,Q2 is most common group
Q1,Q3 is next common group

I am looking to show the Most Common groups in the full set of data.
Ranked count tells me how many responses I got but not the Q Numbers that are related.

Make sense ?

__ OP __
I can't see any difference on using "just a ranked count of responses"
and then use an index(ed) location for the questions -?-

-> Ranking Data In List (and associated topics)
http://www.cpearson.com/Excel/rank.aspx

(perhaps) if you provide a more detailed example of yor expected results (where and why) ?

__ OP __
I have a range of Question responses from a survey that
I'm seeking to find the most common response combinations from.
Simply sorting the data doesnt acheive that succesfully
Data is in the following format in a table 100 rows deep by 53 colums wide
Respondent Q1 Q2 Q3.... Q53
R1 1,1,0,1...1
R2 0,1,0,1,..0
R3 0,0,1,.....0
R4 1,1,1,.....0
R5 1,0,1,0...1
...
R100 0,0,0,1,..0
What I am seeking to work out is what are the Largest 10 combinations
and the Question numbers that make that combination
- not just a ranked count of the responses Eg Top Combination is Q1 and Q2, and Q53
I'm working thru using arrays but can't find a suitable method to get a result so far
Any guidance appreciated warmly
I have to repeat this over multiple other sets of similar data and would like to do it via a reusable approach.



.

Relevant Pages

  • Re: Editing software
    ... would be a common thread detected in multiple responses. ... One of you, and I apologize for not remembering who, said my banner ... websites for potential clients. ...
    (comp.infosystems.www.authoring.html)
  • Re: Permutation City FAQ
    ... finally put my responses to the most common issues raised about the ... novel on to a web page: ... stories I set them in, and from the "universes" they exist in, just what ...
    (rec.arts.sf.written)
  • A new record!
    ... I count around six posts in a row about aviation, ... responses actually related to the topic. ... Common factor- no Anthony Atkielski. ...
    (rec.aviation.piloting)
  • Re: Problem printing array content with CGI
    ... Simon L wrote: ... >>Relative paths is a rather common cause as well. ... > Thanks for your responses. ...
    (comp.lang.perl.misc)
  • Re: Complex Array sorting issue
    ... I can't see any difference on using "just a ranked count of responses" ... and then use an indexlocacion for the questions -?- ... -> Ranking Data In List ... I'm seeking to find the most common response combinations from. ...
    (microsoft.public.excel.worksheet.functions)