SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
  • 1.  When and how to apply sample weights when doing multiple imputation.

    Posted Mon July 03, 2023 09:21 AM

    Hello there.  I can see there have been a few posts about this issue already, but I am still struggling to understand when best to weight cases when doing multiple imputation on SPSS. 

    I am a masters student in the midst of analysing survey data for my dissertation, and I am no statistician.  I have prepared a sample weight to deal with  suspected non-response bias and would like advice please on whether to apply these case weights prior to any imputation, as part of MI, or afterwards.  I ask about the middle option because of the "Analysis Weight" box that's on the Impute Missing Data Values variables page (see image), whose purpose I am unclear about.    Many thanks for any help/advice.



    ------------------------------
    David Libbert
    ------------------------------


  • 2.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Mon July 03, 2023 09:43 AM

    This is a complicate situation.  The MI procedure considers two kinds of weights - frequency weights and what it calls regression weights.  What you have constructed are probably the first kind as the second is mainly used to deal with unequal error variances in regression.  How did you construct your weights?  Raking?  Something else?

    Frequency weights are expected to be integers for imputation purposes, but they should be normalized to add up to the actual sample size.  It probably does not matter if they are fractional.  How to proceed also depends on what sort of analysis you are planning to do.  Custom Tables also supports effective base weighting which allows for fractional weights.  Sampling weights are appropriate for the complex samples procedures.

    In most cases, though, for the multiple imputation stage, I would recommend using the frequency weight for the imputation stage as it balances the sample to be more representative of the population.

    Bear in mind, though, that when modeling, the underlying assumption is that the relationship expressed, say, in a regression equation, is that the same relationship applies to the whole sample (given any conditioning variables in the model), so if you run both weighted and unweighted alternatives, in expectation the coefficients should be the same.  The variances and sig levels will differ, but the general pattern should be similar.  If they are very different, that suggests a modeling problem.



    ------------------------------
    Jon Peck
    ------------------------------



  • 3.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Tue July 04, 2023 05:13 AM

    Many thanks for your response Jon.

    Can I confirm that your recommendation was to apply the NRB weights during the MI process, i.e. to put the NRB weight variable into the "Analysis Weight" box as per my screen grab?

    You ask about how I created the NRB weights. This was done via an online one-question 'micro-survey' with non-respondents answering a 5 point Likert question that exactly matched one in the main survey.  The aim was to help deal with suspected self-select bias – i.e. respondents were keener on the topic (pro-environmental  behaviours in homes) than the average in the sample frame population.  I normalised the dataset to give fractional weightings to apply to main survey respondents broken down by the level they chose to respond to the question, i.e. the weight to apply to those who responded level 5 is 1.12 to help them match the sample population, those who chose level 4 weighted at 0.908, etc. I guess this is what you term a "frequency weight" rather than a "sampling weight".

    In terms of the analysis I plan, the topic of the survey is the influence of green primary schools on green behaviours in the family homes of their pupils. So  I intend to examine this relationship  using the main survey data from parents integrated with data from a separate survey of the 22 participating schools.

    Does this info make any difference to your advice?

    Thanks



    ------------------------------
    David Libbert
    ------------------------------



  • 4.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Wed July 05, 2023 01:50 PM
    That's an interesting adjustment.  I   wonder how the calibration sample is different from the other one.  And maybe it would be make to adjust the weights on additional variables if you have them.

    But, and I don't think that there is an absolutely right answer, I would include the weight in the multiple imputation process.  I am not sure whether there is any difference between using the regular SPSS weighting variable or the analysis weight.  A quick look at the Algorithms Doc (you can get it via Help > Doc in PDF format), suggests that the procedure uses the product of the regular and analysis weight, so it wouldn't matter, at least for the regression stage of the imputation, but there might be some difference further on.
    --





  • 5.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Tue July 18, 2023 11:48 AM

    Thanks Jon.  I will try and use my NRB weight during the MI process as you suggest (using the Analysis Weight box) and see how that goes. 



    ------------------------------
    David Libbert
    ------------------------------



  • 6.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Mon July 03, 2023 09:56 AM

    When it comes to applying weights during multiple imputation, there are a few considerations to keep in mind. The choice of when to apply the weights depends on the specific goals of your analysis and the characteristics of your dataset. Here are three common approaches:

    1. Apply weights before imputation:

      • If the weights are intended to adjust for non-response bias, you may consider applying them before performing the imputation. This approach allows the imputation process to take the weights into account, potentially improving the accuracy of the imputed values.
      • However, be cautious when using weights with imputation, as they can potentially affect the distribution of the imputed values and the analysis results.
    2. Apply weights during imputation:

      • In SPSS, the "Analysis Weight" option in the Impute Missing Data Values dialog box is typically used to account for survey weights or other weights during imputation.
      • If you have a specific weight variable that you want to consider during imputation, you can specify it in this "Analysis Weight" box.
      • This approach allows the imputation process to incorporate the weights directly, potentially influencing the imputed values and the subsequent analyses.
    3. Apply weights after imputation:

      • Alternatively, you can choose to apply the weights after completing the imputation process. Once you have imputed the missing values, you can then use the weighted data for subsequent analyses.
      • This approach treats the imputed data as complete cases and applies the weights as you would with any other complete dataset.

    Ultimately, the decision on when to apply the weights depends on your research goals, the characteristics of your dataset, and the recommendations of your supervisor or dissertation committee. It may be helpful to consult with them to determine the best approach for your specific study.



    ------------------------------
    Youssef Sbai Idrissi
    Software Engineer
    ------------------------------



  • 7.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Tue July 04, 2023 05:18 AM
    Edited by David Libbert Tue July 04, 2023 05:28 AM

    Many thanks for your reply Youssef. 

    You describe the issue well. 

    My initial view was to weight first then impute, as this means the MI is conducted on a 'corrected' dataset. However the issue this raises is that the resulting dataset after imputation no longer matches the sample frame population the weighting was supposed to help with.  So then it seems to make sense to do MI first and weight the results. 

    You'll see I have asked Jon Peck to confirm his view re weighting during  the MI process instead using the "analysis weight" box

    Thanks



    ------------------------------
    David Libbert
    ------------------------------



  • 8.  RE: When and how to apply sample weights when doing multiple imputation.

    Posted Wed July 05, 2023 09:50 AM
    Pls I installed SPSS on my computer and it's not showing menu it refuse to copy  and paste iservrc