Category Archives: Uncategorized

Calculate the Number of Days Between Dates in Excel

Hi again, There is a really useful undocumented function in Excel called Datedif().  It calculates the differences between two given dates in the unit of time specified: = DATEDIF ( start_date , end_date , unit ) The function has three … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Excel 2007 Table Formula Issue

Excel Tables are a convienient way to arrange and reference your data in a spreadsheet. However I had an infuriating problem with formulas not working within my table. No amount of cell reformatting, cutting and pasting, or resizing table dimensions … Continue reading

Posted in Uncategorized | Tagged , , , | 1 Comment

R Binomial Regression

Been doing some propensity modelling recently using R glm package, but upon recommendation from a professional in my network, I wanted to try k-fold cross validation to asses the accuracy of my model. So doing some research I found a … Continue reading

Posted in data, forecasting, R, statistics, Uncategorized | Leave a comment

Propensity Modelling

Been doing some propensity modelling recently.  There are some really good articles out there on how to perform the Binomial Regression.  Provided you’ve setup your data correctly, it’s fairly straightforward. This is a really good simple example: http://www.jameskeirstead.ca/r/how-to-binomial-regression-models-in-r/ Slightly more … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Clive James

I’ve always liked Clive James, here are some transcripts of his talks…I particularly like this one about his battles to give up smoking… http://www.clivejames.com/point-of-view/smoking

Posted in Uncategorized | Leave a comment

Cassandra/Hadoop/Apache Stuff

I posted a few weeks ago that I was going to look into this Hadoop stuff.  Well, I actually looked into the “Cassandra” project…and managed to get it going on a LAMP stack Cassandra is “A scalable multi-master database with … Continue reading

Posted in Uncategorized | Leave a comment

The Demons – in turmoil again/How to run a professional sports organisation

The Australian Rules football club I support here in Melbourne – the Melbourne Football Club – are in turmoil again after a near record thrashing at the hands of the Geelong Cats. To be honest with the work on my … Continue reading

Posted in Uncategorized | 1 Comment