Hi,

In short, I've done some regression analysis into goals scored statistics in the English Premiership (the coefficient is decent - about 0.86 R2) and am trying to work it up into something using data tables (I know there are flaws in this method but it's a start).

In short looking at the attached, you key in what's in red (minutes played, shots on target, goals scored) and the table generates a predicted number of goals scored over a season (5000 games essentially in a 5000 line data table or 131-ish seasons, essentially enough to minimize random fluctuations). You can then compare this to what the player has scored to get an above or below expectation rating. Again there are flaws - e.g. would the top goal scorer score 5 goals a game in the Premiership 1 in every 1000 games but anyhow......

What I am looking to do though is get a maximum and minimum value for F36 (I've set this up for F38 and F39). Ideally what I would like to is get it to calculate say 10, or 100 times (so 50,000 games essentially or 500,000) and have a maximum and minimum value recorded. In short I can't see a way of doing this as F36 is purely as a result of the data table, and hence there is only one figure at any one time and hence no maximum and no minimum as there is only one value if that makes sense?

In short is there a way round this (I could scribble the results down on paper I realise but that's less fun).

Thank in advance,

Goal Workup Idea Players 5000 Trials_RevA.xls