Search found 6 matches
- Fri May 06, 2011 3:00 pm
- Forum: Data Manipulation
- Topic: Calculating mean in panel data
- Replies: 11
- Views: 19856
Re: Calculating mean in panel data
I just like to display a table where the most important descriptive statistics are mentioned. Let me make myself clear with an example. I have for example a regression with the following form: Y = a1 X1 + a2 X2 + error term. I have removed the outliers from Y, X1 and X2. Now, I'd like to create a ta...
- Fri May 06, 2011 2:47 pm
- Forum: Data Manipulation
- Topic: Calculating mean in panel data
- Replies: 11
- Views: 19856
Re: Calculating mean in panel data
One other question, I'll post it here if you don't mind. When selecting one variable, you can calculate the stats by classification (for example if you have data for different firms for different years, you can calculate the mean for all firms for each year with this function). However, when selecti...
- Thu May 05, 2011 10:45 am
- Forum: Data Manipulation
- Topic: Calculating mean in panel data
- Replies: 11
- Views: 19856
Re: Calculating mean in panel data
That was a very stupid mistake of mine! Thanks a lot Gareth!
- Thu May 05, 2011 8:41 am
- Forum: Data Manipulation
- Topic: Calculating mean in panel data
- Replies: 11
- Views: 19856
Re: Calculating mean in panel data
Thanks Gareth for your quick response. I added the excel and the eviews workfile. It's just a part from the database because it's too big. Our dataset also involves panel data, but this is of no importance to calculate the mean. In EViews, I import these data from excel (open foreign data as workfil...
- Thu May 05, 2011 5:07 am
- Forum: Data Manipulation
- Topic: Calculating mean in panel data
- Replies: 11
- Views: 19856
Calculating mean in panel data
Hi, I have a somewhat strange problem when calculating descriptive statistics for a panel data set in EViews. The data set covers 4 years and 60 000 firms. I calculate the mean value for one variable for each year using the "stats by classication" function. However, the values calculated f...
- Tue Mar 22, 2011 6:46 am
- Forum: Data Manipulation
- Topic: Dummy variables with missing values
- Replies: 1
- Views: 5015
Dummy variables with missing values
Hi, In our panel data we have a dummy variable that has a lot of missing values (approximately 60% of the values missing, the other 40% have the value 0 or 1). It's no problem to import these data (we import them from excel) but once they are imported, EViews seems to indicate that these values are ...
