how to generate correlation matrix with panel data?

4 次查看（过去 30 天）
e.a.
e.a. 2019-10-31
评论： e.a. 2019-10-31
Hello,
I have an excel data similar to:
year company Ratio1 Ratio2 Ratio3 ...
1 x a b c
2 x d e f
1 y g h j
2 y t u p
1 z ...
2 z ...
and I want to generate a correlation matrix between the ratios. But I dont know how to do it with the my dataset.
I would be glad if you can help me about this.
thank you for your answers in advance,

请先登录，再回答此问题。

回答（1 个）

KALYAN ACHARJYA
KALYAN ACHARJYA 2019-10-31
编辑：KALYAN ACHARJYA 2019-10-31
  • Read the excel file
  • Read the columns as column vectors, say col1,col2 etc
  • Here, next
result=corrcoef(col1); % so on
If pairwise
result=corrcoef(col1,col2);
More detail here
  3 个评论
显示 1更早的评论
KALYAN ACHARJYA
KALYAN ACHARJYA 2019-10-31
I have no idea about the datasets, but you apply apply the same in section of the column vector right? .
e.a.
e.a. 2019-10-31
I couldnot understand your question but in one column I enter the datas(ratios) for the time period of 2014-2019 for 3 companies.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by