Getting an equation from a graph

  • Thread starter Thread starter Neal Johnson
  • Start date Start date
  • Tags Tags
    Graph
Click For Summary

Discussion Overview

The discussion revolves around methods for deriving equations from non-linear graphs. Participants explore various tools and techniques for fitting equations to data points, including software and calculator functionalities.

Discussion Character

  • Exploratory
  • Technical explanation
  • Homework-related

Main Points Raised

  • One participant seeks a procedure for obtaining equations from non-linear graphs, mentioning a previous program that generated power series equations.
  • Another participant suggests that knowing the degree of the polynomial might be necessary for fitting an equation.
  • A link to Wolfram Alpha is shared, which can perform data fitting, along with a reference to polynomial interpolation on Wikipedia.
  • A participant describes using a graphing calculator's STAT function to perform various types of regression analysis, including polynomial and trigonometric fits, and mentions the utility of Excel for similar tasks.
  • There is a mention of a software called CurveExpert, although its current availability is uncertain.

Areas of Agreement / Disagreement

Participants present multiple methods and tools for fitting equations to graphs, but there is no consensus on a single best approach or method. The discussion remains open with various suggestions and considerations.

Contextual Notes

Some methods depend on the type of data and the specific characteristics of the graph. Limitations include the availability of certain software and the need for familiarity with different regression techniques.

Neal Johnson
Messages
1
Reaction score
0
I have fairly simple non linear graphs that I need equations for. Sometime back I used a program that gave me a power series equation when multiple cordinates of the graph were entered. I no longer have that program and don't remember where I got it. How Can I get these equations? There must be a procedure I can follow.
 
Last edited:
Computer science news on Phys.org
I don't know about a specific method unless you know the degree of the polynomial?
 
On a good graphing calculator, use the STAT function and choose CALC. Assuming you've already entered a table of data, it gives you several options: linear regression, logarithmic regression, exponential, power (to several orders), trigonometric (fitting a sine curve to the data), etc. I'd have to look at the manual to remember the details of the process, but the result is an equation that will recreate the same pattern.

I usually use Excel, since it's on just about every computer and spreadsheets are almost always more functional than entering data into a calculator.

In Excel, once you've plotted your data, you can add a trend line. The options for the trend line are similar to the options on a graphing calculator, with the advantage that as you select each option, you can immediately see how well the trend line matches the plotted data. The disadvantage is that Excel doesn't offer a trigonometric option, a major drawback. You can come close using a higher order polynomial, but it's not as good. (On the other hand, if you've taken basic trigonometry, it's really fairly easy to fit a sine wave to your data, when appropriate, even without the aid of a computer or calculator.) When you have a trend line that comes close to matching your data, select the option to display the equation on the chart.

Just looking at the plotted data should give you a decent clue of the type of equation that would model it best, so you usually only have to try a couple of options regardless of whether you're using a calculator or Excel.
 
Last edited:
There once was something downloadable called, CurveExpert, but not sure if it is still available.
 

Similar threads

  • · Replies 10 ·
Replies
10
Views
11K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 49 ·
2
Replies
49
Views
4K
Replies
2
Views
2K
Replies
11
Views
2K
Replies
4
Views
3K
  • · Replies 27 ·
Replies
27
Views
16K
  • · Replies 1 ·
Replies
1
Views
1K
Replies
65
Views
5K