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 ARIMA models are specified. Lastly, I created an Excel implementation using R, which I'll show you how to set up...

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 analysis. The purpose of this was to create a method for performing linear regression in a ubiquitous front-end like Excel...

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 with NumPy and pandas. I made an IPython notebook exploring some uses of xlwings while working with a statsmodel example....

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 in range to use the Remove Duplicates command. While this does work, it also deletes all your other data. To...

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 idea of the function was to help keep better track of our assets and other things by automatically building reference...

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 power and how modular it is. You can apply it to a vast number of situations and use it to...

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 out quick. Well, instead of painstakingly going through the data set looking for something that you remember seeing, but don't...