Translation of Trend equations displayed on chart

[steve case]

If I choose a Polynomial Trend Order 2 and select the option to display
the equation on the chart I get something that looks like this:

y = 0.0005x² + 0.1025x + 1.101​

I'm interested in being able to put an equation like that into terms of acceleration.
Similar to 32 ft/sec² that we are familiar with.

The data for my example above is:

Seconds Feet
1 ..... 1.204
2 ..... 1.308
3 ..... 1.413
4 ..... 1.519
5 ..... 1.626
6 ..... 1.734
7 ..... 1.843
8 ..... 1.953
9 ..... 2.064
10 .... 2.176​

Google & Mr. Excel Help just didn't do the trick )-:

<tbody>
</tbody>

 

[steve case]

Considering that no one's answered here and that I've found it's easier to just simply figure it out from the data .....

In other words I no longer need the answer to the question.


And if there was any serious head scratching trying to figure it out - Thank You (-:

 

[shg]

Rather than getting the formula from the trendline with it's limited precision (your coefficient for x^2 has only a single digit, for example), you can use LINEST to get the coefficients on the worksheet. Select 4 cells wide (say, A1:D1) and array-enter

=linest(yRange, xRange^{1,2})

Then the reconstruction formula is

=seriessum(xValue, 2, -1, $A$1:$C$1) + $D$1

 

[PaddyD]

All you want to know, and probably a bit more, about trendline and regression formulas etc:

Trendline coefficients

 

[steve case]

Thanks for the tips. I was barking up the wrong tree,
I had thought the acceleration would drop out of the
trend formula. It doesn't. And as it turns out, it's not
all that difficult to determine what it is with a progression
of formulas across the page.

Best regards to the both of you

Steve Case

 

[shg]

You're welcome.