How to arrange panel data for Eviews into MS-excel Let suppose I have 4 variables which are like (ROA, ROE, ROEC AND SALE) etc. And 4 (nestle, ogdcl, unilever, lotte etc.) different companies. There are two way of arranging your data into excel sheet first way, we arrange data into horizontal form and in second way we arrange data into vertical form. Let’s start: method one
Arrange your all variables into this order. Means first write your variable name then underscore then your first company name or your first country or whatever data you used. Once your one variable completed then same without any gap start second variable and all cross sections and write till your all variables ends. Below is screenshot of my arrange data into excel format. Roa_nest
Roa_ogd
Roa_uni
Roa_lote
Roe_nest
Roe_ogd
Roe_uni
Roe_lote
Roce_nest
Please zoom for clear look. Here I have my first variable ROC and I have 9 different companies, and I wrote all the data in excel sheet and all data is without any gap. In first column I years, then variable and cross section name and I have wrote the name or cross sections in abbreviation form. Like this ROC_UNI and in next Colum ROC_FFC etc.
Let’s start
second method of arrange panel data into excel file in vertical form.
In vertical form we arrange data like this. year 2007 2008 2009 2007 2008 2009 2007
Company Unilever Unilever Unilever Unilever Unilever FFC FFC FFC HONDA
ENVC 31513000 30,498,000 30,215,000 49,072,000 35,895,000 5,206,000 10,845,000
EPS 136.66 156 45.64 16.02 18.37 16.25 17.15
ROA 35.06 30.17 39.51 16.02 18.37 16.25 10.26
ROE 132.89 139.25 162.02 81.04 110.35 106.64 28.49
ROC 131.08 135.08 135.37 70.44 83.49 63.09 19.27
Muhammad Saeed Saeed Aas Khan Meo, superior university university Lahore paksitan.1 paksitan.1
etc
2008 HONDA 8,080,000 14.93 12 31.48 24.53 2009 HONDA 10,042,000 4.75 4.39 10.49 8.43 Unilever,FFC, Honda , have took data of thesis companies, while envc eps roa, roe roc are my variables.
Best of luck , thanks for being with me.
Muhammad Saeed Saeed Aas Khan Meo, superior university university Lahore paksitan.2 paksitan.2
