SPSS- How to get a Qualtrics Data file ready for Analyses

In this brief video, I show an easy way to get experiment data collected using Qualtrics ready for analysis in SPSS. Specifically, I explain how you know which condition participants were assigned to and how to create variables that allow you to analyze the data with a one-way or crossed anova using point and click methods.

[@SofiaAbrantes]

You just saved my master thesis. THANK YOU!

[@jan122222222]

I hope it will save mine too

[@lexicarter4147]

So so so helpful, thank you!

[@dannstahh]

This is a great video which really helped me work out SPSS! The only thing I am struggling on is you say in order to do a One-Way Anova all that is needed is the conditions column made but how? If you could help I would really appreciate it! Many thanks

[@huntoon6393]

Hi Dani! So sorry that this response is so delayed. I didn't notice that this video's comments were no longer linked to my e-mail. I am sure you have already answered this question on your own, however if you still need help feel free to e-mail me at [e-mail]. Thanks!

[@eendraa]

Thank you very much, this was extremely helpful. I am subscribing.

[@olenayefimenko8482]

Hi Meg, thank you for your helpful video! Could you please also explain how to prepare the dependent variable for the analysis? Thank you!

[@huntoon6393]

I just responded to your email! 🙂

[@huntoon6393]

@@SpaGamingNL It depends on what your data looks like. Send me a little info ([e-mail]) about what you are trying to do and I'll see if I can help.

[@rufarobvocheko144]

@@huntoon6393 May you please help me out on this same issue trying to do a multiple regression using data from Qualtrics

[@huntoon6393]

@@rufarobvocheko144 Of course! Feel free to send me an email with a little info about your project (IV, DV) and I can see if I can help. My email is [e-mail] :)

[@依依-e5h]

It is super helpful!!

[@deadlypalms]

Useful video, thank you. Only distraction was your quick speed when coding the new variables and your habit of singing/raising inflection of your.....voice, at the end of each..action. Otherwise all good. :)

[@geraldkwazu4070]

Hi thanks for the Video. One question though; assuming the respondents are allowed to pick more than one response say fix and growth where both is not an option, how do I represent the response in a single table?

[@pascalton7129]

Do you have an answer to this?

[@Fabienne8973]

Hi, i have conducted an online experiment with 6 experimental conditions. In each condition, respondents had to answer the same set of questions. How do I organize this in spss?

[@huntoon6393]

Hello! Great question. Are you hoping to use a one way anova to analyse your data? If so, then you will create one condition variable with all six conditions represented. Please feel free to send me an e-mail at [e-mail] if you would like additional help with your specific data. Thanks!

[@joanacarneiro245]

So to do a 2 way ANCOVA, I need to do what you did after making the condition column? (I have one IV and one Moderator)

[@huntoon6393]

To run an ANCOVA you’ll have one variable that is categorical and one that is continuous. You’ll use this to get the categorical variable in order. If you have additional questions, you can send a little more information about your project to my email, [e-mail]) and I can try to help :)

[@bramvoets5213]

Thanks a lot! :)

[@faithwalker-swanton7484]

Great video. My only criticism is that it's a bit fast and therefore a little hard to keep up with.

[@emmachesworth523]

Hi Megatron, this video was very helpful and really helped me to clear my data up. I was just wondering how you got SPSS to change your data from numerical variables into words? Because this is something that I would really like to do as it would help me to have a clearer overview of my data.

[@huntoon6393]

Hi Emma! So sorry that this response is so delayed. I didn't notice that this video's comments were no longer linked to my e-mail. To change your variables to words you can click the "variable view" tab and then type over numeric (Q1, Q2) names using no spaces.

[@bumcikult]

or just press "value labels" if you did everything like it is shown in this video. I had the same issue, then i accidentally pressed that button and the names suddenly appeared

[@RowenaJBlake]

Thank you for the video, I am going to run a standard multiple regression, I have 3 IV’s each with 3 levels, would I add the 3 levels to make just 1 IV or should I keep them all as separate variables in the variable view to analyse?

[@huntoon6393]

Thank you for watching! If you have IVs with levels, you will want to dummy code them (or effect code) and calculate the interactions if you are using regression. If you need more info or have questions for your specific project, feel free to send me an email with some details and I will try to help :) [e-mail]

[@RowenaJBlake]

@@huntoon6393 wow, thank you so so much!

[@erlineileenelyn]

ver useful video, thanks!!! but i have questions, I get missing values in the new column (condition), what did it happen and how to solve it? thanks in advance

[@huntoon6393]

Erlin Fadillah Did you remember to type sum.1? That might be the reason that missing values are showing. Also, double check that your original columns weren’t missing data. That might be the case as well.

[@pattyashley101]

Thanks so much for this! I noticed that there were perfect columns with 1's indicating which condition participant was assigned to.. does that only happen when you export the data into SPSS? Cause I've been testing out my survey and results on Excel and it doesn't create a column for condition. So I've been struggling to figure out which participant is in which condition. I've been playing around with embedded data but I feel I'm confusing myself - especially since my survey flow looked a lot like yours!

[@huntoon6393]

Hi Patty, The columns that Qualtrics shows should match what you called the question. Feel free to e-mail me ([e-mail]) so we can chat about your specific survey to figure out what might be going on! Thanks!

[@huntoon6393]

Hi Patty! So sorry that this response is so delayed. I didn't notice that this video's comments were no longer linked to my e-mail. I believe that this column should show up when using excel as well. I wonder if you might not be getting this column due to the options selected in the export menu. You will want to make sure you are exporting the entire file.

[@marketingwitheva]

@@huntoon6393 I am experiencing the same issue..

[@marketingwitheva]

I solved it! The problem was when exporting the data!

[@dannidubig]

enure that yyou use the legacy format when downlaoding your file from qualtrics (not the table format). This either an option in the beginning or you find it on the very top right of the file download pop up screen