Page 1 of 1

Correlation: VCV versus CMOM

Posted: Thu Dec 28, 2017 6:02 am
by schwa012
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

Re: Correlation: VCV versus CMOM

Posted: Thu Dec 28, 2017 7:33 am
by TomDoan
Isn't that addressed in the technical information for VCV? VCV, by default, assumes the inputs are mean zero.