On Friday, January 20, 2017 at 1:22:05 PM UTC-5, BottleMan wrote:
Hi everybody,

I use scatter charts and trendlines a lot to derive formulas from real data. Excel then prints the formula it used on the chart. However, when I use this formula with the same data set the values always differ and I have to massage the formula to make it represent the data. What am I doing wrong here?
Thanks for your help.



On Friday, January 20, 2017 at 1:22:05 PM UTC-5, BottleMan wrote:
Hi everybody,

I use scatter charts and trendlines a lot to derive formulas from real data. Excel then prints the formula it used on the chart. However, when I use this formula with the same data set the values always differ and I have to massage the formula to make it represent the data. What am I doing wrong here?
Thanks for your help.

With the formula you provided the y-values are like this:
x-Axis Y-axis
1.2 -1.175283891
1.6 -3.196520141
2.4 -12.23920302
3.6 -44.71833352
4.8 -109.1028104
6 -215.2796
7.2 -373.5357904
8 -513.4864
Much worse. Can you show me what you got?