New Posts For Thread: Excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-helpHi excel helpersIs there a way to insert a 'line of best fit' column in excel based on data in other columnsFor example if you were assessing ratings and had columns with rating / runs / wins / strike rate, and the strike rate was not exactly linearthat download looks perfectly manageable. 'lowess smoothing' does it for me ..never thought i'd say that in publicStill doesnt quite hit the mark .. in practise i will be keeping the zero value from the raw data described above, then use the tool twihttps://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517527881#517527881that download looks perfectly manageable. 'lowess smoothing' does it for me ..never thought i'd say that in publicStill doesnt quite hit the mark .. in practise i will be keeping the zero value from the raw data described above, then use the tool twiWed, 14 Mar 2012 13:41:35 -0500i'm downloading Curve Expert and will look at the other suggestions, thanks for the inputhttps://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517526523#517526523i'm downloading Curve Expert and will look at the other suggestions, thanks for the inputWed, 14 Mar 2012 12:55:10 -0500thanks for everyones input during the day, yes thats what we're talking about toprated but big sample size so not erraticalso the second rated is fixed at 0 with very large sample size so thats going to be more or less 'accurate'. a straight line ishttps://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517526381#517526381thanks for everyones input during the day, yes thats what we're talking about toprated but big sample size so not erraticalso the second rated is fixed at 0 with very large sample size so thats going to be more or less 'accurate'. a straight line isWed, 14 Mar 2012 12:50:44 -0500I use CurveExpert to find the line of best fit. It's free , easy to use, and has loads of different models.https://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517525919#517525919I use CurveExpert to find the line of best fit. It's free , easy to use, and has loads of different models.Wed, 14 Mar 2012 12:36:58 -0500starfish and coffee - is your data something like this? A B C D 1 Rating Runs Wins SR% 2 79 23 2 8.7 3 80 43 3https://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517523949#517523949starfish and coffee - is your data something like this? A B C D 1 Rating Runs Wins SR% 2 79 23 2 8.7 3 80 43 3Wed, 14 Mar 2012 11:43:36 -0500"i dont want the results to be linear, rather they should represent the line of best fit from the data"of all the possible lines the one which fits best is a line exactly through all your data points. If this is what you want then the scatter charthttps://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517523099#517523099"i dont want the results to be linear, rather they should represent the line of best fit from the data"of all the possible lines the one which fits best is a line exactly through all your data points. If this is what you want then the scatter chartWed, 14 Mar 2012 11:20:44 -0500LINEST is the function you want. It will match a trendline exactly.https://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517522379#517522379LINEST is the function you want. It will match a trendline exactly.Wed, 14 Mar 2012 11:05:11 -0500NB I may be off the mark with those suggestions as I'm self taught and just muddle through this kind of stuff with what are probably wonky techniques.https://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517522161#517522161NB I may be off the mark with those suggestions as I'm self taught and just muddle through this kind of stuff with what are probably wonky techniques.Wed, 14 Mar 2012 11:00:21 -0500Depends on how your variables of course. If there are several then might the regression tool in data analysis add-on help?https://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517522123#517522123Depends on how your variables of course. If there are several then might the regression tool in data analysis add-on help?Wed, 14 Mar 2012 10:59:33 -0500You can use the INSERT tab to insert a graph of the data. And then if you right click on the line you can "add trendline" and then fiddle about with the best linear, logarthimic, exponential, polynomial fits. Tick the box to show the equation and thehttps://community.betfair.com/general_betting/go/thread/view/94082/28994945/excel-help?post_id=517522011#517522011You can use the INSERT tab to insert a graph of the data. And then if you right click on the line you can "add trendline" and then fiddle about with the best linear, logarthimic, exponential, polynomial fits. Tick the box to show the equation and theWed, 14 Mar 2012 10:57:51 -0500