Teaching analytics with modern Excel
The growing excitement around artificial intelligence (AI) may lead you to wonder about the relevance of your Excel skills in an era increasingly dominated by intelligent machines and automation. I'm …
Continue Reading about How to make the transition into AI-Powered Excel →
PERCENTOF() functionOne of the more recent additions to Excel which I haven't seen receive much coverage is the PERCENTOF() function. This function calculates the percentage that a subset represents of a given dataset. …
Continue Reading about How to calculate proportions in Excel with the PERCENTOF() function →
Look what touched down in my mailbox today... 🏈 _Football Analytics with Python & R_ by Eric Eager and Richard Erickson. I had the pleasure to be a tech reviewer for this book …
Continue Reading about Review: Football Analytics with Python & R →
The analysis of variance or ANOVA is a statistical test to check whether there is a difference in means across multiple groups. In particular, the one-way ANOVA checks for the difference across one …
Continue Reading about How to perform a one-way analysis of variance (ANOVA) in Excel →
From Jordan Ellenberg's How Not to Be Wrong: The Power of Mathematical Thinking (a fantastic book for analysts): Derek Jeter, when bugged about being on pace to break Pete Rose’s career hit record, …
Continue Reading about Derek Jeter and the myth of “On pace for” →
Due to the differences in scope between data analytics/business intelligence and data science, there's a school of thought implying that data visualization and statistics are more or less independent …
Continue Reading about Demonstration of Anscombe’s Quartet in R →
