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
Click For Summary

Homework Help Overview

The discussion revolves around selecting appropriate non-linear regression methods for analyzing data that follows a non-linear pattern. Participants explore various polynomial and non-polynomial approaches to fit the data effectively.

Discussion Character

  • Exploratory, Conceptual clarification, Problem interpretation

Approaches and Questions Raised

  • The original poster attempts to determine whether Newton's interpolating polynomial or Lagrange's polynomial would be suitable for their data. Other participants suggest considering power functions, exponential functions, and logarithmic functions as alternatives. There is also a question about the functionality of Excel in producing these regression models.

Discussion Status

Some participants have provided suggestions regarding different types of non-linear regression methods, while others have raised questions about the capabilities of Excel in fitting data to these models. The discussion is ongoing, with multiple approaches being explored.

Contextual Notes

There are mentions of specific functions in Excel, such as LOGEST and LINEST, but there appears to be some uncertainty regarding their availability and how to use them effectively for non-linear data analysis.

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.
 

Similar threads

Undergrad What Are the Key Differences Between OLS and GLM Models in Statistical Analysis?
  • · Replies 3 ·
Replies
3
Views
3K
Undergrad How (un)reasonable is graphic linear regression in a monolog graphic?
  • · Replies 6 ·
Replies
6
Views
2K
Undergrad What are the commonly used estimators in regression models?
  • · Replies 23 ·
Replies
23
Views
4K
Undergrad What is Nonlinear Least Squares in Regression Analysis?
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad How to propagate errors through a regression & non-linear model?
  • · Replies 8 ·
Replies
8
Views
3K
Comparing Near-Infrared Spectra: What Stat Method?
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad Data Analaysis -- How to choose the best statistical model to use?
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad Observational Studies: What to Believe
  • · Replies 3 ·
Replies
3
Views
3K
Graduate Linear Regression with Non Linear Basis Functions
  • · Replies 4 ·
Replies
4
Views
2K
How Can I Determine the Linearity of Experimental Curves in Statistics?
  • · Replies 3 ·
Replies
3
Views
2K