steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
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>
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>