I need to have software for detecting dependencies among data attributes. The simplest example: we have a database table representing results of some social quiz. Columns represent questions; rows, people who passed the quiz. We are searching for different interesting dependencies in the data.
- 60% of men are introverts;
- 90% of people in USA aged 7-15 like milk chocolate;
- passport number identifies people aged 16+;
- children document number identifies people aged <16;
etc, etc, etc.
There are many types of possible dependencies and a lot of methods for finding them (actually I am interested in methods too, so good links and books are appreciated).
Valuable information for me would also include statistics of the importance of different types of dependencies: how to determine which data dependency method is better if we have sets of dependencies found by those methods? We need to somehow mark every dependency (surely marks will be different for different subjects).
Does anybody know of software (ideally in .NET and free) that can analyze data that way? I need real products for data dependency detection, not software for creating such products (so please, do not offer Matlab, C#, C++ etc. as answers).