No video

Import Data from Microsoft Excel into SPSS

  Рет қаралды 425,758

Dr. Todd Grande

Dr. Todd Grande

Күн бұрын

Пікірлер: 98
@lumpyspaceprincess4287
@lumpyspaceprincess4287 4 жыл бұрын
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 😭💜💜💜💜
@316rahat
@316rahat 6 жыл бұрын
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!
@DrGrande
@DrGrande 6 жыл бұрын
You are quite welcome -
@tesfayekanko9053
@tesfayekanko9053 2 жыл бұрын
I am grateful to the presenter for his supportive short and clear video show. Thank you.
@antongrebac1123
@antongrebac1123 5 жыл бұрын
Absolute gold, now I can work on my bachelor thesis! Thanks a lot :)
@Dana-pk9px
@Dana-pk9px 3 жыл бұрын
i usually watch your videos when im not doing uni work. Cool to be able to watch them while i do my homework too
@michelemunday7653
@michelemunday7653 8 жыл бұрын
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.
@anithats7599
@anithats7599 3 жыл бұрын
Thank you so much sir....from India
@imanal-keissi918
@imanal-keissi918 3 жыл бұрын
Thank you very much Mr. Todd! It was really very helpful!
@hshogdar6226
@hshogdar6226 3 жыл бұрын
Thank you sir! very calm and simple way of explanation.
@kishanrajah627
@kishanrajah627 3 жыл бұрын
Finally did it. Thanks
@odulanaoluwatoyin8805
@odulanaoluwatoyin8805 2 жыл бұрын
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-amoah1504
@louisadu-amoah1504 3 жыл бұрын
Easier to use Sort&Filter to do the find and replace
@STVN9111
@STVN9111 7 жыл бұрын
So simple Yet I couldn't figure it out on my own, thanks pal.
@DrGrande
@DrGrande 7 жыл бұрын
You're welcome, thanks for watching -
@richardbaskas9406
@richardbaskas9406 9 жыл бұрын
This was a BIG help!!!!! Now it seems so easy!!!!!!!
@thulfikarali8624
@thulfikarali8624 3 жыл бұрын
Hello! Why did you change the categorical variable (Gender) from its original label to values (0, 1)?
@teodorakoleva171
@teodorakoleva171 4 жыл бұрын
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?
@devalmontguy8697
@devalmontguy8697 8 жыл бұрын
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.
@eihabmunshi7297
@eihabmunshi7297 3 жыл бұрын
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.
@onomeabiri4850
@onomeabiri4850 2 жыл бұрын
Thanks. It helped.
@jongar2e333
@jongar2e333 2 жыл бұрын
Good evening , How would you a change a string variable that was imported from excel to a numeric variable ?
@aneliazhangaskina6467
@aneliazhangaskina6467 Жыл бұрын
thank you sooooooo much
@AmjadKhan-dg4oy
@AmjadKhan-dg4oy 7 жыл бұрын
It is very helpful and informative
@DrGrande
@DrGrande 7 жыл бұрын
I'm glad you found it helpful - thanks for watching -
@maleesha2004
@maleesha2004 3 жыл бұрын
This was very useful! Thanks alot for this..
@Shayara_Payal
@Shayara_Payal 2 жыл бұрын
Thank you
@AtitManandhar
@AtitManandhar 4 жыл бұрын
Thank You so much. This video was very very helpful. Really appreciate for your help. :)
@gracenjiru7632
@gracenjiru7632 3 жыл бұрын
You are amazing!! Thank you so much
@huricanethreeonesix
@huricanethreeonesix 6 жыл бұрын
I love you to little bits and pieces
@edwardyo9328
@edwardyo9328 3 жыл бұрын
AMAZING! thanks for helping!
@cathrinekatsigianni8823
@cathrinekatsigianni8823 6 жыл бұрын
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
@sumansgvc
@sumansgvc 5 жыл бұрын
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.
@arezobouvet6084
@arezobouvet6084 3 жыл бұрын
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.
@talosanconsultingfirm5103
@talosanconsultingfirm5103 4 жыл бұрын
thanks zir you helped
@ZainabKadesa
@ZainabKadesa 3 жыл бұрын
Thank you so much! This is much appreciated.
@lll1722
@lll1722 9 жыл бұрын
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.abdullahalmamun3800
@md.abdullahalmamun3800 3 жыл бұрын
Thanks
@lamoush19
@lamoush19 7 жыл бұрын
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.aprilmurdaugh7577
@dr.aprilmurdaugh7577 8 жыл бұрын
The was excellent! I am preparing to run an analysis. Very helpful.
@farmanullah2025
@farmanullah2025 6 жыл бұрын
very informative representation
@DrGrande
@DrGrande 6 жыл бұрын
Thank you
@Shayanerfan
@Shayanerfan 9 жыл бұрын
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!!!
@DrGrande
@DrGrande 9 жыл бұрын
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.
@Shayanerfan
@Shayanerfan 9 жыл бұрын
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!!
@claudiagarcia1893
@claudiagarcia1893 4 жыл бұрын
Thanks, thanks and thanks
@IamVishalVS
@IamVishalVS 4 жыл бұрын
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)
@anniemelbourne4302
@anniemelbourne4302 9 жыл бұрын
I have panel data with 80 firms, 7 years observation (2007-2013) with 16 indicators, but I got difficulties to input
@tarignassr6690
@tarignassr6690 6 жыл бұрын
Thanks a lot for your effort
@DrGrande
@DrGrande 6 жыл бұрын
You're welcome!
@Browning1ize
@Browning1ize 7 жыл бұрын
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".
@altromantaro
@altromantaro 4 жыл бұрын
Thank you sir
@heidierothschild8169
@heidierothschild8169 7 жыл бұрын
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
@joseph1719
@joseph1719 4 жыл бұрын
03:53 How did you code it Dr?
@zahirahwan506
@zahirahwan506 4 жыл бұрын
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
@juandresmith5076
@juandresmith5076 7 жыл бұрын
Good Day Todd. Please assist me with the following: Would i need to create numbers for open-ended questions like Nationality.
@manikrajbhandari5295
@manikrajbhandari5295 6 жыл бұрын
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 ...........
@TokyoNomad
@TokyoNomad 8 жыл бұрын
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?
@deepu2058
@deepu2058 6 жыл бұрын
Уянга Э same problem i have. What is the solution to it?
@MNISohel
@MNISohel 7 жыл бұрын
Thanks for the video...
@DrGrande
@DrGrande 7 жыл бұрын
You're welcome, thanks for watching -
@godloveakabinda8927
@godloveakabinda8927 8 жыл бұрын
Thanks a lot for the help
@mbrn3441
@mbrn3441 5 жыл бұрын
Thank you.
@fernandboutros-toni3283
@fernandboutros-toni3283 8 жыл бұрын
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 !!!
@momarmt4790
@momarmt4790 6 жыл бұрын
Meme problème pour moi.... Vous avez pu avoir une solution?
@PareshSalve
@PareshSalve 5 жыл бұрын
how to automatically generate variable view including with values from exce to spss?
@diadora48
@diadora48 6 жыл бұрын
Great tutorial, thanks!
@DrGrande
@DrGrande 6 жыл бұрын
You're welcome!
@karongofrank
@karongofrank 7 жыл бұрын
Thank you, soo much todd
@DrGrande
@DrGrande 7 жыл бұрын
You're welcome - thanks for watching -
@meriembkr94
@meriembkr94 7 жыл бұрын
Hello sir, thank you so much for your help
@DrGrande
@DrGrande 7 жыл бұрын
You're welcome, thanks for watching -
@gyorkos-szaboedit707
@gyorkos-szaboedit707 8 жыл бұрын
Thanks a lot!!!! Lifesaver!
@malkawiebtihall7551
@malkawiebtihall7551 6 жыл бұрын
It's helpful thank you
@HiDefinition1080p
@HiDefinition1080p 7 жыл бұрын
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?
@toluwalopemenoji9955
@toluwalopemenoji9955 5 жыл бұрын
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.
@iqrasohail9605
@iqrasohail9605 4 жыл бұрын
It seems easy hope while doing work it become more easy hope sy
@drrashumittal
@drrashumittal 6 жыл бұрын
amazingly simple..
@2007dodi
@2007dodi 4 жыл бұрын
What about the Age? how to code this? as I have the age as a category eg. 18-24
@megha7564
@megha7564 6 жыл бұрын
thank u very much for ur effort :D helped me!
@tabasumfareed6527
@tabasumfareed6527 3 жыл бұрын
Why do we need to do coding 2 times?
@willjfit9345
@willjfit9345 3 жыл бұрын
How did you code? I can’t figure out how to do it
@najmibasir
@najmibasir 4 жыл бұрын
thanks!
@challuribabu7911
@challuribabu7911 7 жыл бұрын
SIR NICE VIDEO HOW TO ADD LABEL IN EXCEL
@moltbeasilicontechno.8588
@moltbeasilicontechno.8588 4 жыл бұрын
hello sir, plz tell me how to create a label in this video, give me details plz as soon as posible
@indiequa
@indiequa 5 жыл бұрын
THANK YOU SO MUCHHHHHH
@vlacocabios
@vlacocabios 7 жыл бұрын
Which test would you use for those data? ANOVA or MANOVA?
@DrGrande
@DrGrande 7 жыл бұрын
It would depend on the research question, however, an ANCOVA would be a good fit here. The pretest would be the covariate.
@rajendrapm4363
@rajendrapm4363 4 жыл бұрын
7.45
@rickavory
@rickavory 3 жыл бұрын
can you please please get on with it?
@salwaelbouzidi6470
@salwaelbouzidi6470 3 жыл бұрын
apaaaaaaaah
@ebonyedillard5047
@ebonyedillard5047 5 жыл бұрын
Extremely helpful. Thank you!
@didi_setiyadi
@didi_setiyadi 7 жыл бұрын
Thanks Sir
@DrGrande
@DrGrande 7 жыл бұрын
You are welcome - thank you for watching -
How to import Excel file into SPSS
12:40
Elizabeth Wiredu
Рет қаралды 117 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 296 М.
Люблю детей 💕💕💕🥰 #aminkavitaminka #aminokka #miminka #дети
00:24
Аминка Витаминка
Рет қаралды 779 М.
Violet Beauregarde Doll🫐
00:58
PIRANKA
Рет қаралды 41 МЛН
The CUTEST flower girl on YouTube (2019-2024)
00:10
Hungry FAM
Рет қаралды 8 МЛН
Transferring Data from Microsoft  Excel to PSPP
9:30
Melanie Gurat
Рет қаралды 10 М.
Easy SPSS Tutorial: Import Data from Excel into SPSS
7:34
Testing the Assumptions for Pearson's R in SPSS
19:47
Dr. Todd Grande
Рет қаралды 24 М.
Converting Excel to SPSS and transforming data
7:06
Vahid Aryadoust, PhD
Рет қаралды 79 М.
How to use ChatGPT to analyze data in SPSS
8:01
Data for Development
Рет қаралды 46 М.
Properly Convert PDF to Excel
11:28
Leila Gharani
Рет қаралды 1 МЛН
Preparing Data in Excel to Import into SPSS
14:12
Dr. Todd Grande
Рет қаралды 209 М.
Люблю детей 💕💕💕🥰 #aminkavitaminka #aminokka #miminka #дети
00:24
Аминка Витаминка
Рет қаралды 779 М.