missing values

  1. L

    how to deal with missing values ?

    I have around 80 measurements done for 30 participants over 10 different time points. There is some missing data: 1- some participants have missing values for some measurements. 2- Some participants have measurements done over X time points where X < 10. I want to check if there was an...
  2. R

    Cox Regression with missing values

    Very grateful for any advice. I'm trying to perform Cox regression on a data set with multiple random missing values. SPSS is my go-to software, but the Cox regression algorithm applies LISTWISE deletion to all cases with missing values, resulting in omission of >30% of the cases. I'd rather...
  3. S

    Limits for missing values in the multiple imputation method

    I have an understanding question and I need help. I have a record with many missing values. I now wanted to use the multipile Imputation method to replace the missing values. I would now like to know how many values per subject (in percent) may be missing, so that I can use the MI method at all...
  4. J

    Dealing with missing values

    I am analyzing the data of a cohort study.There are three sets of paired data (same measures on same subjects in 3 different point of time). The problem is that the third set of data have more than 50% missing values. my question is that, how can i deal with these missing? does MI help in these...
  5. M

    Regression: Independent variable (proportions) with missing values

    Hello, My dependent variable is counts of fights in schools. My independent variable is the schools’ proportion of students with a single parent. I hypothesized that schools with higher proportion of students with only one parent will have more fights. I used a negative binomial regression...
  6. G

    Regression with missing data

    Hi all So I just want to do a quick linear regression, but when I initially tried I had an error (r(2000 no observations). I've realised my issue was that I have several variables with missing values. I have a 3-level dependent variable (1,2,3). Then I have several variables that indicate...
  7. L

    Replace missing values with previous or following nonmissing value

    Hello, I have a large data set with 1.8 million records and ~ 500,000 individuals, many with multiple records. Some records for individuals are missing information that are contained in another record for that same person. For example: ID DOB GENDER ETHNICITY 1 2/4/08 F...
  8. N

    Dealing with missing value in dataset

    My dataset contains matrix of 1k x 1k and each points having value ranging from 1 to 100. if value is 1, means that point value is lost. To recover this lost value I have another datset file biult from previous datasets history. this file contains mapping for 1 to 100 to some status value...
  9. L

    Little's MCAR Test

    I have one variable with more than 5% missing data and I want to figure out if it is MCAR, MAR, or MNAR. When I use SPSS's Missing Values Analysis I select that one variable. Do I also need to select the other variables that may contribute to the missingness pattern? How do you choose which...
  10. S

    Missing values analysis - option not in menu! (SPSS 22)

    Hi there, I'm trying to use the missing values analysis in SPSS version 22. According to the manual there should simply be a 'missing value analysis' under 'analyze' however it is just not there, nor can I find it under any other menu. Every tutorial I find online advises the same thing. I...
  11. A

    Question about missing values in SPSS

    So in the picture below you see how it looks like in SPSS. Is it allright I use it like this in my analysis? Or should I consider something? Because the last scale you see, is one I computed using job insecurity and income together to indicate precarity. But for example if someone didnt fill...
  12. A

    Best way to impute NAs before PCA in R

    Hey, I have a dataset with approximately 4000 rows and 150 columns. I want to predict the values of a single column (= target). The data is on cities (demography, social, economic, ... indicators). A lot of these are highly correlated, so I want to do a PCA - Principal Component Analysis...
  13. S

    A question about Multiple imputations

    If I use multiple imputations to complete missing values in a certain variable, can I later use the imputated variable in another imputation (to complete missing values in another variable)? If it is possible, how can I do it? when doing the second imputation process should I use the file with...
  14. E

    Preparing data set for multiple Imputation

    ------------------------------------------------- where is the option to delete solved threads that need no answer nor did they receive any?
  15. Y

    Need help with missing values

    Participants completed 2 questionnaires at Time 1, and each questionnaire is being scored for empathy. Because of recording issues, I do not have an empathy score for some participants for Questionnaire A. If there is a meaningful correlation between empathy scores on Questionnaire A and...
  16. A

    replacing missing values for zeros in a loop

    Hello Stata experts, I am working in panel data with dyadic data and years. My data base is like the following: pair year fdi 1 2005 . 1 2006 . 1 2007 . 1 2008 . 1 2009 0 1 2010 0 1 2011 0 2 2005 . 2 2006 . 2 2007 . 2 2008 0 2 2009 0 2 2010 . 2 2011 . 3 2005 . 3 2006 . 3 2007 . 3 2008 2 3 2009 4...
  17. D

    Problem with qplot

    I am new to both R and ggplot2, so if this is an embarrassingly simple issue to solve, then I hope you'll still bear with me. I am trying to produce a bar chart using qplot and condition it on another (factor) variable. I do this using the facets command, i.e. qplot(x, facets=.~f) However...
  18. T

    Missing value treatment for categorical & continues variables and testng MCAR/MAR

    Hello everybody, My dataset (N=90) consists of ordinal variables serving as IVs and dichotomous and continuous variables serving as DVs. IVs and DVs were assessed in two seperate experiments with the same sample. My proximal goal is to build scales from the IVs and the DVs. I am using PWSTAT...
  19. M

    How to I Calculate the Missing Values?

    IQ-scores are standard-score transformed scores having a mean of 100 and a standard deviation of 15; SAT scores are standard-score transformed scores having a mean of 500 and a standard deviation of 100. In what follows, X refers to a raw score from a distribution with a mean of X and a standard...
  20. B

    Multivariate Regression - comparing two models with different numbers of observations

    Hello, I am attempting to do a multiple regression analysis, but my dataset contains multiple missing values. The values were recoded as ".", but I still cannot get the number of observations to match between the two models and, therefore, cannot run a LRT test. Most of the variables are...