BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
Community Trekker

## 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

 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

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