Hi,
I have the following table, which is a little output from the data that I have.
I would like to create a new variable (new_var_5) by dividing var_1 and var_2 and also create another new variable (new_var_6) by dividing var_3 and var_4. I'm doing this so I'll be able to run different t-tests afterwards comparing the mean of new_var_5 and new_var_6. I know how to create new variables by dividing the two others, but the problem is that there are several zero-values in the columns that I want to divide resulting in a lot of missing data.
Therefore, my question is - how would you deal with this, so I'll be able to compare the means of new_var_5 and new_var_6 without missing a lot of data that is still relevant for my research-question?
Thank you very much!
Regards Nanna
I have the following table, which is a little output from the data that I have.
I would like to create a new variable (new_var_5) by dividing var_1 and var_2 and also create another new variable (new_var_6) by dividing var_3 and var_4. I'm doing this so I'll be able to run different t-tests afterwards comparing the mean of new_var_5 and new_var_6. I know how to create new variables by dividing the two others, but the problem is that there are several zero-values in the columns that I want to divide resulting in a lot of missing data.
Therefore, my question is - how would you deal with this, so I'll be able to compare the means of new_var_5 and new_var_6 without missing a lot of data that is still relevant for my research-question?
var_1 | var_2 | var_3 | var_4 | new_var_5 | new_var_6 |
2 | 4 | 2 | 2 | 0.5 | 1 |
5 | 10 | 5 | 20 | 0.5 | 0.25 |
0 | 10 | 0 | 5 | . | . |
10 | 10 | 0 | 2 | 1 | . |
Regards Nanna
Comment