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

Discussion Overview

The discussion centers on how to derive a function expression from a set of given coordinate points (x,y). Participants explore various methods for fitting a function to the data, considering both polynomial and exponential models.

Discussion Character

  • Exploratory
  • Mathematical reasoning

Main Points Raised

  • Bundit inquires about calculating a function expression from six coordinate points, suggesting a potential exponential relationship.
  • One participant recommends using Excel to plot the points and fit trendlines, noting that six points may not provide sufficient information for reliable interpolation or extrapolation.
  • This participant presents a quadratic fit with an R² value of 0.9895 and a cubic fit with an R² value of 0.9968 as potential models for the data.
  • Another participant shares an exponential fit obtained from Wolfram Alpha, which has an R² value of 0.9969, indicating a strong fit to the data.
  • Bundit requests clarification on the definition of R² in relation to the quoted fits.

Areas of Agreement / Disagreement

Participants present multiple approaches to fitting functions to the data, with no consensus on a single method or model being preferred. The discussion remains open to various fitting techniques.

Contextual Notes

Participants express uncertainty regarding the adequacy of the six data points for reliable function fitting, and there are no settled definitions or explanations provided for R².

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 1 ·
Replies
1
Views
2K
Replies
7
Views
2K