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 😭💜💜💜💜
@316rahat6 жыл бұрын
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!
@DrGrande6 жыл бұрын
You are quite welcome -
@tesfayekanko90532 жыл бұрын
I am grateful to the presenter for his supportive short and clear video show. Thank you.
@antongrebac11235 жыл бұрын
Absolute gold, now I can work on my bachelor thesis! Thanks a lot :)
@Dana-pk9px3 жыл бұрын
i usually watch your videos when im not doing uni work. Cool to be able to watch them while i do my homework too
@michelemunday76538 жыл бұрын
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.
@anithats75993 жыл бұрын
Thank you so much sir....from India
@imanal-keissi9183 жыл бұрын
Thank you very much Mr. Todd! It was really very helpful!
@hshogdar62263 жыл бұрын
Thank you sir! very calm and simple way of explanation.
@kishanrajah6273 жыл бұрын
Finally did it. Thanks
@odulanaoluwatoyin88052 жыл бұрын
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
@louisadu-amoah15043 жыл бұрын
Easier to use Sort&Filter to do the find and replace
@STVN91117 жыл бұрын
So simple Yet I couldn't figure it out on my own, thanks pal.
@DrGrande7 жыл бұрын
You're welcome, thanks for watching -
@richardbaskas94069 жыл бұрын
This was a BIG help!!!!! Now it seems so easy!!!!!!!
@thulfikarali86243 жыл бұрын
Hello! Why did you change the categorical variable (Gender) from its original label to values (0, 1)?
@teodorakoleva1714 жыл бұрын
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?
@devalmontguy86978 жыл бұрын
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.
@eihabmunshi72973 жыл бұрын
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.
@onomeabiri48502 жыл бұрын
Thanks. It helped.
@jongar2e3332 жыл бұрын
Good evening , How would you a change a string variable that was imported from excel to a numeric variable ?
@aneliazhangaskina6467 Жыл бұрын
thank you sooooooo much
@AmjadKhan-dg4oy7 жыл бұрын
It is very helpful and informative
@DrGrande7 жыл бұрын
I'm glad you found it helpful - thanks for watching -
@maleesha20043 жыл бұрын
This was very useful! Thanks alot for this..
@Shayara_Payal2 жыл бұрын
Thank you
@AtitManandhar4 жыл бұрын
Thank You so much. This video was very very helpful. Really appreciate for your help. :)
@gracenjiru76323 жыл бұрын
You are amazing!! Thank you so much
@huricanethreeonesix6 жыл бұрын
I love you to little bits and pieces
@edwardyo93283 жыл бұрын
AMAZING! thanks for helping!
@cathrinekatsigianni88236 жыл бұрын
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
@sumansgvc5 жыл бұрын
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.
@arezobouvet60843 жыл бұрын
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.
@talosanconsultingfirm51034 жыл бұрын
thanks zir you helped
@ZainabKadesa3 жыл бұрын
Thank you so much! This is much appreciated.
@lll17229 жыл бұрын
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
@md.abdullahalmamun38003 жыл бұрын
Thanks
@lamoush197 жыл бұрын
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.
@dr.aprilmurdaugh75778 жыл бұрын
The was excellent! I am preparing to run an analysis. Very helpful.
@farmanullah20256 жыл бұрын
very informative representation
@DrGrande6 жыл бұрын
Thank you
@Shayanerfan9 жыл бұрын
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!!!
@DrGrande9 жыл бұрын
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.
@Shayanerfan9 жыл бұрын
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!!
@claudiagarcia18934 жыл бұрын
Thanks, thanks and thanks
@IamVishalVS4 жыл бұрын
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)
@anniemelbourne43029 жыл бұрын
I have panel data with 80 firms, 7 years observation (2007-2013) with 16 indicators, but I got difficulties to input
@tarignassr66906 жыл бұрын
Thanks a lot for your effort
@DrGrande6 жыл бұрын
You're welcome!
@Browning1ize7 жыл бұрын
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".
@altromantaro4 жыл бұрын
Thank you sir
@heidierothschild81697 жыл бұрын
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
@joseph17194 жыл бұрын
03:53 How did you code it Dr?
@zahirahwan5064 жыл бұрын
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
@juandresmith50767 жыл бұрын
Good Day Todd. Please assist me with the following: Would i need to create numbers for open-ended questions like Nationality.
@manikrajbhandari52956 жыл бұрын
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 ...........
@TokyoNomad8 жыл бұрын
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?
@deepu20586 жыл бұрын
Уянга Э same problem i have. What is the solution to it?
@MNISohel7 жыл бұрын
Thanks for the video...
@DrGrande7 жыл бұрын
You're welcome, thanks for watching -
@godloveakabinda89278 жыл бұрын
Thanks a lot for the help
@mbrn34415 жыл бұрын
Thank you.
@fernandboutros-toni32838 жыл бұрын
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 !!!
@momarmt47906 жыл бұрын
Meme problème pour moi.... Vous avez pu avoir une solution?
@PareshSalve5 жыл бұрын
how to automatically generate variable view including with values from exce to spss?
@diadora486 жыл бұрын
Great tutorial, thanks!
@DrGrande6 жыл бұрын
You're welcome!
@karongofrank7 жыл бұрын
Thank you, soo much todd
@DrGrande7 жыл бұрын
You're welcome - thanks for watching -
@meriembkr947 жыл бұрын
Hello sir, thank you so much for your help
@DrGrande7 жыл бұрын
You're welcome, thanks for watching -
@gyorkos-szaboedit7078 жыл бұрын
Thanks a lot!!!! Lifesaver!
@malkawiebtihall75516 жыл бұрын
It's helpful thank you
@HiDefinition1080p7 жыл бұрын
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?
@toluwalopemenoji99555 жыл бұрын
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.
@iqrasohail96054 жыл бұрын
It seems easy hope while doing work it become more easy hope sy
@drrashumittal6 жыл бұрын
amazingly simple..
@2007dodi4 жыл бұрын
What about the Age? how to code this? as I have the age as a category eg. 18-24
@megha75646 жыл бұрын
thank u very much for ur effort :D helped me!
@tabasumfareed65273 жыл бұрын
Why do we need to do coding 2 times?
@willjfit93453 жыл бұрын
How did you code? I can’t figure out how to do it
@najmibasir4 жыл бұрын
thanks!
@challuribabu79117 жыл бұрын
SIR NICE VIDEO HOW TO ADD LABEL IN EXCEL
@moltbeasilicontechno.85884 жыл бұрын
hello sir, plz tell me how to create a label in this video, give me details plz as soon as posible
@indiequa5 жыл бұрын
THANK YOU SO MUCHHHHHH
@vlacocabios7 жыл бұрын
Which test would you use for those data? ANOVA or MANOVA?
@DrGrande7 жыл бұрын
It would depend on the research question, however, an ANCOVA would be a good fit here. The pretest would be the covariate.