Solving for Minimum point Excel

  • #1
Lane Dillon
3
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.

upload_2017-5-9_23-57-29.png


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

 
Physics news on Phys.org
  • #3
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:

Similar threads

Back
Top