Finding Equation of Curve to Touch Straight Line

  • Thread starter Thread starter JonnyMontana
  • Start date Start date
  • Tags Tags
    Curve
Click For Summary
SUMMARY

The discussion focuses on finding the point where a curve touches a straight line, specifically the line defined by the equation Y = 1022.7X + 115583. The user seeks to derive the equation of the curve based on given points and is struggling with Excel's inability to select all points for accurate equation generation. The solution involves determining the slope of the line, differentiating the curve's function, and equating the derivative to the line's slope to find the tangent point.

PREREQUISITES
  • Understanding of calculus, specifically differentiation and tangent lines.
  • Familiarity with linear equations and their slopes.
  • Basic knowledge of curve fitting techniques.
  • Proficiency in using Excel for data analysis and graphing.
NEXT STEPS
  • Learn how to differentiate functions to find slopes of tangent lines.
  • Explore curve fitting methods in Excel or other statistical software.
  • Study the concept of tangents and points of tangency in calculus.
  • Investigate alternative tools for curve analysis, such as Python's NumPy and SciPy libraries.
USEFUL FOR

Mathematicians, engineers, data analysts, and students studying calculus or working on curve fitting and optimization problems.

JonnyMontana
Messages
2
Reaction score
0
Can anyone help as it's a long time since I studied this:

I have a straight line - which I have the equation for and a plotted curve with multiple points.

I want to figure out the point where the curve would touch the line shold it be moved toward the line.

I've tried using excel to get the equation of the line for the curve but it won't seem to select all the points and is not giving me a good equation.

Any advice apprecaited!
 
Physics news on Phys.org
If you were to move the line to the curve, or the curve to the line (I presume you mean moving it "parallel to itself", without changing its orientation), they would first touch at a point at which the line is tangent to the curve.

So: determine the slope of the line. Differentiate the function determining the curve and set the derivative (slope of the tangent line), as a function of x, equal to the slope of the given line. Solve that equation for x.
 
Thanks.

Suppose we were to imagine that I'm a bit rusty with this can I ask a further question?

What is the best way for me to derive the equation of the curve?

If I give the simple details it may help.

Straight Line Equation
Y = 1022.7X + 115583 (I think!)
Points
9.0, 129150
11.0, 134000

Curve Points
29.6 77023
29.6 78363
29.6 79033
29.6 79703
29.6 80373
29.7 81043
29.7 81713
29.8 82383
29.9 83053
30.0 83723
30.2 84393
30.4 85063
30.7 85733
31.0 86403
31.3 87073
31.7 87743
32.2 88413
32.8 89083
33.4 89753
34.1 90423
34.9 91093
35.7 91763
36.7 92433
37.7 93103
38.9 93773
39.9 94282

Any advice appreciated!
 

Similar threads

  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 15 ·
Replies
15
Views
3K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 3 ·
Replies
3
Views
1K
  • · Replies 7 ·
Replies
7
Views
2K
Replies
1
Views
4K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K