Tag Archives: the remote show

Excerpts from Superforecasting: The Art and Science of Prediction

I read a few excerpts from Superforecasting: The Art and Science of Prediction by Philip E. Tetlock and Dan Gardner. What does it mean to be a good forecaster? How can we take lessons from the book to be better modelers? I just started reading the book but already have learned so much about forecasting, […]

The debate over VLOOKUP versus INDEX/MATCH in Excel

Should you use VLOOKUP or INDEX/MATCH in Excel? What are the pros and cons of each method? When you lookup data in Excel, you have the option to use either VLOOKUP or a combination of INDEX and MATCH functions. There is a huge debate over which method to use, and I break down the pros […]