How to find the coordinates of a point (x,y) where a line of negative slope intersects a curve defined by a four degree polynomial equation?
Is it possible to do that in excel?
Przemysław Kowalik
Yes it can be done numerically by using Solver add-in (also by the Goal seek tool). The issue is that without extra restrictions on parameters of equations of the line and the curve there may be 0 up to 4 points where they intersect.
1 votes
0 thanks
- Badges
- Science topic
More Nelson Campos's questions See All
Similar questions and discussions