Analytics & AI for Modern Excel
In analytics, variables vary and we wouldn't really have much to analyze if they didn't, as this post shows: Our goal is to make sense of how they vary, and one of the most important ways to do …
Continue Reading about How to find the mean, median and mode in Excel (Pros and cons of each) →
It's one of those questions where you could ask 10 data professionals and get 11 answers: what's the difference between statistics, data science and data analytics? (How's that for sample size?) …
Continue Reading about Statistics, data analytics, data science… oh my! (What’s the difference?) →
I've been known to kick an occasional hornet's nest on social media, at least when it comes to data. A recent cri de coeur has been to establish the primacy of statistical thinking in everything we do …
Continue Reading about Is data visualization part of statistics? →
A tabular dataset is arranged in two dimensions -- what in Excel we would call rows and columns, but a fancier statistical way of saying this is observations and variables. …
Continue Reading about Variables vary… and why that matters →
Anscombe's quartet is a well-known statistical parlor trick with a powerful message. Fortunately, with the help of the seaborn package as well as pandas, it can be demonstrated in Python with just a …
Continue Reading about How to visualize Anscombe’s quartet in Python →
Don't listen to the haters. Excel is a fantastic way to learn data analytics and a valued slice of the data analytics stack. That said, you may need to make a couple of tweaks from Excel's "default …
Continue Reading about Every dataset in Excel should include these two features →
