This is a beginner's questions about statistical tools.
We have a spreadsheet with many columns from a survey.
The first few columns describe each individual:
- Gender (discrete values Male, Female)
- City (discrete values X,Y,Z)
- College Year (discrete values 1,2,3,4)
- BMI (continuous values in the range 10-50)
Then there is a column "Score" for each person, which is continuous from 1 to 5.
We want to find out what interesting correlations between sub-populations and Scoring ranges. For example, "Males in City Y have scores between 1.5 and 2.5" or "Females with BMI between 24.8 and 28.2 have scores between 2.3 and 3.7"
I can crunch this by trial and error using Excel, Access, or C++ code, but then I have to think up of each query and write the code or formulas for it, or try various ranges and combinations methodically.
But then I may miss some pattern. Can the major tools like SPSS or R extract sub-populations that correspond most strongly to a given scoring range? In other words I want it to look at the data and output a fact like the example above. Ideally I don't even want to provide the Score range, the tool should infer and extract the interesting patterns.