What Are the Best Non-Linear Regression Methods for Analyzing Data Patterns?

  • Thread starter Thread starter Cygni
  • Start date Start date
  • Tags Tags
    Linear Statistics
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
Sign up Log in
3 replies · 2K views
Cygni
Messages
38
Reaction score
0

Homework Statement


Hi, the problem that I am struggling with is getting an appropriate method to produce non - linear line of regression when the data follows non - linear pattern.

Homework Equations



Would it be appropriate to use Newton's interpolating polynomial or Lagrange's polynomial at such circumstances? (one could select the most appropriate data points and then construct a polynomial using either method). Perhaps there are other methods that could be in this situation?
 
Physics news on Phys.org
No one has responded, so I'll take a shot. There are lots of options to choose from after you decide a regression line won't do the job, and the option to use would depend on your data. Besides using power functions or polynomials (including the two you mentioned), other options are exponential functions or logarithmic functions. Many spreadsheets, such as Excel, have this functionality, and let you choose which type to use.
 
Mark44 said:
No one has responded, so I'll take a shot. There are lots of options to choose from after you decide a regression line won't do the job, and the option to use would depend on your data. Besides using power functions or polynomials (including the two you mentioned), other options are exponential functions or logarithmic functions. Many spreadsheets, such as Excel, have this functionality, and let you choose which type to use.

Mark44, thank You for your response. I have came across the fact that excel can produce various functions for the data, however, I was unable to find the expression of such functions in the excel, and therefore I am unable to extrapolate the data. Perhaps there is something i do not know about excel?

Regards,
Cygni.
 
There is the LOGEST function in Excel that can be used to fit your data to a curve of the form y = bmx. There is also LINEST, which you can use to fit your data to y = mx + b, a straight line. I thought I remembered Excel having other functions of this type, but I don't see them in my copy of Excel 2007.