I am conducting a logistic regression in order to examine whether there is an interaction between the number of stressors participants were currently experiencing (between 0-9) and their current levels of hopelessness (1-5 likert scale). The binary outcome variable/DV is whether participants did (1) or did not (0) experience suicidal thougts. All variables were centred round the mean (Z-scored) before being entered into the regression. We have a large sample size (over 12,000 participants). Multicollinarity should not be a problem as 'stressors' and 'hopelessness' are only correlared at rs = 0.31.
When I ran the regression, the effect of stressors was signficant, the effectt of hopelessness was significant and the interaction term was significant (all at p < .001). Please see the output in the attached file.
To probe the direction of the interaction, I have plotted the data using Jeremy Dawson’s excel sheet, ( http://www.jeremydawson.com/slopes.htm ) and I have also manually plotted the data. Both of these graphs show that the relationship between stressors and suicidal thoughts is much stronger under conditions of high hopelessness.
However, to formally test the direction of the interaction, I divided participants into 3 groups (low/medium/high hopelessness) and for each group I ran a binary logistic regression with suicidal thoghts (yes/no) as the DV and number of stressors experienced as the IV. In this analysis, the beta coeficient and the Exp(B) odds ratio shows the opposite to the plots. The Beta and Exp(B) value for stressors are (Low hopelessness: B = 0.70, Exp(B) = 2.01, medium hopelessness: B = 0.54, Exp(B) = 1.72, high hopelessness: B = 1.53, Exp(B) = 1.53). They show the relationship between stressors and suicidal thoughts being stronger under conditions of low hopelessness.
I have also conducted spearman correlations between stressors and suicidal thoughts at the levels of low/medium/high hopelessness and they show what the plots show, that he relationship between stressors and suicidal thoughts is stronger under conditions of high hopelessness (low hopelessness: rs = 0.3, medium hopelessness: rs = 0.13, high hopelessness: rs = 0.07).
I am at a complete lost as to why the follow up tests are different to the plots and the spearmen correlations. If anyone could shed any light on this or suggest any reasons for this I would be very grateful.
I can also confirm that I have checked the variable labels about 20 times and there is no mislabelling occurring.