QuestionPro have opted cell comparison technique for highlighting the Most Significant cells. We consider the effect of other variables on the variable we study and see if there is any change in the percentage derived. Method opted for the calculation is column/cell comparison technique.
The cell highlighting option will only work if our Chi-Square Test confirms that there is an association between parent variables.
The highlighted cell would signify that the shown percentage is most significant when compared to other observation(It need not highlight the cell with the highest percentage).
This test will only confirm the cell is most statistically significant i.e. it is not affected by other variables and the percentage has not occurred as result of random chance variation.
In above mentioned example we can read the data as:
For Gender = Male, Drink = Coca-Cola and Age: 15-25 cell comparison calculation will be
Which comes to be 50.1%.
Now we calculate the p value between 100% and 50.1%.
Likewise we do the calculation for all the cells. we take mean of these p values. Any value below the mean is considered to be most significant variable and will be highlighted.
Since for Gender: Male, column Coca-Cola and Age: 15-25 there is no highlight of the cell this states percentage of the sample who prefer Coca Cola as the drink will vary when we consider the impact of other variables. Hence any promotional activity by the competitor like Pepsi or any other drink or even any other age category people can affect the buying decision of coke customers.
This feature is available with the following licenses :