Skip to main content

Variable Analysis


During the analysis of the variables and their relationship with the outcome variable, we can choose Bi variate or Multivariate. Both have their own advantages and disadvantages. 

Bi variate considers the effect of a single variable on the outcome variable, thus ignoring the effect of the other. Depending upon the correlation factor the variables can be either chosen for further analysis or else rejected. But, rejecting a variable just on the bases of correlation factor is not so wise decision. 

On the other hand, multivariate analysis checks the relationship between the outcome variable and all the other independent variables. From this type of analysis we get a more clear picture on how all the variables are affecting the outcome or dependent variables. The scenario in this case can be described as multi dimensional, cause there are more than 2/3 variables.

In the process of modeling, it becomes a very important for us to select the right variables so that the model can predict with high accuracy. In such case, running both the analysis step by step will reveal the more appropriate choices.

But, the choices must not be always made on the basis of the numerical values or percentages, sometime , it is be more wise to include a variable which may seem to have effect in the future or in the different conditions even though it may have low score.

Methods of choosing the variables

There are many statistical test available in order to choose the relevant variable. Few important ones are as follows:

3. Information Value

1. Chi-squared

The above method gives the correlation between the predictive variables and the log of the odds of a bad outcome. This allows to measure the predictive power of the variable, meaning - how important can this variable be for building a predictive model for the outcome variable.

2. Spearman correlation

The above method gives the correlation  between the ranking of the predictive variables and the outcome variables and not the real values of the variable. In this analysis, the relationship doesn't have to be linear, it just has to be proportional either in negative or positive sense.

3. Information Value

The Information Value is the most interesting statistical process because it measures the amount of information that a variable can give while designing model. It is measured in basis of the deviation of the values within the variables. It is based upon the Information Theory. The range of this score is 0-3.

Example :


The above is just an example of how the table might look. From the above table it is clear that the variable 1 has the highest information-value but less Chi-Squared than Variable 2 and negative correlation.

Whereas , the variable 3 has the least information and also the Chi-squared and Spearman Correlation, thus it can be removed from the analysis, UNLESS, you consider that it is of some value from the business perspective.


After the above process is carried out, the variables can be scored a new value depending upon these three scores. Further, a new ranking can be carried out for all the variables by taking this new score into account. This allows a new perspective for choosing a variable.

The whole process can be in form of iterative process because the result all depends upon the sampling algorithm that has been used. Different sample can give different results, thus the process can be lengthy and laborious. 

Reducing Redundancy in variable

Why is it necessary to reduce redundancy in the variable? This has actually many reasons some of them are as follow :
  • Over crowding the model with many variables with no purpose.
  • Reduce the significance of the predicted co-efficient of the parameters.
  • Risk of out fitting the model.
  • Can destabilise the estimates.
  • Also increase the computation time which can be crucial when the data is in millions. 
How can we identify the redundancy?

In order to identify the redundancy, correlation must be carried out among the variables and not with the outcome variables. After that, the variables must be ranked according to their correlation factor. Then, among the clusters, one may be picked by reference to the three scores discussed above.

There are many commercial soft wares available for the above process. The one that comes to my mind is SAS. But other statistical software like MatLab can also carry out the operation with some programming module written to it.

Labels:

Comments

Post a Comment

Popular posts from this blog

Good Ad Versus Bad Ad

At InRev , for past few days we have been working on our new project. The project is about collaborative blogging, from the blogger around the world. As Bhupendra and I have been blogging for long time, with his immense experience, our team has been working to revamp the globalthoughtz and create a new blogging experience. In this site, we are planning to add a section where people can add their advertisement. We thought lets start by our own :), with already so many products on the line, it was obvious. So there goes an effort to create a small 128 px by 128 px logo. If you are a designer, you know that designing is a very time consuming process. For hours, you just test around with colors. Remember there are 256 X 256 X 256 combination of colors!! Its hard job selecting one. Lets start with F-Cube : In short F-cube is a Free Economic Reporting Site. Let me exhibit some Ad made for it and its pros and cons. (Please don't click on the image. Wait till the end. Thank You) OK, h...
8 comments
Read more

Bruce Lee

Yes. Bruce Lee . Remember all the punches and kicks in his all time hits movies. But why am I talking about him. Am I going to talk about his movies? No, I am not. I am going to say about his philosophies which have been so many times projected in his fighting styles. By the way, he also wrote a book. Many may not know but he had a unique way of thinking about the life and his art of fighting. Let me put forwards his thinking, in my own words.   He believed in efficiency and rejected any amount of redundancy that affected the performance. He believed that there is no one style which is correct. Everyone has their own unique way and must harness those skills rather waste their time in doing something that is not efficient at all.  There are many fighting styles carrying their own norms and values. Every style starts by assuming something. But slowly those assumption are taken as a Gospel truth, and people make them into rules which cannot be broken. But, without understanding the key me...
5 comments
Read more

Being an Artist and Being an Entrepreneur is almost similar

Most people flock to big cities to pursue their dreams and struggle for years. Some people succeed but many still find themselves waiting for the opportunities. They consider that opportunity is the biggest thing that can actually leverage their talent or skill. But I believe that it is not always so. There are couple of examples that proves that opportunity along is not everything. Moreover in today’s media hyped world, opportunities are everywhere from a reality TV shows to your own youtube channel, twitter account or facebook profile. If you look around in youtube, there are lots of artists doing great with their skills and scaling them to offline. This gives a lot of encouragement to all those people who want to pursue their passion. But there is a reality beyond pursuing your dreams that everyone considers once in a while. It’s how far you can take yourself with what you have. Most people get stuck on it and lose their passion in mid way, and some people simply cannot go beyon...
4 comments
Read more