Untitled.jpg
Hey guys I need to find the maximum point on the curve and then have the perpendicular line from the max point towards the axes. Please see the attached file.
Untitled.jpg
Untitled.jpg
Hey guys I need to find the maximum point on the curve and then have the perpendicular line from the max point towards the axes. Please see the attached file.
Untitled.jpg
With only three points to define the curve, I would expect to use a process like this:
1) Regress equation for curve. Assuming you are looking for a polynomial (quadratic with only three points) or other linear function, you can use the LINEST() function (https://support.office.com/en-us/art...a-fa7abf772b6d ) for this step, or you can use the built in trendline feature of the chart ( https://support.office.com/en-us/art...4-901a745842ad ). If your desired curve is nonlinear, then you will need to use non-linear regression techniques.
1a) If you use the chart trendline feature, you will need to enter the coefficients of the quadratic/polynomial/trendline into spreadsheet cells.
2a) Assuming you use a quadratic equation, then you can use simple algebra that you learned back in school to find the maximum point. A quick refresher: http://www.purplemath.com/modules/perimetr6.htm
2b) If you use a different equation form, you will probably enter the calculus realm, where you find the zeros of the first derivative.
Note that, except for possibly using the chart to perform the trendline regression, the chart does not actually perform the analysis. The analysis is performed in the spreadsheet.
Is that enough for you to work out the details, or is there a specific step that you get stuck on?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks