(Stata13): Panel Data Descriptive Analysis (Scatterplots)

With the scatterplot, you can reveal the relationships between the outcome variable and an explanatory within the various categorical variable in your panel data. In this video, using Stata13, I show the various ways of using the scatterplot to reveal various heterogeneities within and among the groups with the summary statistics of the outcome variable (Gini coefficient) and the different categorical variables such as countries, regions, income groups and inequality categories. Besides, why do you want to perform panel data analysis? Some of the reasons could be to explore the behaviour of a variable across a sample of groups (e.g. firms, schools, countries, agro produce, individuals, cars, production style, political parties etc.) to explore the behaviour of the groups in the sample with respect to a variable the groups have some semblance of commonness the groups have varying heterogeneities (i.e. differences) with respect to a variable perhaps due to inadequate data over a long period for your sample or maybe you just don’t know why!  I give 5 tips required for building an engaging panel data structure. They are (1) generate identifiers (watch my video on “Reshape Wide to Longitudinal Data” and “Tips to Building a Panel Data”) (2) reshape the data (watch my video on “Reshape Wide to Longitudinal Data”) (3) group classification (to explore the heterogeneities in the data) (4) categorise the outcome variable (to explore the heterogeneities in the data) and (5) create dummy variables (regional and time dummies). Remember, graphics convey lots of information than words. So, load your data and let’s get started.

Here is the link to the engee2.xlsx dataset used for this tutorial (endeavour to have a Google account for easy accessibility): https://drive.google.com/drive/u/1/fo...

Follow up with soft-notes and updates from CrunchEconometrix:

Website: http://cruncheconometrix.com.ng

Blog: https://cruncheconometrix.blogspot.co...

Forum: http://cruncheconometrix.com.ng/blog/...

Facebook:   / cruncheconometrix  

YouTube Custom URL:    / cruncheconometrix  

Stata Videos Playlist:    • (Stata13):Estimate and Interpret Two-...  

EViews Videos Playlist:    • (EViews10):Interpret VECM, Forecast E...