How to get an exponential regressio?

matteofrancioni — Wed, 21 Sep 2016 17:02:59 GMT

Hello!

I'm trying to get an R2 value and a p value with an exponential regression

Equation is simply y=e^x

Data are like this

x	y
0,51	1,07
0,51	0,88
0,51	1,20
0,95	2,53
1,01	2,65

It seems like I just got linear regression (y=ax+b) if I go to "Fit Y by X".

Maybe i should use modelization --> non-linear?But then I'm not sure I get the correct equation and it seems I can't get a p value

Thanks to everyone who would like to help me.

Matteo

Re: How to get an exponential regressio?

txnelson — Wed, 21 Sep 2016 20:56:25 GMT

All you have to do for this, is to go to:

Analyze==>Fit Y by X

Then when the input dialog box appears, drag your y column into the Response box, and the go back to the selection box and select your X Factor column. Right mouse click on it and select formula. This will allow you to create a virtual column which is the exponential of the X column. If you clear the formula editor when it comes up, and then go to the Transcendental category you will find the Exp function. Select it, and then click on your X column to indicate that it is the column for the Exp function to act on.

You can then use the new virtual column as your X Factor column in the Fit Y by X platform

topic Re: How to get an exponential regressio? in Discussions

How to get an exponential regressio?

Re: How to get an exponential regressio?