Видео

I work with Nick and would be happy to answer your question about the purple callout text. The typeface is called "Segoe Print" and the color code is #7030A0. Take care!

@@bryanpierce616 many thanks

Thanks, Stacey! Delighted that you found the video to be of interest!

Glad you found the video to be useful!

Thanks!

No problem 😊

It was actually created in Excel, using conditional formatting (and making the numbers in the cells invisible, see support.microsoft.com/en-au/office/hide-or-display-cell-values-c94b3493-7762-4a53-8461-fb5cd9f05c33 )

@@practicalreportingthis will only work if the value we want to represents are inside the table. What if we wanted to see the frequency of that value and represent that in the heatmap? in this vid that would be for example 20 people with >120k salary. Our data would have 20 different names with >120k salary. To represent that 20 people we need a table of countif salary>120k and we need to do this for each salary band. Then we do the conditional formatting.. CMIIW. Good vid!!!

@marior6662 To make a distribution heatmap, yes, each cell has to contain (or be associated with) the number (or %) of values that fall within that cell. That value then determines the color of that cell. The example that I showed was created in Excel using conditional formatting, and the numbers in the cells were made invisible using this trick: support.microsoft.com/en-us/office/hide-or-display-cell-values-c94b3493-7762-4a53-8461-fb5cd9f05c33#:~:text=Hide%20cell%20values&text=On%20the%20Home%20tab%2C%20click,Type%20%3B%3B%3B%20(three%20semicolons).

LOL! Thanks!

Thanks!

Well, skewness in general (not just 1.113) will appear in a box plot as the "whisker" and/or "box" sections at one end of the box and whisker shape being shorter than the box and whisker shapes at the other end. In a distribution heatmap, skewness appears as colored cells at one extremity of a column of cells being darker than cells at the other extremity. Kind of hard to explain without visual aids...

Okay

I am!

@@practicalreporting sorry.....i am watching too much of "how i met your mother"

Thanks, Raymond. I appreciate it when marketing materials get straight to the point and skip the superlatives and buzzwords, so I try to do the same in my own materials.

I didn't cover it in the video, but there's a widely used convention for determining what's an outlier and showing them in a box plot. This article describes it: www.real-statistics.com/excel-capabilities/creating-box-plot-outliers-manually/

You're welcome!

Delighted that you found the video to be useful, Anthony!

Thanks!