I'll be presenting online at the Excel Virtually Global online conference, this coming Weds, Oct 11 2024 at 1pm Eastern US time on the topic, "Modern Data Analytics in Excel." Get all the details …
How to perform predictive analytics in Excel using the XLMiner add-in
When you think of predictive analytics, maybe you picture programming languages like R and Python or cloud platforms like Azure or Amazon AWS. The humble Excel spreadsheet is probably not top of mind …
Continue Reading about How to perform predictive analytics in Excel using the XLMiner add-in →
How to perform a paired samples t-test 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 →
Python was not designed for data analysis (and why that’s OK)
A major reason I think it’s easier for Excel users to pick up R versus Python is that these tools tend to "think" more similarly than Python. See what I mean here: let's take a range of numbers and …
Continue Reading about Python was not designed for data analysis (and why that’s OK) →
How to add data to the left of an Excel table
This is something that happens to me all the time: I've got data in an Excel table and want to add an index column (because I believe every dataset should have an index column). Index columns …
Continue Reading about How to add data to the left of an Excel table →
Welcome to my data meme page
If you work with data, you need a good laugh every now and again. And nothing says "Internet break" like a good meme trawl. Now, I like a meme just like the next guy, but I have trouble thinking …