Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 01-03-2014, 09:12 AM
BobBridges's Avatar
BobBridges BobBridges is offline Automated Analyzer Windows 7 64bit Automated Analyzer 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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Portfolio Analyzer Cube - Cost Resource Question seanpears99 Project 2 03-07-2013 06:59 PM
Automated Analyzer Common mailbox analyzer/statistics NoStr0m0 Outlook 3 09-23-2011 05:22 AM
Automated reminders paulgy80 Outlook 1 08-21-2010 04:35 PM
Automated Letter Sections gladfan Word 0 08-11-2010 01:53 AM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft