I can’t express how grateful I’m for your efforts in making this easy and simple for SPSS and research newbies such as my self. Thank you soooooo much Doctor Grande 😭💜💜💜💜
Dear Mr. Todd i'm immensely grateful to u for making this video. Currently i'm doing my thesis and now on the part of data analysis thru SPSS. Ur video is a life saver for me! Ur video saved atleast 48hrs of my life! thank u so much sir!
Interesting! Great videos! I don't think I will ever be transferring data from Excel to SPSS, but it is great to be introduced to all of this information and to know that all of these videos are available.
Thank you for your great demonstration, dear Dr. Grande, It would greatly facilitate our learning process--and I would appreciate immensely--if you could share some sample files of both EXCEL and SPSS.
Hi Dr Dr. Todd Grande I was following your videos for my SPSS training. They are really helpful. I was trying to create a bar chart where I wanted to plot the median value with IqR against several categorical variables in a single graph. But I could not make it. Any help will be highly appreciated.
Thank you so much for the great explanation. What about importing a single excel file with diffrent sheets to SPSS, I can only see the first sheet , how can I find the others? Thank you so much.
Thanks for the video. I have a question please. Does it matter where I save the excel file? I'm saving it on Desktop and it's taking forever to be imported. Plus, when I try to save it not on the desktop, it even doesn't show me that the excel file exists there.
Very helpful, Thank you But I will like to know how the data and label is showing beneath the excel sheet (where they normally display sheet 1, sheet 2) that you used to code initially, cause
Hello- I hope you can help me. When I try to import my data it says Serialization Scheme was not recognized. Then it says the file cannot be oped as a data file. When I hand input all the data into SPSs I still could not analyze the data as I received an error message DESCRIPTIVES VARIABLES=Patient_Treated Injured_by Devices_Used_from_kit >Error # 9233. Command name: DESCRIPTIVES >The procedure could not be executed because a required external module was >either not readable or corrupt. >Execution of this command stops. /STATISTICS=MEAN STDDEV MIN MAX. dlopen errno(2): No such file or directory dlopen(/Applications/IBM/SPSS/Statistics/23/SPSSStatistics.app/Contents/bin/../lib/libspsswcde.dylib, 10): image not found Could you tell me what is going on. Thanks. Heidie
thanks for this. I have a question. When I imported my excel data sheet, noted SPSS has recognied some V24, V87 etc... which I looked them seem to be the blank columns which I don't understand how it detacts them. What's the reasons of this and how to deal with it? many thanks
creating number for Nationality is easy if you are collect data from few different country people..........because it save time and effort and but if you collect data from lot of country it is easy to collect data without number..........if some or few country people is repeat lot of time give them number ...........
How do you import averages of variables into SPSS? The averages are from centre of pressure variable for an experiment in biomechanics. They are all numeric data
I uploaded a .xlsx file to SPSS. In the Variable View screen, I changed the data type from String to Numeric. After making it, in Data View screen, I find that entries for that variable have been deleted completely. How I can fix it?
Thanks Todd for the video! It is great. I have a question. I've done all the changes on my variables in "variable view" but doesn't know how to save it. When I open my data again they all gone!!!
Hello Dr, Thank You for your video. I have a question. When I close my Spss document and reopen it, everything gets deactivated. I see all the data I’ve saved but I am not longer able to continue my work by inserting new data. It’s very frustrating. I hope you can help me with this. Thank you in advance.
thank you for the helpful video. althou, i have a problem.When i import my data, all my variables show up but the actual data part on spss comes up empty. How do I solve this?
I've been trying this but it won't work. Every time I attempt to open the excel document in excel it says 'Error accessing the Excel file. If the file is open in another application, please close it and retry.' I have tried this several times and it still won't open. I even tried renaming the file and copying the content to a brand new excel document/window and that still doesn't work. Could it be due to the version of excel and or SPSS I have? where both of them aren't compatible or something like that?
Save your excel sheet differently with a new name (optional). Do a thourough cleaning of irregularities. You can even Sort the data , e.g A-Z. Make sure in a colon no mixture of string values with figures along the columns. Then try import again.
J'ai fait plusieurs tentatives infructueuses d'importation d'un fichier Excel (.xls) sans succès. Je m'explique. Tout se déroule normalement en apparence jusqu'à l'obtention d'une copie du fichier dans SPSS (version 20). Dans la rubrique "Affichage des données" tout est bien recopié. Mais dans l'onglet "Affichage des Variables" , les variables sont toutes au format "chaîne" et toute tentative de modification (au format numérique : 4 variables sur 5) entraîne le remplacement des données par des zéros. ??? A l'aide s'il vous plaît !!!
I can’t express how grateful I’m for your efforts in making this easy and simple for SPSS and research newbies such as my self. Thank you soooooo much Doctor Grande 😭💜💜💜💜
I am grateful to the presenter for his supportive short and clear video show. Thank you.
Absolute gold, now I can work on my bachelor thesis! Thanks a lot :)
Dear Mr. Todd i'm immensely grateful to u for making this video. Currently i'm doing my thesis and now on the part of data analysis thru SPSS. Ur video is a life saver for me! Ur video saved atleast 48hrs of my life! thank u so much sir!
You are quite welcome -
Interesting! Great videos! I don't think I will ever be transferring data from Excel to SPSS, but it is great to be introduced to all of this information and to know that all of these videos are available.
i usually watch your videos when im not doing uni work. Cool to be able to watch them while i do my homework too
Extremely helpful. Thank you!
The was excellent! I am preparing to run an analysis. Very helpful.
Thank you very much Mr. Todd! It was really very helpful!
Thank you sir! very calm and simple way of explanation.
This was a BIG help!!!!! Now it seems so easy!!!!!!!
Thank you so much! This is much appreciated.
Thank you for your great demonstration, dear Dr. Grande,
It would greatly facilitate our learning process--and I would appreciate immensely--if you could share some sample files of both EXCEL and SPSS.
I think it is great how you can "switch views" in SPSS, where you can see what it looks like in excel. It appears to be a time saver.
Hi Dr Dr. Todd Grande
I was following your videos for my SPSS training. They are really helpful.
I was trying to create a bar chart where I wanted to plot the median value with IqR against several categorical variables in a single graph. But I could not make it. Any help will be highly appreciated.
Thank you so much sir....from India
Thank You so much. This video was very very helpful. Really appreciate for your help. :)
thank u very much for ur effort :D helped me!
So simple Yet I couldn't figure it out on my own, thanks pal.
You're welcome, thanks for watching -
AMAZING! thanks for helping!
Thank you so much for the great explanation. What about importing a single excel file with diffrent sheets to SPSS, I can only see the first sheet , how can I find the others? Thank you so much.
You are amazing!! Thank you so much
Thanks for the video. I have a question please. Does it matter where I save the excel file? I'm saving it on Desktop and it's taking forever to be imported. Plus, when I try to save it not on the desktop, it even doesn't show me that the excel file exists there.
Very helpful, Thank you
But I will like to know how the data and label is showing beneath the excel sheet (where they normally display sheet 1, sheet 2) that you used to code initially, cause
Great tutorial, thanks!
You're welcome!
Thanks a lot for the help
Finally did it. Thanks
Thanks a lot!!!! Lifesaver!
Hello- I hope you can help me. When I try to import my data it says Serialization Scheme was not recognized. Then it says the file cannot be oped as a data file. When I hand input all the data into SPSs I still could not analyze the data as I received an error message
DESCRIPTIVES VARIABLES=Patient_Treated Injured_by Devices_Used_from_kit
>Error # 9233. Command name: DESCRIPTIVES
>The procedure could not be executed because a required external module was
>either not readable or corrupt.
>Execution of this command stops.
/STATISTICS=MEAN STDDEV MIN MAX.
dlopen errno(2): No such file or directory
dlopen(/Applications/IBM/SPSS/Statistics/23/SPSSStatistics.app/Contents/bin/../lib/libspsswcde.dylib, 10): image not found
Could you tell me what is going on. Thanks. Heidie
thanks for this. I have a question. When I imported my excel data sheet, noted SPSS has recognied some V24, V87 etc... which I looked them seem to be the blank columns which I don't understand how it detacts them. What's the reasons of this and how to deal with it? many thanks
Good Day Todd. Please assist me with the following: Would i need to create numbers for open-ended questions like Nationality.
creating number for Nationality is easy if you are collect data from few different country people..........because it save time and effort and but if you collect data from lot of country it is easy to collect data without number..........if some or few country people is repeat lot of time give them number ...........
amazingly simple..
thanks zir you helped
I love you to little bits and pieces
Thanks. It helped.
how to automatically generate variable view including with values from exce to spss?
Hello, the age in my study is in the form of age group, should i convert it numerically or should i leave it as it is
Hello,
What if we have more than 1 response to write in a cell? Is it possible? Like "what's your favorite day to run?" "Monday, Wednesday, Friday".
How do you import averages of variables into SPSS? The averages are from centre of pressure variable for an experiment in biomechanics. They are all numeric data
Thank you.
Thanks a lot for your effort
You're welcome!
THANK YOU SO MUCHHHHHH
It is very helpful and informative
I'm glad you found it helpful - thanks for watching -
I uploaded a .xlsx file to SPSS. In the Variable View screen, I changed the data type from String to Numeric. After making it, in Data View screen, I find that entries for that variable have been deleted completely. How I can fix it?
Hello sir, thank you so much for your help
You're welcome, thanks for watching -
Thanks Todd for the video! It is great. I have a question. I've done all the changes on my variables in "variable view" but doesn't know how to save it. When I open my data again they all gone!!!
Leila Jalali Have you tried the "Save As" option under "File?" It will allow you to type a name for the file and select a destination for saving.
thanks a lot Todd! I figured out that my software has a problem that couldn't save it. No I solved it. Thanks a lot for very useful videos!!
I have panel data with 80 firms, 7 years observation (2007-2013) with 16 indicators, but I got difficulties to input
Thanks, thanks and thanks
Thanks for the video...
You're welcome, thanks for watching -
03:53 How did you code it Dr?
Which test would you use for those data? ANOVA or MANOVA?
It would depend on the research question, however, an ANCOVA would be a good fit here. The pretest would be the covariate.
Thank you, soo much todd
You're welcome - thanks for watching -
Is it possible to enter data of more than one option in a single cell and analyze in SPSS. (Example: value 1, 4 in a single cell)
thank you sooooooo much
It's helpful thank you
Thank you sir
Hello Dr,
Thank You for your video. I have a question. When I close my Spss document and reopen it, everything gets deactivated. I see all the data I’ve saved but I am not longer able to continue my work by inserting new data. It’s very frustrating. I hope you can help me with this. Thank you in advance.
Good evening , How would you a change a string variable that was imported from excel to a numeric variable ?
very informative representation
Thank you
Hello! Why did you change the categorical variable (Gender) from its original label to values (0, 1)?
SIR NICE VIDEO HOW TO ADD LABEL IN EXCEL
thank you for the helpful video. althou, i have a problem.When i import my data, all my variables show up but the actual data part on spss comes up empty. How do I solve this?
Уянга Э same problem i have. What is the solution to it?
I've been trying this but it won't work. Every time I attempt to open the excel document in excel it says 'Error accessing the Excel file. If the file is open in another application, please close it and retry.' I have tried this several times and it still won't open. I even tried renaming the file and copying the content to a brand new excel document/window and that still doesn't work. Could it be due to the version of excel and or SPSS I have? where both of them aren't compatible or something like that?
Save your excel sheet differently with a new name (optional). Do a thourough cleaning of irregularities. You can even Sort the data , e.g A-Z. Make sure in a colon no mixture of string values with figures along the columns. Then try import again.
Thank you
How did you code? I can’t figure out how to do it
J'ai fait plusieurs tentatives infructueuses d'importation d'un fichier Excel (.xls) sans succès. Je m'explique. Tout se déroule normalement en apparence jusqu'à l'obtention d'une copie du fichier dans SPSS (version 20). Dans la rubrique "Affichage des données" tout est bien recopié. Mais dans l'onglet "Affichage des Variables" , les variables sont toutes au format "chaîne" et toute tentative de modification (au format numérique : 4 variables sur 5) entraîne le remplacement des données par des zéros. ???
A l'aide s'il vous plaît !!!
Meme problème pour moi.... Vous avez pu avoir une solution?
What about the Age? how to code this? as I have the age as a category eg. 18-24
thanks!
Thanks
hello sir, plz tell me how to create a label in this video, give me details plz as soon as posible
It seems easy hope while doing work it become more easy hope sy
Easier to use Sort&Filter to do the find and replace
Why do we need to do coding 2 times?
can you please please get on with it?
7.45
apaaaaaaaah
This was very useful! Thanks alot for this..
Thanks Sir
You are welcome - thank you for watching -