siva99 wrote:Firstly its an survey data and i cant delete any data.......
You said that before, I don't understand this comment.
Why would you want to delete data? Why would it be impossible (i.e., what is the causal relation between survey data and the possibility to delete data)? And even if you can't delete data, you can still decide not to analyze something right?
Many questions which were are asked contain multiple choice answers..…
For Example- The TV channels I regularly watch (Mulitple options) A NDTV/24 X 7 B Times Now C BBC D Star Sports E AXN
Some people replied A,B,C and some didn’t……I have created separate variable for all these depicting 0 and 1…….
So are all your data nominal? What type of analysis do you want to perform on these data.
I have missing variables ranging from 5% to 50%......
You say missing variables, but it is unclear wht this means:
- Does the entire variable just not occur in your dataset? What does that mean? is it a mistake? or is it, for instance, because nobody watched AXN, therefore it has the value 0 for all people?
- If you say missing variable, do you actually mean that some people have missings on 5 to 50% of the variables? I.e., it is missing values for cases, not missing variables? If so, do these missings represent actual situations (i.e., if somebody did not watch AXN, they don't get a 1 in this variable) or do they represent missings because you don't know whether or not someone watched the channel?
I have done little MCAR test....Chi square is 592395.029 ,DF is 590454 and sig 0.37
Can you say from is test the data is random or Not-random data......
This would indicate that it is random, however, as I indicated before: don't just fare on statistics, also think logically. I think in your case you have missing data for another reason, but see questions above.
Just to be clear: missing at random would mean that there is no particular reason why some data are missing and other data aren't. If indeed, like I suggested above, Data are missing because the variable is not applicable for a person, this is not random but represents an actual situation.