Author Archives: GHP

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

Taxation Statistics by Postcode

Been looking to add average salary by Australian post code information to a data model that I am designing. Initially my searches, despite the power of google, didn’t come up with too much. The ABS site, you would think would … Continue reading

Posted in data, forecasting, regression, statistics | Tagged , , , | Leave a 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

R Cluster Analysis

Hi All, Have been fiddling about with various statistical packages for cluster analysis.  Been using SPSS and R namely, and will shortly use Minitab.  While I really like SPSS, as I find the Command Line infuriating these days, I was … Continue reading

Posted in forecasting, statistics | Tagged , , , , | Leave a comment

New job, etc

Haven’t posted in a while… Not in gambling anymore The black smudge on my heart that was working in the gambling industry, ceased 4 weeks ago, and now I work at a growing ASX 200 company in the Business Intelligence … Continue reading

Posted in data, life, statistics | Tagged , , , | Leave a comment