View Single Post
 
Old 01-03-2014, 09:12 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Well, I may be wrong, but I think you're hoping to find a program that will think for you. Programs, unfortunately, don't think; they just calculate, once someone explains to them how to do it. You would have to define at least part of the problem for the program.

Put it this way: If you were to write such an add-on yourself, what (exactly) would you tell it to do? You can define to your program what constitutes a data vector (age, nationality, profession, whatever), and tell the program to take the vectors in every possible combination of pairs. But here's the question: Once your program is looking at two vectors—educational level and religion, perhaps—what should your program do with them?

So far we've just said "compare", but for a program to be able to follow instructions we have to be more specific. What about the data are you looking at? What would you do to advance your analysis?

I've got a notion that despite your insistence that you want to compare "everything to everything", what you have is a particular datum—a bunch of people who answered 'yes' to question 13, for example—and you want to find a correlation between that answer and one or a combination of demographic vectors. A really exhaustive program, therefore, would calculate the correlation between question 13 and each demographic vector; then between question 13 and each combination of two demographic vectors; then between question 13 and each combination of three demographic vectors; and so on. Then it would list the correlations in descending order of absolute value.

If so, you would have to define to your program at a minimum a) which are the demographic vectors and b) which question(s) on the survey you want analyzed in this way. But I'm not at all convinced that this is what you want, still.
Reply With Quote