New Posts For Thread: Excel questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-questionI'm trying to calculate a set of 'best fit' values for some non-linear data. When I add a trendline line to an Excel chart, I find that a 6th order polynomial is a really good fit for the outputs I have. However when I feed the x values into the eqThanks for the hint speedypro. Heres the thing though. In answer to Frog Hairs (rhetorical?) question earlier, the query is gambling related and concerns data gathered from 1,484 races over the last 10 weeks. The data produces an output value forhttps://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940390#420940390Thanks for the hint speedypro. Heres the thing though. In answer to Frog Hairs (rhetorical?) question earlier, the query is gambling related and concerns data gathered from 1,484 races over the last 10 weeks. The data produces an output value forSat, 03 Apr 2010 09:53:34 -0500Thanks only223. That's a nice peice of software - easy to use and produces exactly what I was looking for.https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940382#420940382Thanks only223. That's a nice peice of software - easy to use and produces exactly what I was looking for.Sat, 03 Apr 2010 09:25:17 -0500Hint: A 6th order polynomial best fit means you are fooooking way off..Try again.https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940358#420940358Hint: A 6th order polynomial best fit means you are fooooking way off..Try again.Sat, 03 Apr 2010 07:45:12 -0500I use curveexpert. It has a better curve finder utility and it's free!https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940354#420940354I use curveexpert. It has a better curve finder utility and it's free!Sat, 03 Apr 2010 07:09:47 -0500Cheers Cosmic. This is starting to look a lot better. First try with 10 decimal places wasn't enough, but at least the output is starting to bear some resemblance to the actual data now.https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940346#420940346Cheers Cosmic. This is starting to look a lot better. First try with 10 decimal places wasn't enough, but at least the output is starting to bear some resemblance to the actual data now.Sat, 03 Apr 2010 06:41:56 -0500And dogrelata calls himself a layman !Demoralizing to say the least.https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940282#420940282And dogrelata calls himself a layman !Demoralizing to say the least.Fri, 02 Apr 2010 20:23:08 -0500When I read threads like this, I really feel inadequate.Is this all gambling related ?If so, the mind boggles.https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940278#420940278When I read threads like this, I really feel inadequate.Is this all gambling related ?If so, the mind boggles.Fri, 02 Apr 2010 20:21:06 -0500Increase the number of decimal places. If you have the equation on the chart, right click it, select "format trendline label", select "number" under catagory, then alter the number of decimal places from 2 to 10 (or whatever).https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420940274#420940274Increase the number of decimal places. If you have the equation on the chart, right click it, select "format trendline label", select "number" under catagory, then alter the number of decimal places from 2 to 10 (or whatever).Fri, 02 Apr 2010 20:15:21 -0500Thanks Mac, I'll check it out.https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420939990#420939990Thanks Mac, I'll check it out.Fri, 02 Apr 2010 11:23:49 -0500Maybe try using SPSS. Think there's a free trial here: http://www.spss.com/uk/statistics/https://community.betfair.com/general_betting/go/thread/view/94082/23535890/excel-question?post_id=420939986#420939986Maybe try using SPSS. Think there's a free trial here: http://www.spss.com/uk/statistics/Fri, 02 Apr 2010 11:15:35 -0500