Coding your DATA in Excel for SPSS

Поделиться
HTML-код
  • Опубликовано: 19 ноя 2019
  • This session focuses on how to get your questionnaire data set up and ready in Excel and code it, ready for inputting it into SPSS for data analysis.

Комментарии • 15

  • @katieplant4605
    @katieplant4605 4 месяца назад

    Anthony - your tutorials are saving my life with my Master's at the moment. I wish I could send you like a huge treat basket or something. Thank you so much, you explain things so well

    • @AnthonyCliffePHD
      @AnthonyCliffePHD  4 месяца назад

      Thank you so much Katie! Always makes a difference to know I'm helping students! I will be getting back into RUclips again soon and uploading more videos!

  • @SheilaNdiranguKoi
    @SheilaNdiranguKoi 4 года назад +2

    Your video has saved my life! Was wondering what to do with the multiple response questions.

  • @shaneythoms1982
    @shaneythoms1982 Год назад +1

    how did you get all the variables to have their individual columns?

  • @sharathmanya8964
    @sharathmanya8964 3 года назад

    Will anyone please help in making a masterchart of data similar to this size. How do i go about it ?

    • @AnthonyCliffePHD
      @AnthonyCliffePHD  3 года назад

      Where is your data from? If from online surveys use the export function. If it's on paper, simply open an Excel file, have your questions in each separate column along the top row. Each row under that will be a participants answers.

  • @SheilaNdiranguKoi
    @SheilaNdiranguKoi 4 года назад +3

    Please I have one question: For the multiple response questions, there may be a blank space because a person chose a different option or it may be missing data, like the person didn't answer the question at all. How do you discriminate this when coding- how to allocate '2' or '99'?

    • @AnthonyCliffePHD
      @AnthonyCliffePHD  4 года назад +2

      Hi Koi, sorry i didn't see this message before. If it's multiple choice then you should allocate blanks as 2 meaning 'no'. As 99 means missing data but in the case of multiple choice its not missing data because they actively chose not to select that option, so it gets a 2 (meaning no) and anything they did select gets a 1 ( meaning yes). Hope this helps!

    • @SheilaNdiranguKoi
      @SheilaNdiranguKoi 4 года назад +1

      @@AnthonyCliffePHD Thank you so much. Makes perfect sense!

    • @AnthonyCliffePHD
      @AnthonyCliffePHD  4 года назад +1

      @@SheilaNdiranguKoi if you ever need any help you can email me on a.cliffe@chester.ac.uk

    • @SheilaNdiranguKoi
      @SheilaNdiranguKoi 4 года назад

      @@AnthonyCliffePHD Awesome!! ☺

    • @aakritiacharya9331
      @aakritiacharya9331 3 года назад

      Meaning 'no' can also be allocated by using 0, right??

  • @romanyfletcher9774
    @romanyfletcher9774 4 года назад

    What happens if you have ranked data?

    • @AnthonyCliffePHD
      @AnthonyCliffePHD  4 года назад +1

      Ranked data you should just leave it as is i.e if your question was please rank the following with 1 being most important and 5 the least. If they've put 1 leave it as 1, 2 leave as 2 etc. Then in SPSS where it asks for the code name just leave as 1,2 etc :)