Page 1 of 1

Regression help

Posted: Sun Aug 04, 2019 12:16 am
by abhinav
Hi,

I am new to using Eviews. I want to fit my data to an exponential curve: y = a*e^(bx). I am running the regression using two methods:

1. MICE_1= COEF(1)*(EXP(COEF(2)*OBSERVATION))

2. LOG(MICE_1) = COEF(3) + COEF(4)*OBSERVATION

Since, both equations are the same, coef(2)=coef(4) and coef(1)= exp(coef(3))

However, I am getting different coefs. using the two equations. Can someone please explain why is this happening?

Thanks,
Abhinav

Re: Regression help

Posted: Sun Aug 04, 2019 6:48 am
by startz
Remember that regression equations include error terms. The error terms here are not the same.

Re: Regression help

Posted: Mon Aug 05, 2019 2:54 am
by abhinav
If I plot my data in excel and go for an exponential trendline, the coefficients of the resulting equation I get match the coefficients I get from this equation: LOG(MICE_1) = COEF(3) + COEF(4)*OBSERVATION

However, I was thinking that the exponential trendline for my data in excel (of the form y = a*e^(bx)) would be same as evaluating MICE_1= COEF(1)*(EXP(COEF(2)*OBSERVATION)) in Eviews. Why is it being evaluated differently in these two software? Any idea?

Re: Regression help

Posted: Mon Aug 05, 2019 5:56 am
by startz
I believe that Excel takes logs.