Hello,
During the Exploratory Data Analysis, I have checked the missing value, replaced the outliers with mean/median and the distribution in most of the cases is near Gaussian.
I have managed to keep collinearity within 10 in most of the cases by removing the variable when their VIF is more than 30-50. Since I am interested in the significant variables use of principal components analysis may not be useful.
I have managed to reduce the number of variable to less than 100 using glmnet. Since the data are continuous with large number of variable even after reduction and a small number of observation, use of Random Forest and Decision Tree is not able to yield good result. Reduction of variables to a very small value yields a very small value of R-squared.
Thank you
------Original Message------
Before constructing any model for prediction purposes it is vital that you do an Exploratory Data Analysis.
This involves understanding the distributions of all your variables and whether there are missing values, outliers and particularly influential points. You should also understand the correlations between your variables and would include an exploratory principal components analysis. This may well lead to the conclusion that are your variables fall into a number of distinct groups. If so, you should ask whether you need to have all of them present in your model.
In the first instance you should try to use subject matter expertise to reduce the number of variables. If you have no subject matter expertise there are a few empirical things you can try. You might need to choose a random sample of the variables to get a model that can be estimated with only 100 observations.
I would do a random forests prediction, as that produces a variable importance score that tells you which variables are the key ones from the point of view of predictive accuracy.
A CART model would also be worth looking at - it will throw away most of the variables and use just a few of them.
The LASSO method also picks out a subset of variables and rejects the rest.
One way or another you need to get the number of variables down to something that can be estimated with 100 observations.
------------------------------
Blaise Egan
Lead Data Scientist
British Telecommunications PLC
------------------------------