# Can tools like SPSS find out which columns correspond to a certain data range

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:

1. Gender (discrete values Male, Female)
2. City (discrete values X,Y,Z)
3. College Year (discrete values 1,2,3,4)
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.

Thank you.

• I would usually use CHAID analysis for this kind of problem - I use it in SPSS but you can find it in R too (for free). – eli-k Aug 19 '16 at 5:59