What is the function of this graph?

In summary, to create a non linear function from a list of points, one could either use a higher degree polynomial trendline or fit the curve in parts using a spline function. The popular statistical package R has capabilities for spline functions. Another option is to use the formula 13750 * (3.6 + exp(i/17.5)) * (1-i/74.3)^0.77, with i representing the position in the dataset, although a spline would provide better results. The formula was found through manual tuning and has an accuracy of better than 1% apart from the last few points. An automatic approach may yield a better fit.
  • #1
beamthegreat
116
7
I need to create a non linear function from a list of points. I tried creating a 3rd order polynomial trendline on excel but it was a very poor fit. Can anyone give me tips/advice on how to create a function that best fits the following data?

Here's what the graph looks like:

Screen_Shot_2016_09_22_at_4_19_41_AM.png
Here are the points:

63,400
63,468
63,588
63,759
63,981
64,252
64,571
64,939
65,355
65,818
66,329
66,886
67,490
68,141
68,839
69,584
70,375
71,214
72,100
73,033
74,014
75,042
76,119
77,244
78,418
79,641
80,912
82,233
83,602
85,021
86,489
88,006
89,571
91,183
92,843
94,549
96,299
98,093
99,927
101,799
103,707
105,646
107,612
109,600
111,603
113,614
115,625
117,624
119,599
121,538
123,423
125,234
126,951
128,545
129,988
131,244
132,272
133,024
133,444
133,470
133,024
132,021
130,359
127,920
124,567
120,139
114,450
107,282
98,380
87,448
74,137
58,042
38,685
15,508
 
Mathematics news on Phys.org
  • #2
For a curve like this, there are two popular options you might want to consider. One is to allow a higher degree polynomial. To fit that curve the degree might be higher than you want. Another option is to fit it in parts with a spline function. A spline of certain orders can be pieced together so that the function and derivatives of orders up to a desired order are continuous.

There is a popular statistical package, R, that has spline function capability. (see https://stat.ethz.ch/R-manual/R-devel/library/stats/html/splinefun.html )
 
  • #3
13750 * (3.6 + exp(i/17.5)) * (1-i/74.3)^0.77
Where the first element in the dataset has i=1 and the last one has i=74.

Found by black magic and sacrificing a few electrons. A spline will give better results but my formula is accurate to better than 1% apart from the last few bins. I tuned the parameters manually, an automatic approach will find a better fit.
 
  • Like
Likes BvU and FactChecker

What is the function of this graph?

The function of a graph is to visually represent data and show the relationship between variables.

What types of graphs are commonly used to represent data?

Commonly used graphs include line graphs, bar graphs, pie charts, scatter plots, and histograms.

How do you read a graph?

To read a graph, start by looking at the labels on the x and y axes to determine what variables are being represented. Then, plot the data points and look for any patterns or trends in the data. You can also use the scale on the axes to interpret the values of the data points.

What is the difference between a dependent and independent variable on a graph?

The dependent variable is the one that is being measured or observed, while the independent variable is the one that is being controlled or changed in an experiment. In a graph, the dependent variable is typically plotted on the y-axis and the independent variable on the x-axis.

How do you determine the slope of a line on a graph?

The slope of a line on a graph is determined by calculating the change in the y-values divided by the change in the x-values. This is also known as rise over run.

Similar threads

  • General Math
Replies
2
Views
721
Replies
7
Views
979
  • General Math
Replies
1
Views
730
  • General Math
Replies
2
Views
1K
Replies
16
Views
2K
  • General Math
Replies
4
Views
2K
Replies
4
Views
3K
  • Set Theory, Logic, Probability, Statistics
Replies
11
Views
752
  • General Math
Replies
19
Views
1K
  • STEM Educators and Teaching
Replies
5
Views
652
Back
Top