RE: The creation of the Excel English Premiership Football Prediction machine.
Cool, very simple method for setting this up and a well written post explaining it all. Resteemed my brother. It might be interesting to just take a look at the correlation between placement in a given year with placement the year before, just to see how good a predictive indicator the previous year's placement is. I am sure there will be a positive correlation, but to what degree? Maybe there are other easy to find/use historical metrics that have a stronger correlation with current success- maybe net goals scored the previous year (goals for minus goals against) as an idea off the top of my head? I know that in the sports I follow (American football and basketball mostly) plus/minus (net score differential) is typically a better indicator of actual strength of team than simple win loss.