Correlation: VCV versus CMOM
Posted: Thu Dec 28, 2017 6:02 am
Dear Tom, dear all,
I have a question on using the VCV and/or CMOM instruction.
I use a panel data set with about 4,500 banks and observations for 14 years, but as an unbalanced panel (~ 38,000 obs). Now I want to compute and show the correlation between the independet variables, for example between unemployment rate (UNEMP) and total loans (in percentage of total assets, GLTA1).
Using the VCV instruction shows a really high positive correlation. If I take a look at the scatter plot, I cannot confirm that. Using the CMOM instruction with the CORR option I find a slightly negative correlation (what is in line with the plot and my expectations):
[...]
vcv(smpl=regfil1) /
# unemp glta1
cmoment(smpl=regfil1,print,corr) /
# unemp glta1
scatter(smpl=regfil1,style=dots,hlabel='Unemployment (%)',vlabel='Gross Loans / Total Assets')
# unemp glta1
So what is the difference between VCV and CMOM here?
Many thanks in advance,
greetings from Germany,
AS
I have a question on using the VCV and/or CMOM instruction.
I use a panel data set with about 4,500 banks and observations for 14 years, but as an unbalanced panel (~ 38,000 obs). Now I want to compute and show the correlation between the independet variables, for example between unemployment rate (UNEMP) and total loans (in percentage of total assets, GLTA1).
Using the VCV instruction shows a really high positive correlation. If I take a look at the scatter plot, I cannot confirm that. Using the CMOM instruction with the CORR option I find a slightly negative correlation (what is in line with the plot and my expectations):
[...]
vcv(smpl=regfil1) /
# unemp glta1
cmoment(smpl=regfil1,print,corr) /
# unemp glta1
scatter(smpl=regfil1,style=dots,hlabel='Unemployment (%)',vlabel='Gross Loans / Total Assets')
# unemp glta1
So what is the difference between VCV and CMOM here?
Many thanks in advance,
greetings from Germany,
AS