X intercept of a second derivative plot

**d686** · 02-12-2016, 08:51 PM

I have a second derivative plot where i need to know the x intercepts, is there a formula or a way that i can tell excel to generate values for all x intercepts in the plot?

**MarvinP** · 02-12-2016, 08:58 PM

Hi d686 and welcome to the forum,

A second derivative might still be a polynomial. If you have the equation, you could use the solver. See some examples at:
http://chandoo.org/wp/2013/09/19/how...tion-in-excel/

**d686** · 02-13-2016, 02:32 PM

The graph that i have is not polynomial, it is all over the place, any other ideas to solve this problem?

**MrShorty** · 02-13-2016, 02:55 PM

Solver should still be able to solve it, unless there is something else about the problem that makes it unsuitable for Solver's algorithms. If the problem is "differentiable" (is that the term?), then it seems like it should be solvable using Solvers algorithms.

Can you describe the equation (either the original equation or the 2nd derivative)?