Hi
In my research I am investigating the relationship between HEXACO personality Inventory 60-item and Organizational Citizenship Behaviour Motives Scale 10-item. I ran shapiro.test to check for normality and almost all variables were not normally distributed.
My first question: what correlation type is better to use?
Second, how to create a correlation matrix in Excel for the six traits (Honesty-Humility, Emotionality, Extraversion, Agreeableness, Conscientiousness & Opennes to experience), and the OCB motives (impression management, organizational concern and prosocial values)?
Thank you