New Posts For Thread: Statistical questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-questionI've got a set of data measuring a supremacy of team A over Team B in one column and then the percentage of draws produced so far for each rating in another rating.I put this into a scatter graph to produce a trendline and equation, however not unexpAwesome, thanks again.https://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153418#419153418Awesome, thanks again.Wed, 25 Nov 2009 09:34:00 -0600right click on the equation on the chart. format data labels . etc etchttps://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153390#419153390right click on the equation on the chart. format data labels . etc etcWed, 25 Nov 2009 06:12:59 -0600I assumed you could losers, but never found how, I can google that now I know you can though, thanks :)https://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153350#419153350I assumed you could losers, but never found how, I can google that now I know you can though, thanks :)Wed, 25 Nov 2009 03:47:59 -0600lori - you can change the number of decimal places by changing the format of the displayed equation.https://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153346#419153346lori - you can change the number of decimal places by changing the format of the displayed equation.Wed, 25 Nov 2009 03:43:52 -0600Don't set the polynomial settings higer than the data requires just to get it to fit.The polynomial should only have the same number of inflexion points as the data you're fitting.https://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153326#419153326Don't set the polynomial settings higer than the data requires just to get it to fit.The polynomial should only have the same number of inflexion points as the data you're fitting.Wed, 25 Nov 2009 02:51:02 -0600Cheershttps://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153322#419153322CheersWed, 25 Nov 2009 02:47:54 -0600Set the trendline to polynomial 2 (or bigger), beware of going too high as it seems to not display enough significant figures to copy the formula and have it still workhttps://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153310#419153310Set the trendline to polynomial 2 (or bigger), beware of going too high as it seems to not display enough significant figures to copy the formula and have it still workWed, 25 Nov 2009 02:39:04 -0600Draw=33%https://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153306#419153306Draw=33%Wed, 25 Nov 2009 02:10:57 -0600What I normally do with this sort of thing is just make all the supremacies positive i.e. =SQRT(A1*A1)Can't see any obvious flaws unless you believe there is a fundamental difference between say a 0.5 goal home fav and a 0.5 goal away fav.https://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153302#419153302What I normally do with this sort of thing is just make all the supremacies positive i.e. =SQRT(A1*A1)Can't see any obvious flaws unless you believe there is a fundamental difference between say a 0.5 goal home fav and a 0.5 goal away fav.Wed, 25 Nov 2009 01:24:34 -0600top line should read - in another column.thankshttps://community.betfair.com/general_betting/go/thread/view/94082/23469358/statistical-question?post_id=419153298#419153298top line should read - in another column.thanksTue, 24 Nov 2009 19:41:12 -0600