Hi there! This trick is for numerical data. It won't work for nominal data, but there are other tricks you can do. Perhaps the simplest if you have few participants is sorting the data and then a quick copy and paste, if I am honest with you :) Feel free to send me an email of you have additional questions ([email protected]).

Hello! Thanks for your comment! I would change one of them to a different number before the merge by recoding them. That should do the trick :) email me if you have questions about how to do that ([email protected])!

Hi! Thanks for your comment! If I’m understanding correctly, you’re looking to create a count of the number of „low“responses? If so, check out this video: kzbin.info/www/bejne/j4K2fH-Coa-Gm8k If that’s not quite what you were looking for, send me an email and I’ll try to help! [email protected]

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, [email protected]) and I can try to help :)

Thank you for watching! It depends on how your variables are set up (are they string variables or numeric) and is there data in both variables that you are hoping to combine. If you would like, send specifics about your data to my email ([email protected]) and I can help you decide which method will be best for your project.

I just responded to your email! 🙂

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

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

@@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 [email protected] :)

And I figured it out... you need to select "String" for output type with you select compute variable, make sure the length fits the length of your string then use CONCAT(V1, V2, ...)

The Funky Deep great! Glad you figured it out! Good luck with your work.

@@huntoon6393 thanks!

I hope it will save mine too

Do you have an answer to this?

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.

Naomi van Bree Hello! Thank you for your comment. Are you trying to combine the separate columns in your data like is shown in the video? If so, then this method will work the same as shown with your design, only you will need to add all the columns for each DV (in your case, three for each). If instead you are hoping to code your IV to fit with the analyses you want to run, then how you code them will depend on what you are hoping to do with the data. Does that help?

@@huntoon6393 Thank you for your quick reply! Firstly, I created a "condition" column like you showed in one of your previous videos. I have 5 conditions in total, one of which is the isolated control group that was not exposed to the treatments. Then I created two new variables for my IVs. However, I don't know how to code these variables. Should I use effect coding like 1 for humor and -1 for serious or dummy coding like 1 for humor and 0 for serious? Or can I do it like you did it in your previous video (1 = humor, 2 = serious). I want to perform a 2 by 2 ANOVA in which I compare the means of my treatment groups (and the interaction between my IVs). But I also need to compare my control group with my treatment groups. However, basically the data for my control group is "missing" for my IVs, since this group was not exposed to any of the treatments. I don't really know what value to put for this group in my two columns for my IVs. The same goes for one of my dependent variables. I only measured it for my treatment groups but not for my control group. If this isn't clear, is there a way I can maybe e-mail you to show some screenshots and explain more clearly what I mean?

Naomi van Bree Naomi van Bree That makes sense. If you have a priori hypotheses, I would use planned comparisons to analyze your data. I don’t have a video on that type of analyses, but there are many of them out there. If you want to run a regular anova, I would code the control condition as 0 in one of your IVs. In that case, you will have a 2(humor vs none) x 3 (solution vs none vs control). I believe running the analyses in this way will provide you the tests you are hoping for. One thing I am struggling to understand is what your control condition adds beyond the group who received no humor and no solution, but I am likely just not picturing the design correctly in my head. Was it that the control condition didn’t receive any stimuli?

@@huntoon6393 My research is about webcare responses. Basically, one group received a message with humor but without a solution, another group received a message with humour and with a solution, another group received a message without humor (serious) without a solution and finally one group received a serious message with a solution. The control group did not receive any message. This group was therefore not exposed to the two IVs. I created the two IVs in my dataset. Since my control group wasn't exposed to any of the IVs at all, I'm not sure what value I need to put for this group in my two IV columns. If, for example, I code humour versus serious with 1 and 0 (e.g. 1 = humour, 0 = serious), how do I code the group that did not get exposed to humour at all? What value do I put in there?

Naomi van Bree Ok. That makes sense. You can code the control group as I suggested in my previous reply to run an anova. The output will give you comparisons and interactions for each group. You will also want to request the means so that you can tell the direction of effects. And of course follow up any significant interactions with post hoc tests.

Hello, you can e-mail me at [email protected]. Thanks!

Yes, you can use syntax to combine the columns. This method was covered on this research gate thread: www.researchgate.net/post/How_do_I_combine_2_variables_in_SPSS_into_one_and_copy_the_values_from_the_original_variables

Hi Ruben! Thanks for watching. Can you post or e-mail ([email protected]) me the formula you typed into the compute variable box? Is it possible that you are missing a parenthesis or comma or have an equal sign that isn't needed?

Already solved the problem, still thank you for your response!

Great!! Glad you fixed it!!

Hi Ruben, I ran into the same problem. Could you please share how you resolved it? Thanks!

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.

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

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 [email protected]. Thanks!

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

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.

@@huntoon6393 I am experiencing the same issue..

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

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

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 [email protected] if you would like additional help with your specific data. Thanks!