SPSS for newbies: questionnaire data entry
Вставка
- Опубліковано 14 жов 2024
- Once students have collected their questionnaire data they tend to input the data into Excel and then ask the question "How do I import Excel data into SPSS?". Now it's much more efficient to enter your data into SPSS if you intend to use SPSS for data analysis. In short, how to get data directly into SPSS is what you need. Cut Excel out of it.
Of course, you could stick to Excel, but if SPSS is new to you, you will feel a lot more familiar with it after you have spent hours entering the data!
Follow up video:
• SPSS for newbies: Ques...
It is very generous of you to show us how this works, especially since many students are struggling with SPSS and data analysis. It seems like numbers and data don't come easily for most social science students. So again, I owe you so much and keep on doing what you are doing - because it really helps! Thank you
I am Professor Lopez, thank you so much for this selfless and humanistic sharing of knowledge, I hope that I can be as patient as your way of teaching... God bless you...
Rosie, you made a good observation, I also like the way you have put it over. Instead of just going off the wire and accusing for the slip, you were very balanced and quite polite to point it out. And your appreciative nature is nice. In all I am sure you will agree that the Professor did a good job, taking time in putting things across.
Phil I'm just gonna exaggerate and say you're the best. Thank a lot man, you made me master SPSS without much stress, saving me time, money, and energy. I loved your presentation. Thanks a mill
Glad you found my channel
Hi there, thank you for a nice comment, you don't get too many of these on you tube :). Yes, I agree, professor has done an amazing job in taking his time to do this video, and I really appreciate it. I just did my stats exam at postgrad level and every bit of information that could refresh my stats knowledge from a while ago helped immensely.
You have no idea how much you've helped me with my thesis. Thanks man.
Can you use this software for qualitative method?
no
A lot better than other tutorials I've seen on the internet for this. Very easy to understand. Thanks very much for this. :)
Thanks a lot Phil Chan for helping me understanding the basics of how to use SPSS.
Thanks you so much. I have been struggling with my data for weeks now, trying to complete my research for my MA, and I did download the PSPP programme but could not make head not tail of it, but now it all makes sense. It will also work out my means and standard deviations. Again, thank you, it's a God send!
Professor, you did a nice job. your temperament, your skill and your walk through is quite amazing.
Phil Chan, wanna say "thank you very much " which is form china ,I have stong interests in data analysis and resolve to be a good data analysist , thats so helpful of your vedio. Thanks ....
+Wang Chen Most welcome. I thought UA-cam was not accessible by normal means in China
Many thanks for the tutorials they have been extremely helpful and God sent. Please keep them coming.
Thanks Phil. I found this very useful and interesting. It was also easy to learn thanks to your simple manner of instruction.
Glad my simple style helped.
YOU ARE AMAZING!!!! You just saved a thesis.
tnx, phil. it is a good start for me taking MBA on my statistics subject using SPSS. no hands on yet.
+Alberto Marsamolo Jr. My other videos may help you too.
Teaching myself SPSS overnight. Thank you for this!
Pauline, I have arranged my SPSS videos in "chapters", so it's in some order. You can view by going to my youtube homepage.
Thankyou very much your video was very informative for me i was just in search of a clue how to use it so after playing this video for few minutes i did my data entry in no time
+Dr.Naush Farooq Great!
Thank you so much Phil, this is really helpful and I was able to enter my data while watching this video!
Thank you soo much! I've been really nervous about this assignment coming up but now I feel much more prepared!
Thanks so much for this helpful tutorial:) This was my first time ever using SPSS and it was very clear and concise.
a perfect way to learn the basic input methods
ok !! Thanks for the best yet help--easy to follow along and understand- KUDOS TO YOU !!I was lost in the classroom garbled setting- good luck with the videos- you are awesome!!
+Susan Burchill Good luck with SPSS Susan. Video was made for newbies just like you....with a $3 mic...I guess that affects the quality of the sound.
I normally dont comment on UA-cam videos, but this video made me to do the opposite. Full thumbs up to you.. Very well explained and easy to understand.
+Muse Mania Thanks!
Helloo!! great teacher I extremely happy to have learn something from you video this morning. Thanks a lot. I can now go ahead with my likert scale data entry. Michael from Cameroon.
+Ngoh Michael Lyonga Good luck
Thank you so much! You've done an amazing job explaining things. Super easy to understand!
yes good , simple ,easy to understand, and fast we can pick up and practice
Thank god that youtube exists! thank youuu!! xx
haha. psychology students can tutor you if you need help :P
haha nah, I know how to do already lol
true ^__^
Yup. UA-cam has helped me in many ways, so nice to be able to add to the knowledge. Take care. Phil
What measurement would you use for age that has been put into categories? (Ex. 12-25 & 26+) Would that be ordinal? Also what would the measurement scale be for a participants answers on a qualitative question where they would rank how they felt 1-5? Would this be nominal? I averaged the scores afterwards so that would make the combined answers ordinal right?
Thank You for the tutorial. Helps a lot for beginner like me.
thank you for a wonderful tutorial. But I am a bit confused regarding the marital status, will it be nominal or a scale? I think it should be nominal in the measure...isnt it?
Thank you ahmetrics.
I am entering my data into SPSS, but I have difficulty assigning the right measure to 4 of my variables. Would you check them and say if I got any of them wrong? I am comparing newspaper articles.
1. Article size/Word count (up to 100; up to 500; up to 1000) (ORDINAL)
2. Page (1,2,3...) (ORDINAL)
3. Number of quotes per article (SCALE)
4. Description of Volvo (positive, neutral, negative) (ORDINAL)
Thank YOU again!
Nicely Done, done with the sole objective of making the topic understandable, a trait which is worth appreciating. A+
This is great. Where else / which video can I find how to code open ended / free responses? Thank you.
Posted link in latest comments.
Help out sooooo much! You're a life saver man! Thanks for this!
on the variable tab, how did you get the name, type, width, decimal and etc.. do we have to do it manually or…? i am so lost only on that part! but i understand the whole thing haha.
You literally saved my life and dissertation!
Thank you soo much. This is really helpful for my dissertation!
Very useful video, thank you so much. I've got a question I hope you can answer though (google is failing me unfortunatly). I've got two separate surveys for one research but I want to use the two in the same SPSS file so I can analyze them both.
My only idea is to start the other survey at No. 21 (As in 1) since the other survey ends at 14. Any ideas? Thank in advance!
11:29 should be nominal, correct? It was left at "scale" in the video. Just confirmation. I love the videos BTW. They are excellent and I provide them to my students in Research Methods. However, there are times I like to go back and follow your thought process - which helps me in presenting.
Hi Michael
Yes, you are right. This was one of my earlier videos, and I didn't plan it carefully. I left the "Measures" column as its use is for (a) reminding the modeller about the nature of the variable, (b) only matters if you use Chart Builder.
I am glad if you can use the videos in your courses. I think there are a number of colleges recommending the videos to their students. There are common question students wish to ask when doing a project over the holidays and they may find it hard to contact their professor.
On another note, I don't like SPSS. What is routine in other big stats packages like Stata, and R, you need to pay for add-ons with SPSS, or link SPSS to R - well you might as well use R.
I see. So, now you have piqued my interest in Chart Building. Do you happen to have a video on that? BTW, your video on how to handle multiple answers "tick all that apply" was perfect. I had students confused as to how that should be dealt with - and I personally know that students (as newbies) prefer your speed and thorough explanations. I saw where you can commented about some thinking they were too slow - at least for my students, the speed is right.
Thank you for the time and effort you put into these videos.
Hi Michael
I don't have videos on Chart Builder, but I might have used it as part of another analysis. Well. it's something I can do. Thanks for the idea.
You know how it is when you are teaching a group - you can never satisfy all students. A good thing about being on video is that viewers can rewind, so my more recent videos are at normal pace.
Hi, this tutorial is great, however I'm using a questionnaire that has 3 questions per scenario. How would I go about doing this?
OMFG YOU ARE A LIFESAVER!!!! THANK YOU!!!
Hi there video was great, did you make a mistake with the marital states variable? You had it as a scale in your variable view when it is supposed to be a nominal measure. Thanks
Thank you for sharing this video. I am analysis my data right now. :)
thanks a lot, it was really helpful. Now i have an idea abt SPSS, thanks again!
Glad it helped Aida. For everyone who likes a video, I appreciate it if you share it with friends. "Sharing is caring!" Think about your friends who are struggling with SPSS!
Phil Chan i have 4 question in questionnaire that represent dependent variable and 3 question in the questionnaire represent independent variable 1,how can i combine all this question to represent depended variable and independent variable 1 because i want to use dependent variable with Independence variable in correlation analysis?
thankyou !!!!
very helpful
I however was wondering , how do you put data for a question that is divided into segments ,eg
1.age ...
1a. if 20 (above) ...
1b. if ...
you get what I mean?
Yes, you have a scale/continuous variable and you are turning it into groups. This is how to do it:
ua-cam.com/video/9PZUyU2vnb8/v-deo.html
Thanks for the clear explanation.
This has been so helpful! Thank You!
Just sub'd ... quality video and you make good references as well. Thanks a ton
+Bus Lan Thanks. Good luck with everything
Thanks so much for explaining this so well! Very easy to understand. Also, love the accent(:
+Laura Sanford Ta! It's a northern accent.
Thank you so much Phil, this is all so useful!
thank you Phil. extremely helpful video
This has been of tremendous help. Thanks a lot!!
Hi Phil Chan, your tutorial was really helpful. This tutorial really helped me with analyzing the data for my research.
This is so helpful. Thank you so much.
Hi Phil, I'm having a bit of a SPSS breakdown. My Masters research project is comparing European and American Amur leopard husbandry techniques. I have received 29 questionnaires from America and 28 from EU! I can't figure out how to enter these into SPSS :( totally confused.com
what kind of statistical analysis would you use for this type of questionnaire
very grateful. You have helped me immensely
thanks for good lesson! now i can attempt my assignment
Sir,
Are you available to answer a few private questions on entering data/Variables into SPSS? I have a full-blown survey, that requires multiple answers. The individual is required to read 5 different case studies and answer 35 questions per case study.
The confusion is what should I be entering as variables after I get passed the General data entries in the variable view, like in your video.
I could send you a copy of the survey if that would help.
Thank you
Hi. I have my hands full working on my new series on regression analysis for newbies. Err....if the 35 questions are the same for each case you just need 1 extra column for "case number" I guess. Whether you need all data on one file depends on the aim of your analysis. It you are treating each case individually you don't need to combine all 5 cases into one data file. Good luck though.
It is good lec. I clearly understand and hv got some idea abt SPSS. Tanx u soo much
With over 200k hits in the 2nd year this video has got legs. Check out my other videos too!
BEAUTIFULLY DONE!
Hi Phil Chan, I am struggling to enter these data into SPSS------. Help with this problem is highly appriciated. Thanks
"Compared with the previous 12 months, has your profit margin in the past 12 months
a. Increased % b. Decreased% c. Stayed roughly at same
How do you finance your business if you want to expand your business?
a. Bank finance % b. Internal finance% d. Other sources (Please specify)
Thanks, Phil. Awesome video.
Thanks Kimberly
I'd like to do a video on Cronbach's Alpha - a popular measure of internal consistency of a scale (and one that some dissertation supervisors/journals insist on) - used in questionnaire analysis. Can any of you share with me your data set that I would use to demonstrate this? Am after a data set that isn't too complex ie doesnt have loads of wierd variables that will take a layman hours to understand.Data from social science, marketing, medical one will do. A small part of the data would do.
Thanks Kindly
Phil
Phil Chan Hi Phil. Your video was definitely a wealth of information. I just completed my Master's Thesis. Sure I don't mind sharing but I just have to check with my professor the university's IRB to see if it's ok to share my data set from my research. I did my research on the public's perception of the disabled. I will let you know what they say. And you are welcome:).
Kimberly
Hey Phil. What about if I have questions with multiple parts? Like 1., 1a, 1b, etc..
Treat them as new questions, so they will have separate columns in SPSS
Hi, Phil can i ask why i get "the value is negative due to a negative average covariance among item. This violates reliability model assumptions. You may want to check item recoding. I get this when i do the Cronbach alpha reliability test. My N item is 5 and sample of respondent is 60. May i know what have i gone wrong.
Thank you so much for this video it helped me a lot ....god bless you
Thank You. Very Easy To Understand ☺😊
+S_Friend 😊 Enjoy the holiday.
Hi Phil,
How would I enter my data for age if it is in categories of 18-24, 25-35, 36-45, 46-55, 56-65, and 65+?
Would it be the same as for gender? Using nominal data and coding the values so for instance 18 = 18-24?
I am trying to analyse variance in opinions of a new development within Stokes Croft, Bristol.
Thanks!
right here Sophia. Hope you Like it! ua-cam.com/video/JDrp4hfH0nk/v-deo.html
Question sir: Is Q3) "What is your marital status" a nominal variable or a scale variable? I understand that before you said that the variables don't really matter and that we all make little mistakes here and there, especially during long videos, but I was curious for my own sake when I work on my research project. Thanks and nice video!
Hi Richard
Marital status is nominal. Good luck with your project.
Phil
Thanks!
Great tutorial!
Thanks for posting!! SO much help :)
Thank you so much for this video! xx
Simplified and helpfull
Thanks a lot
Thanks for all the comments in these recent days this summer...though I am on holiday, seems like a lot of you are toiling away with a project...good luck to you all!
Thank you! Great tutorial! Much appreciated!
hi phil,
thanks for those videos but what should i do if i have a multiple choice and one of the choices is (other please leave a comment _______)
try this ua-cam.com/video/KJO7mtsc8Rg/v-deo.html
thanks alot that was a great help hope u all the best :)
Thank you very much for this incredibly useful tutorial.
Thank you for all your kind comments.
thanks a lot for your help and sharing
Very helpful. Thank you
OMG, thank u so much!!! It seems so much easier now, I LOVE U!!!
thanks for uploading now m aware of basics :)
Thank you for this video, really helped me :) very happy
clearly explanation .... love it... tq mr.youtube... :)
nur syazana Good luck to you all out there who are doing dissertations over the summer! Treat yourself to a nice holiday after.
This was very helpful 👍🏾
Now i clear about data entry . Thanks
Do I include the number of respondents in my SPSS? or I will start in my demographic data?
Each row will be a respondent (known in SPSS as a "case") so no need to "tell" SPSS how many you have.
Hello, I have been looking your videos but did not find how to code a matrix, do you know how to code a matrix with quite some variables .. ? Thank you !
+Nicolas Fortunato When I read your message I thought you were asking how to create a matrix in the stats package R - which would be a standard question. But to create a matrix in SPSS - I think you are asking something else, but I don't know what. I don't know why you would want to create a matrix in SPSS.
Phil Chan I have a matrix done, that is on a physical paper which is regarding beverages (lines) VS occassion of consumption.and frequency (collumns).. the thing is .. how to code a big matrix into spss and keeping it simple...
+Nicolas Fortunato Actually, what I show in the video is a matrix. You have the cases on the rows, and variables in columns. With your example, it sounds like you are interested in presenting the results, rather than going on do stats analysis on it. You could present a table in excel. Sorry, if not helpful. Just guessing by what you are saying.
Phil Chan I could send you a photo of the matrix I'm doing, to better show you what I mean.. ?
thank you sire. really helpful
Good stuff man...i learn`t a lot
If I have multiple questions using the Likert scale can I populate the legend I created in 'value" to all questions without having to type individually?
I see. The click method is slow for repeated processes. You can speed things up using syntax. Not usually taught to newbies, though not hard.
Hye Phil..Thank you so much..Wanna ask..y u label 5.00 for marital status? I mean single 5.00 and married 8.00..I forgot a bout this software..pls do help me
he coded the martial status in to 5 and 8 and these numbers don't mean any thing but to distinguish between the status he entered and that's basically referred to the type of variable , the martial status is a nominal variable scale means there is no ranking or order to the responses they would be either a males or females these responses called (mutually exclusive and collectively exhaustive responses the goal is here is to classify the respondents regardless the values and you can but any numbers , but in other cases like educational level the order does matter because up to 16 is different from higher education so he order them as 123 .... and so on
Bushra Ramadan Well done Bushra. Nice to see people helping each other out.
Most helpful thank you very much
thanks.. you really save my day
Hey Phil! If Gender is Nominal, shouldn't Marital Status be Nominal too, and not Scale?
Hi. Yes, marital status is nominal. (Though it can confuse some people who think there is an order like being married is better than being single, so then they consider it ordinal.)
Thanks Gentleman for the video and the prompt reply. :)
Thank you!! This is very helpful
If I am inputting data from an asymmetrical likert scale where the values range from -1 negative to 5 for a positive, but the values do not necessarily represent a word value, for example agree strongly agree, is it possible to simply label the -1 value with a -1 label and 5 with a 5 etc. or do i just skip this step altogether, i.e the representative value is inferred?? i may not have worded that question very well but its confusing me
Sounds like the variable is scale, in which case just enter them as normal numbers.
Thanks so much for this tutorial! :)
thank u so much this was so helpful.
I have 15 questions in my questionnaire (5 for every variable). How do I create and enter data???
thanks for helping me put! WAS A HUGE HELP!! xo
Hi, What about if the question implies that the respondent has to insert the answer himself such as in the case of: "Other, please specify"
Let say that that response is"London", for example. How do I insert that into SPSS? Do I have to create a Value for every different response that I get into that category (e.g Paris, Madrid, Barcellona etc.)?
Please help, Im really struggling with that.
Thanks in advance
you've got an open ended question. hope you like this:
ua-cam.com/video/KJO7mtsc8Rg/v-deo.html