How to get an exponential regressio?

matteofrancioni

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

txnelson

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