3 Replies Latest reply: Jun 17, 2016 7:10 AM by Stefan Wühl RSS

    Correlation calculation

    JAVIER ARTIEDS

      Hello all,

       

      I have a table with 3 columns: Fundname, date and value. I have created two variables so you can input the name of the fund and I would like to calculate correlation between the variable value of any two funds. Please note that as the data of all the funds is merged in the same table, I cannot use directly the function correl, I would have to create a temporary table using the function aggr (I guess), but I don't know how to do it.

       

      Anyone could help?

       

      Thanks a lot!