In terms of the strength of relationship, the value of the correlation coefficient (rs) varies between+1 and -1. As the correlation coefficient value goes towards 0, the relationship between the two variables will be weaker.
The direction of the relationship is indicated by the sign of the coefficient; a + sign indicates a Direct relationship and a – sign indicates a Inverse relationship.
The following formula is used to calculate the Spearman rank correlation:
Go to: My Surveys » Select Survey » Analytics
Click on Correlation Analysis under the Analysis drop down.
Threshold section help user with the color coding of the cells which indicates the strength of the relationship between the variables. Direct correlation will have deafult set threshold to 0.65 and has 3 colors. If correlation coeffecient value is below 0.80 to 0.65(set threshold) cell will be colored with light green indicating low strength of relationship. If the value is between 0.80 to 0.90 cell is colored with medium green and if value is above 0.90 cell is colored with dark green indicating high strength of correlation between 2 variables.
When user enables inverse correlation, Cells with inverse relation gets highlighted. We have similar buckets in inverse correlation. If correlation coeffecient value is below -0.80 to -0.65(set threshold) cell will be colored with light red indicating low strength of relationship. If the value is between -0.80 to -0.90 cell is colored with medium red and if value is above -0.90 cell is colored with dark red indicating high strength of correlation between 2 variables.
Excel download with color coding of the cells is supported for the correlation analysis.Single select and multi choice questions are supported for correlation analysis.