Solving for Minimum point Excel

2 replies · 2K views · last reply
Lane Dillon
Messages
3
Reaction score
0

Homework Statement


[/B]
Hello, I trying to solve for the minimum value that the x and y components reach in plot (A). I know that you can perform this using IgorPro but I would like to know how to solve for it using Excel.

Scatter plot of data points with a fitted quadratic curve, y = 0.0006x^2 - 0.1485x + 9.4525, dipping to a minimum near x = 125 and y close to 0.005.


The plot was constructed using the following data points:

110 0.177
115 0.093
120 0.033
125 0.006
130 0.007
135 0.04
140 0.101
145 0.186
150 0.272

As you can see there is a minimum x and y data point. However, I want to solve for the minimum point that the polynomial fit reaches.

Homework Equations

The Attempt at a Solution

 
Or, if you don't know calculus, you can just complete the square on your polynomial to figure out the minimum.
[Edit, added] The graph you show is not the correct graph for the polynomial you gave.
 
Last edited: