1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Solving for Minimum point Excel

  1. May 9, 2017 #1
    1. The problem statement, all variables and given/known data

    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.
    2. Relevant equations


    3. The attempt at a solution
     
  2. jcsd
  3. May 10, 2017 #2

    DrClaude

    User Avatar

    Staff: Mentor

  4. May 10, 2017 #3

    LCKurtz

    User Avatar
    Science Advisor
    Homework Helper
    Gold Member

    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: May 10, 2017
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted



Similar Discussions: Solving for Minimum point Excel
  1. Excel Help (Replies: 3)

Loading...