- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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