Teaching analytics with modern Excel
I've mentioned a few times on this blog (example) about the growing possibility for Python <> Excel interoperability. Here's a simple task done in a way I wasn't aware of (h/t -- where else? -- …
Continue Reading about How to list the worksheet names of an Excel workbook using Python Pandas →
This event has concluded. You can view all slides, datasets and demo notes used for the masterclass here. Want this presented at your workplace? Get in touch for corporate training. If you haven't …
Continue Reading about Data analytics in modern Excel (Global Excel Summit masterclass 2023) →
One of the best things you can do as an analyst is add context to your numbers. As Edward Tufte put it, frame the problem with the question "Compared to what?" in mind. Often in business …
Continue Reading about How to add a date table to the data model in Excel Power Pivot →
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 →
