Subscribe Bookmark RSS Feed

How to get an exponential regressio?

matteofrancioni

Occasional Contributor

Joined:

Sep 5, 2016

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
txnelson

Super User

Joined:

Jun 22, 2012

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