Page 1 of 1

Regression Analysis

Posted: Mon Aug 27, 2018 11:07 am
by AbrahaM
Hey everyone,

I'm very new and need some advice.
My problem is that I have two workfiles, one with the firm performance (tobin's q) including firm size, leverage ratio, sales growth and capex. my other workfile contains certain CEO characteristics (e.g. age, tenure, gender, tenure (startdate & enddate)). Now Im trying to do a regression analysis. But it won't let me calculate it because I have two workfiles and not one. I even tried copying and linking them. But since the start date of ceo's is different irregular it wont let me. What am I doing wrong?
If there is already thread to this question, could you just leave a link? I'm sorry if this is already a thread but I couldn't find anything.

Thank you very much.

Re: Regression Analysis

Posted: Mon Aug 27, 2018 11:15 am
by EViews Gareth
Abstract away EViews and think how the observations from one data set line up with the observations in the other. Once you've figured that out, we can help you set it up in EViews.

Re: Regression Analysis

Posted: Mon Aug 27, 2018 1:43 pm
by AbrahaM
Im not sure, I understand. Do you mean like this? I attached it?

Thank you very much.
Screen Shot 2018-08-27 at 22.41.24.png
Screen Shot 2018-08-27 at 22.41.24.png (132.41 KiB) Viewed 7913 times

Re: Regression Analysis

Posted: Mon Aug 27, 2018 1:46 pm
by EViews Gareth
What ties a row in one of the workfiles with a row in the other? How are the observations (firms?) connected?

Re: Regression Analysis

Posted: Mon Aug 27, 2018 2:07 pm
by AbrahaM
They are connected/tied through the company name. (I'm sorry, I feel so stupid).

Re: Regression Analysis

Posted: Mon Aug 27, 2018 2:50 pm
by startz
You probably want to make two different workfile pages and then link them by company name. A place to get started is http://www.eviews.com/help/helpintro.ht ... cepts.html

Re: Regression Analysis

Posted: Tue Aug 28, 2018 5:50 am
by AbrahaM
Got it!! thank you all.