How to work out machine learning AUC in Excel
A client thought their WooCommerce recommendation engine was broken because accuracy at a 0.5 threshold read 51%. The ranking was fine, the threshold was not. This walks through checking AUC in a spreadsheet with sorted scores and the trapezoidal rule.