A heat map is another statistical test option available in Harmoni. Through the use of colors (green to red), this feature helps you to can quickly see the highs and lows of significance in the results as a visual distribution across the entire table.
1. Heat Map
The heat map colors the cells in the table to show the quintile distribution within a row. It compares the data within each row and divides it into 5 quintiles (colors).
A quintile is a statistical value of a data set that represents 20% of a given population, so the first quintile represents the lowest fifth of the data (1% to 20%); the second quintile represents the second fifth (21% to 40%) and so on.
Harmoni assigns a green color to the cells with the highest values and red to ones with the lowest values. Meanwhile, the remaining values are assigned colors based on the descending value order showing a gradient of different shades falling between green and red.
Export to Excel or PowerPoint is currently not supported.
On a cross-tab view, select the Heat Map option under data labels in the modify menu under data labels.
Important Note:
When you apply Low sample warnings to the analysis and data points are removed, the cells are excluded from the heat map coloring.
If a single data point appears in a row, for example where data has not been captured across all markets, no coloring will show. A heatmap needs at least two data points to determine a minimum and maximum.