Coding your DATA in Excel for SPSS

[@katieplant4605]

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]

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

[@SheilaNdiranguKoi]

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

[@AnthonyCliffePHD]

Glad i could help!

[@shaneythoms1982]

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

[@SheilaNdiranguKoi]

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]

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]

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

[@AnthonyCliffePHD]

@@SheilaNdiranguKoi if you ever need any help you can email me on [e-mail]

[@SheilaNdiranguKoi]

@@AnthonyCliffePHD Awesome!! ☺

[@aakritiacharya9331]

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

[@sharathmanya8964]

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

[@AnthonyCliffePHD]

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.

[@romanyfletcher9774]

What happens if you have ranked data?

[@AnthonyCliffePHD]

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 :)