Extracting values from equations shown a chart.

[steve case]

I created a graph from my data, hovered over my data and right clicked
the mouse. A menu appeared with among other things "add a trend line"
Clicking that, another menu "Trendline Options" appears, I selected the
radio button for Polynomial and selected "Order 2" At the bottom of the
menu I selected "[✓] Display equation on chart" And clicked the [Close] button.

The trend line and the following equation appeared on my graph:

y = 0.0117x² + 1.6021x + 6743.2

Are there any Excel functions i.e., =function(known_y's,known_x's) that
will yield any of those three numbers that appear in the shown equation?

Right now I'm copy and pasting the value for X² into the desired cell.
A function to do that would be super!

My "X" and "Y" data are in Column "A" and "B" respectively - right on down the sheet.

A function in [C1] =FUNCTION(A:A,B:B) to yield: the 0.0117 for X² is what I'm looking for.

I have Excel 2007

 

[steve case]

This is a repost of the same question with a little more detail:

I have excel 2007

If do a Google search for the Derive function in Excel I find this:

=DERIVF(f, x, p,) [options]) Use DERIVF to compute first or higher order
derivatives of a function f(x) at x=p. using highly accurate adaptive algorithm.
With optional arguments, you can specify a higher derivative order, as well
as override the default algorithm parameters.

Why can't I find the DERIVE(F,X,P) on my Excel 2007 spreadsheet?

Background:

What I'm looking for is a way to easily transfer the equation that
shows when you plot out a 2nd order polynomial trend line and
select [Display equation on chart] to a cell or series of cells.

Given a series of times and positions and the equation on the chart
formatted y=x²+x+p, I want to easily produce 2x² for the acceleration

 

[Fluff]

There is no Derivf function in excel. It's possibly a function from an add-in.

 

[steve case]

There is no Derivf function in excel. It's possibly a function from an add-in.

Kinda what I thought, does anyone know of an add in that's out there that will do that?

 

[Fluff]

I don't know of any, but that's because I don't do anything like that.
Where did you find the information you posted?

 

[steve case]

I don't know of any, but that's because I don't do anything like that.
Where did you find the information you posted?

ExcelWorks LLC

 

[Fluff]

That's the site for the add-in, just click on the download icon.

 

[steve case]

That's the site for the add-in, just click on the download icon.

Thanks I'll give it a try (-:

 

[steve case]

That's the site for the add-in, just click on the download icon.

It says:
Excel 2013 or later (including Office 365)

I use Excel 2007

 

[Fluff]

If they don't support 2007 then your out of luck, unless you can find another add-in or formula that does what you want.