Re: Cannot create exponential trend line

[Jean Bréfort <jean brefort normalesup org>]

You can't have both positive and negative values as y variable. It
should work if you exchange x and y in your data.

Hope this helps,
Jean

Le vendredi 01 février 2013 à 19:06 -0800, MrProsser a écrit :
> I have a small dataset that I am trying to fit with a natural exponential
> trend line in gnumeric.
>
> The data set is:
>
> y1: 1.948 x1: 2.303
>
> y2: 1.197 x2: 2.996
>
> y3: 0.367 x3: 3.912
>
> y4: 0.109 x4: 4.605
>
> y5: -0.019 x5: 5.298
>
> y6: -0.072 x6: 6.215
>
> I want to fit it with a curve of the form: y=a*e^(b*x)
>
> When I tried to fit this with an exponential in gnumeric I was not able to
> get it to create any trend line. It would not display anything.
>
> I calculated the a and b parameters myself and plotted it in another
> application and it looked reasonable, but for some reason I cannot get
> gnumeric to generate this automatically.
>
> Does anyone have any idea why it won't work?