Dummy coding confusion
Posted: Sat Mar 18, 2023 1:45 am
Hi all,
I have a large data set, and am trying to complete a 2 x 2 factorial ANOVA. One IV is gender of participant (male or female), the other is gender of a target (target male or female). The DV is how trustworthy the target is rated. Both IVs a between subjects (participants only judged a male or female target)
As such the trustworthy DV is in separate columns for the target male and female, so I'm stuck on how to create the dummy variable for the target IV. I have been able to manage to compute two new variables, using the IF function to compute new variables. One variable shows "0" if the male target. The other variable shows "1" if the female target. However, now I can't work out how to combine them.
I am also interested if there is a way to use the "IF" function using information from two variables, as then I could ask that IF the target male trustworthy column, show a value to show "0", and if the trustworthy female column shows a value, to show "1."
I hope that makes sense. Any help is greatly appreciated.
PS. I have tried to export of excel using CSV, so I could just combine using excel, however the file is too large a data was lost.
I have a large data set, and am trying to complete a 2 x 2 factorial ANOVA. One IV is gender of participant (male or female), the other is gender of a target (target male or female). The DV is how trustworthy the target is rated. Both IVs a between subjects (participants only judged a male or female target)
As such the trustworthy DV is in separate columns for the target male and female, so I'm stuck on how to create the dummy variable for the target IV. I have been able to manage to compute two new variables, using the IF function to compute new variables. One variable shows "0" if the male target. The other variable shows "1" if the female target. However, now I can't work out how to combine them.
I am also interested if there is a way to use the "IF" function using information from two variables, as then I could ask that IF the target male trustworthy column, show a value to show "0", and if the trustworthy female column shows a value, to show "1."
I hope that makes sense. Any help is greatly appreciated.
PS. I have tried to export of excel using CSV, so I could just combine using excel, however the file is too large a data was lost.