Solving for Minimum point Excel

[Lane Dillon]

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.

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

 

[DrClaude]

Since you have the values of the polynomial fit, it isn't hard to find the minimum.

If you are not versed in calculus, you can check https://www.mathsisfun.com/calculus/maxima-minima.html

 

[LCKurtz]

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.