ARIMA Forecasting with Excel and R

Hello! Today I am going to walk you through an introduction to the ARIMA model and its components, as well as a brief explanation of the Box-Jenkins method of how...

Linear Regression in Excel with Python

Expanding on my previous post about xlwings, I wanted to see if I could create a method in Excel to perform linear regression using statsmodels, a Python package for statistical...

Data Analysis with Python in Excel

I recently discovered xlwings, a package that allows you to work interactively with Excel and Python. You can read and write Excel from an IPython notebook, and it works perfectly...

Count Unique Values Using Excel

Hey, everyone! Today I'll walk through how to find non-destructively unique values in your data. I say 'non-destructively' because I notice it is common for people looking for unique values...

Parsing Text from Cells in Excel

What up Excel-party people! Coming at you with something that I find pretty useful and applies to a large number of situations, Parsing Words in Text Strings and Cells. Originally, the...

Excel Sumproduct Function and Applications

Today I'm going to introduce you to the awesome function that is SUMPRODUCT. You can tell I'm excited as this is one of my go to functions due to its...

Excel Vlookup Wildcards and Examples

Alrighty, imagine a situation where you have a set of data but aren't too familiar with it. Maybe it was handed off or whatever, and you need to figure it...