3
$\begingroup$

I have a traditionally structured data set where rows are observations and columns are variables. There are only a few observations but comparatively more variables. The observations are regions of a country and the variables are characteristics (i.e., population size, mean income, number of males, number of females, etc.). I need to find out which characteristics can distinguish one region from the rest. For example, I need to find out if population size distinguishes region 1 most from regions 2, 3, 4, etc.

Which statistical methods are available to perform this type of analysis? Your help is appreciated.

Just in case it is not clear, my data looks something like the following.

     A, B, C, D
R1   8, 9, 5, 4
R2   5, 8, 4, 5
R3   7, 9, 7, 4

Where R1 = region 1, R2 = region 2, R3 = region 3, A = population, B = average income, C = number of males, D = number of females. My queries are something like this:

  • how is R1 different from the set {R2, R3}?
  • how is R2 different from the set {R1, R3}?
  • how is R3 different from {R1, R2}?

The expected answers look something like this:

  • A make R1 different from {R2, R3}?
  • {A, D} make R2 different from {R1, R3}?
$\endgroup$
4
  • $\begingroup$ You might consider having a look at analysis of variance (ANOVA), which generalizes the t-test to more than two groups. Take a look here and here for more details. $\endgroup$
    – Alexander
    May 17, 2012 at 14:08
  • $\begingroup$ @Alexander i do not think ANOVA applies to my query of interest. ANOVA generalizes the t-test and compares the average of groups. my query is to compare (for each variable) 1 region vs all other regions and determine if this variable (i.e. its value) differentiates it by strength and/or significance. if i had a bunch of data on region 1, region 2, ..., region N, by variable, then i could see how ANOVA could help. but in this case, i only get an aggregate value (the value is at the region level, not sub-region level). thanks though. $\endgroup$
    – Jane Wayne
    May 17, 2012 at 19:28
  • $\begingroup$ How many regions and observations do you have, roughly? $\endgroup$
    – jbowman
    May 17, 2012 at 20:10
  • $\begingroup$ @jbowman i have up to 100 regions (samples) and up to 5,000 variables. i say up to because that is the upper limit. however, i will be working with only subsets at a time. so at any one time, i may be working with 10 regions and 5,000 or less variables. why do you ask or does it matter? $\endgroup$
    – Jane Wayne
    May 17, 2012 at 23:03

2 Answers 2

1
$\begingroup$

I had similar problem and was advised to use Decision Tree Algorithm. In your case classes would be R1, R2, etc. It has R implementation in library(rpart) - function rpart.

$\endgroup$
1
  • $\begingroup$ thanks but i don't think a decision tree algorithm may work. unless i have multiple samples of R1, R2, .... RN, there will not be enough training data for the splitting criterion/function. but a decision rule seems to be an output that i may want (i.e. if A < 8 then R1, if {B < 9,C > 3} then R2). $\endgroup$
    – Jane Wayne
    May 18, 2012 at 7:48
0
$\begingroup$

This is not a complete answer, but whenever I am exploring my data for the first time I like to use the describe() function from the Hmisc library in the free statistical program R. The library is available for download from within R or from its website.

Sample code for exploring your data might look like this:

## Generate example data
Data <- as.data.frame(matrix(data = c(10,11,10,27,5,3,4,15,55,10,10,9,1,2,1,9,12,12,12,17,50,40,50,100,1,2,4,3,9,7,8,10), nrow = 4, ncol = 8, byrow = FALSE))

## Load Hmisc library
library(Hmisc)

## Generate descriptive statistics
describe(Data)

The describe() command will provide you with the number of total, unique, and missing observations of each variable along with means and frequencies. You might also consider further exploring your data with the hist(), density(), and summary() functions. Type help(function_name) at the R command line for details.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.