Ask for constructing function from coordinate(x,y) points

  • Context: MHB 
  • Thread starter Thread starter bundit
  • Start date Start date
  • Tags Tags
    Function Points
Click For Summary
SUMMARY

This discussion focuses on deriving a function expression from a set of coordinate points using Excel for trendline fitting. The user, Bundit, presents six coordinate points and seeks to establish a non-linear relationship, hypothesizing an exponential model. The recommended best fit equations include a quadratic model, \(y=303.31x^{2}-151.14x+24.221\) with an \(R^{2}\) value of 0.9895, and a cubic model, \(y=1357.5x^{3}-1205.6x^{2}+387.32x-36.859\) with an \(R^{2}\) value of 0.9968. An exponential fit from Wolfram Alpha is also mentioned, yielding an \(R^{2}\) value of 0.9969.

PREREQUISITES
  • Understanding of coordinate geometry and plotting points
  • Familiarity with Excel's trendline fitting capabilities
  • Knowledge of polynomial equations and their forms
  • Basic understanding of the coefficient of determination (R²)
NEXT STEPS
  • Learn how to use Excel's trendline feature for polynomial regression
  • Explore the concept of R² and its significance in statistical modeling
  • Research interpolation and extrapolation techniques for data analysis
  • Investigate other software tools for curve fitting, such as MATLAB or Python's SciPy library
USEFUL FOR

Data analysts, statisticians, students in mathematics or engineering, and anyone interested in modeling relationships between variables using coordinate data.

bundit
Messages
2
Reaction score
0
Hello,

I'm new in this forum. I would like to know how to calculate to obtain the function expression of some given coordinate points(x,y). For example, if I have 6 coordinate points which are

(x,y)
(0.23, 4.5)
(0.25, 6.5)
(0.35, 8.8)
(0.43, 15)
(0.45, 17)
(0.5, 25)

The (x,y) relation are apparently not linearized. It seems to by y=a.exp(b.x). How to calculate to derive the equation of y in term of y=f(x)?

Thank you.
Bundit
 
Physics news on Phys.org
My recommendation: Excel. Plot the points up in Excel, and try fitting trendlines of various types to your data. Warning: six points isn't going to give you that much information. Do you need to interpolate or extrapolate?

The best fit I found (without going to very high-order polynomials) was
$$y=303.31x^{2}-151.14x+24.221,$$
with an $R^{2}$-value of $0.9895$. You can do a bit better with a cubic:
$$y=1357.5x^{3}-1205.6x^{2}+387.32x-36.859,$$
with an $R^{2}$ value of $0.9968$.
 
Ackbach said:
My recommendation: Excel. Plot the points up in Excel, and try fitting trendlines of various types to your data. Warning: six points isn't going to give you that much information. Do you need to interpolate or extrapolate?

The best fit I found (without going to very high-order polynomials) was
$$y=303.31x^{2}-151.14x+24.221,$$
with an $R^{2}$-value of $0.9895$. You can do a bit better with a cubic:
$$y=1357.5x^{3}-1205.6x^{2}+387.32x-36.859,$$
with an $R^{2}$ value of $0.9968$.

Thank you,Ackbach.
By the way, can you brief me the definition of R^2 in your quote.?

Thanks.
Bundit
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
Replies
6
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 6 ·
Replies
6
Views
2K
Replies
7
Views
2K
  • · Replies 17 ·
Replies
17
Views
9K