Data Screening, Cleaning and How to Replace Missing Values in SPSS

Поділитися
Вставка
  • Опубліковано 26 жов 2024

КОМЕНТАРІ • 33

  • @Junaidkhan-ce4yd
    @Junaidkhan-ce4yd Рік тому +1

    Thank you so much for such a nice and clear explanation

  • @Alhamzah_F_Abbas
    @Alhamzah_F_Abbas Рік тому +1

    Great explanation. well done

  • @mansour6629
    @mansour6629 6 місяців тому

    Thanks for the great video!
    Could Mode be as well used to replace missing data?

    • @researchwithfawad
      @researchwithfawad  6 місяців тому

      Are you trying to replace the demographics? They should not be replaced.

    • @mansour6629
      @mansour6629 6 місяців тому

      @@researchwithfawad No, sir. There are some missing values in likert scale data. Is Mode an appropriate technique to deal with them?

    • @researchwithfawad
      @researchwithfawad  6 місяців тому

      No.

    • @mansour6629
      @mansour6629 6 місяців тому

      @ResearchWithFawad Thanks!
      Could you please provide a good reference for full guidance on data screening?

    • @researchwithfawad
      @researchwithfawad  6 місяців тому +1

      You may refer to
      Collier, J. (2020). Applied structural equation modeling using AMOS: Basic to advanced techniques. Routledge.

  • @480sachin
    @480sachin 2 роки тому +1

    EXCELLENT SIR

  • @gentesipam3895
    @gentesipam3895 8 місяців тому +1

    thank you so much

  • @alexanderstevens2077
    @alexanderstevens2077 2 роки тому +1

    Unengaged respondents are those that answer all the same values or does so in patterns such as 1111, 3333, 2222, 4444, and so on. How do you detect those?

    • @researchwithfawad
      @researchwithfawad  2 роки тому

      Thanks for your comment. One way to do it is to take Standard Deviation of individual constructs for each respondents. Hope this helps.

  • @HaPham-fq1xt
    @HaPham-fq1xt Рік тому

    Thank you so much for the great explanation. However, you mentioned that the data should be removed if a standard deviation is under .25. Is that any reference for it?

    • @researchwithfawad
      @researchwithfawad  Рік тому

      Thanks. I am glad you liked it. You may refer to
      Collier, J. E. (2020). Applied structural equation modeling using AMOS: Basic to advanced techniques. Routledge.

  • @amalwijenayaka410
    @amalwijenayaka410 Рік тому

    Dear Prof: you mentioned that the data should be removed if a standard deviation is under .25. Is there any reference? We have no access to read this book. (Applied structural equation modeling using AMOS: Basic to advanced techniques) That is why?

    • @researchwithfawad
      @researchwithfawad  Рік тому +1

      Thanks for your interest. That book is the reference. You can quote the book.

  • @talhamansoor7108
    @talhamansoor7108 3 роки тому +1

    That's great

  • @alexanderstevens2077
    @alexanderstevens2077 2 роки тому

    Also, would you recommend examing missing values on a case-by-case basis for missing items that may have been unintentionally skipped by a respondend? It seems to me that, for variables missing > 10% doing this would allow the researcher to determine if, due to some factor, the respondent unintentionally skipped it and directly fill in the best possible value

    • @researchwithfawad
      @researchwithfawad  2 роки тому +1

      Yes, you can perform that imputation and there is also support in the literature for it.

  • @areegtooba8260
    @areegtooba8260 10 місяців тому

    If we added the new column due to imputation. Now may we delete the previous one which was with missing value? How we will use this new one in applying any test?

    • @researchwithfawad
      @researchwithfawad  10 місяців тому +1

      Use he newly formed variable. You can keep the old one but not use it for further analysis

  • @reisterantiporta9767
    @reisterantiporta9767 Рік тому

    Hello! Is it okay if I categorize Likert scale responses as ordinal in SPSS? Or should I categorize it as scale?

    • @researchwithfawad
      @researchwithfawad  Рік тому

      The categorization in SPSS doesnt affect the results. You can put them as ordinal or scale.

  • @saminazaidiacademy8219
    @saminazaidiacademy8219 Рік тому

    How to put multivariables into one variable for data analysis..like 5 items are showing results of one dimensions so how can i analyze

    • @researchwithfawad
      @researchwithfawad  Рік тому +1

      Thanks for your interest.
      You will need to take the sum of the individual items. Let say, i have Organizational Commitment measured using 4 items COM1, COM2, COM3, COM4
      If you have it in SPSS,
      Go to Transform -> Compute Variable
      In the Target Variable Enter the Name of the New Variable that is to be created based on taking the average, let say COMM.
      In the numeric expression type in
      Mean(COM1, COM2, COM3, COM4)
      Press OK. The new variable is created at the end of the Data View and is also visit in the variable view. You have now composite score for each respondent that you can use in regression.

    • @saminazaidiacademy8219
      @saminazaidiacademy8219 Рік тому

      @@researchwithfawad thanks for your timely reply🙏
      I have 5 items in.each COM1 ,COM2 ,COM3...Then how to compute them....to make it one COMM

  • @alexanderstevens2077
    @alexanderstevens2077 2 роки тому

    Can you please include a video on using Expectation Maximization for data imputation?