Post 5 of 5: #Excel ‘s # Dynamic Arrays # meets Anscombe´s Quartet, The Datasaurus Dozen and DataTrump from Alberto Cairo. In data visualization, very often you come across this mantra: “always visualize your data” thank you Alberto! This topic is highly recommended to read about, as you will see below, (top left corner) the summary statistics of all these visuals remain the same! (except “DataTrump”) It´s impressive!
Below it´s the combination of dynamic arrays with a scatter plot, a pivot table slicer, the FILTER & XLOOKUP functions and all combined, assisting in plotting all the visuals and “DataTrump” 🤣🤣🤣 As always, you can download the file here 👉 https://lnkd.in/dN49MPM with chart name: “014: Anscombe´s Quartet” ….. until next time!
now let´s dance to some good Brazilian Samba Music! #StayStrongBrazil
p.s. many thanks to George Fitzmaurice and Justin Matejka for sharing the “The Datasaurus Dozen dataset”. More about this dataset here 👉 https://lnkd.in/dmKWqgp