cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Choose Language Hide Translation Bar

How to get an exponential regressio?

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

xy
0,511,07
0,510,88
0,511,20
0,952,53
1,012,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

1 REPLY 1
txnelson
Super User

Re: How to get an exponential regressio?

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

Jim