Chow tests with quadratic terms on random noise
Stata code: Output: In related news, Andrew Gelman is right.
A Cool SQL Problem (And Why It Is Also a Bullshit SQL Problem)
The Problem Your office needs to figure out the minimum number of rooms required to organize meetings for any particular day. To accomplish this task, you have a table with the following information: a meeting ID, a start time, and an end time: For any table of that format, figure out the number of rooms … Continue reading A Cool SQL Problem (And Why It Is Also a Bullshit SQL Problem)
Stream Python into PowerPoint with pp_stream
I like Python, don’t get me wrong, but it’s not Microsoft PowerPoint™, which is clearly the superior software in every way. Unfortunately, my managers don’t agree with me. When I do things in PowerPoint, they ask things like, “why aren’t you working?” and “why did we ever hire you?” Alas, I’m stuck working in Python. … Continue reading Stream Python into PowerPoint with pp_stream
Execute Python from Excel
Python is great, Excel is great. How cool would it be to run Python from an Excel workbook? “But that’s stupid,” you protest. … Yes, and? Copy and paste this into a VBA module in your Excel workbook, modify the parameters, create a helloworld.py in the same directory you’ve saved the Excel file, and enjoy. … Continue reading Execute Python from Excel
