Teaching analytics with modern Excel
Het kopen van Cialis Generiek, ook wel bekend onder de naam Tadalafil, is een goedkoper alternatief voor het bestellen van de originele merkgeproduceerde hulpmiddel. Dit houdt echter niet in dat er …
Continue Reading about How to add tables to the data model in Excel →
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 →
The paired samples t-test can be used to test for a significant difference in measurements across observations from one time period to another. This post will demonstrate how to conduct the test using …
Continue Reading about How to perform a paired samples t-test in Excel →
I love the "Modern Excel" suite of tools and wish more spreadsheet users would adopt them. But I can understand the slow adoption... it's confusing! For example, you may be interested to start using …
Continue Reading about What’s the difference between Get & Transform and Power Query in Excel? →
If, as I write in Advancing into Analytics, lookup functions like VLOOKUP() are the duct tape of Excel, then relational joins in Power Query are like a full-on blowtorch, allowing you to contort data …
Continue Reading about How to do a Cartesian/cross join in Excel Power Query →
Excel PivotTables are great for summarizing a variety of columns of a dataset in a variety of ways. But there's one particular use case where the classic PivotTable falls short. Let's take a look at …
Continue Reading about How to get the count of distinct items using Excel PivotTables →
