Solving for Minimum point Excel

Click For Summary
SUMMARY

This discussion focuses on finding the minimum point of a polynomial fit using Microsoft Excel, based on a set of data points. The data provided includes x-values ranging from 110 to 150 and corresponding y-values. Users are advised to utilize Excel's built-in functions to analyze the polynomial fit, and for those unfamiliar with calculus, completing the square is suggested as a method to determine the minimum. Additionally, a reference to a calculus resource is provided for further understanding.

PREREQUISITES
  • Familiarity with Microsoft Excel functions for data analysis
  • Understanding of polynomial equations and their properties
  • Basic knowledge of calculus concepts, particularly maxima and minima
  • Ability to interpret graphical data representations
NEXT STEPS
  • Learn how to use Excel's Solver tool for optimization problems
  • Study polynomial regression techniques in Excel
  • Explore the method of completing the square for quadratic equations
  • Review calculus principles related to finding extrema of functions
USEFUL FOR

Students, data analysts, and anyone interested in performing polynomial analysis and optimization using Excel will benefit from this discussion.

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.

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
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

What Alternatives Exist for Fitting Models to Erratic Data in Excel?
  • · Replies 2 ·
Replies
2
Views
2K
Undergrad Help with a difficult (?) regression
  • · Replies 7 ·
Replies
7
Views
2K