What software (or method) can I use to determine correlations between any sets of variables and results?
Background: I would like to analyze sets of our archived data over several years. Knowledge of the product tested often leads to some obvious correlations (ie: fuel efficiency peaks at a particular speed). Many trends are not discovered until an investigation following some issue. I'm looking to find any trends that may not be as obvious when looking at the data.
Generally, I seem to find trends by making and testing a hypothesis about the data. However, the process of constructing a query, copying the results to Excel, and analyzing with Excel (sorting, formulas, statistics, graphing, etc) seems too tedious, inefficient, and slow.
I'm looking for software that would take a table of data, look for trends between all sets of variables (inputs) and attributes (outputs), and display the most likely correlations.