
Calculus Calculus Math Forum 
 LinkBack  Thread Tools  Display Modes 
November 21st, 2014, 07:48 AM  #1 
Newbie Joined: Aug 2012 Posts: 17 Thanks: 0  Is this the best hyperbolic fit to this data?
I tried to fit a hyperbolic trendline to my data using the inxtructions here: How can I add in a hyperbolic regression curve in Excel 2010?  Microsoft Community Since this way excel wont give me R^2 I used this to calculate it https://www.khanacademy.org/math/pro...tingrsquared and the result was: R^2 = 0,437225524 This was a bit less than I was anticipating so I would like to know if there is a better way to fit a hyperbolic curve to my data. I think my R^2 calculation is ok since it works well with real excel trendlines. Data and all calculations can be found here: https://dl.dropboxusercontent.com/u/54506834/test.xlsx 70k, 500 rows (It's a bit much to copypaste) Thank you for the help 
November 21st, 2014, 11:23 AM  #2  
Senior Member Joined: Jan 2012 From: Erewhon Posts: 245 Thanks: 112  Quote:
Do you have a theoretical reason for seeking a hyperbolic fit? There are other models that will give better fits but they are of no use if your are forced to a hyperbolic. A model of the form: $$y=\frac{m(x+a)}{(x+b)}$$ will give a very much better fit The attachment shows plots of your data, the hyperbolic fit and the least squares fit of the above model ($r^2=0.966$). The fit is obtained using the nonlinear solver in Gnumeric, there is one for Excel also but it is not always installed. CB Last edited by CaptainBlack; November 21st, 2014 at 11:28 AM.  
November 21st, 2014, 12:20 PM  #3 
Newbie Joined: Aug 2012 Posts: 17 Thanks: 0 
Wow that's awesome. I do have a reason to look for the best possible hyperbolic fit, but I am also interested in the best possible fit of any kind of simple function. Is it reasonable to believe that a better hyperbolic curve could have a significantly better r2? Like 0.6 or 0.8? I tried a power law function and that had a r2 = 0.95 so yours is indeed better. I will try out the nonlinear solver, although I'm not really sure how I can get m, a and b using it. EDIT: Ok I managed to do it. My values are: m = 0,077276363 a = 58163,47999 b = 63221,98938 I wonder does this function have a limit x>infinity? Last edited by nekdolan; November 21st, 2014 at 12:52 PM. 
November 21st, 2014, 12:39 PM  #4  
Senior Member Joined: Jan 2012 From: Erewhon Posts: 245 Thanks: 112  Quote:
CB  
November 21st, 2014, 01:41 PM  #5 
Newbie Joined: Aug 2012 Posts: 17 Thanks: 0 
Thanks than that's that, but I still would like to know (see my second edit) the limit of the function you have found. It seems to be around 0.0.07727? That's a very rough guess on my part. Not sure how you can do this... 
November 21st, 2014, 09:57 PM  #6 
Senior Member Joined: Jan 2012 From: Erewhon Posts: 245 Thanks: 112  

Tags 
data, fit, hyperbolic 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Rolling 3 months YOY data to Monthly YOY data  lumpa  Real Analysis  0  October 19th, 2012 09:07 AM 
hyperbolic tangent  e21959  Calculus  4  April 4th, 2012 12:30 AM 
hyperbolic PDE  uri  Applied Math  0  October 6th, 2009 07:56 AM 
How to regress actual data towards projected data.  BigLRIP  Advanced Statistics  1  May 18th, 2009 11:01 AM 
hyperbolic tangent  e21959  Trigonometry  0  December 31st, 1969 04:00 PM 