12/14/2022 0 Comments Data analysis excel correlation![]() When using this conditional formatting rule, any cells with a correlation coefficient value of -1 will be coloured red. In the rule description underneath, use the dropdown menu to change the style to a 3-color scale. Select format all cells based on their values as the rule type. This can easily be done in Excel by using the conditional formatting.įirstly, highlight all the values in the table, and then go to Home> Conditional Formatting> New Rule. Sometimes, the cells in a correlation matrix are coloured based on their coefficient values. How to colour code the cells in the correlation matrix ![]() If you wanted to go a step further and calculate a p-value for the Pearson correlation test to see if the result is significant, then I refer to my tutorial on performing a Pearson correlation test in Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |