Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Correlation Matrix

Hi,

Here is the data. (ln) changes of currencies. I want to create correlation matrix among them. Could anybody help me?

USD EUR GPB JPY RUR
06.01.2010 0,00012 -0,00407 -0,00614 -0,00412 0,0113
07.01.2010 0,00000 0,003031 0,00148 -0,00241 0,0037
08.01.2010 0,00012 -0,0059 -0,00374 -0,00935 0,0000
11.01.2010 -0,00025 0,012535 0,008555 0,008548 0,0000
12.01.2010 0,00000 -0,00095 0,00031 0,001724 0,0184
13.01.2010 0,00000 0,00043 0,006251 0,011757 -0,0073
14.01.2010 -0,00012 0,002747 0,00583 -0,00729 -0,0037
15.01.2010 0,00025 -0,00757 0,003284 0,00763 0,0037
18.01.2010 0,00000 -0,00311 -0,00168 0,001927 0,0000
19.01.2010 0,00000 0,001645 0,006015 0,005645 -0,0037
21.01.2010 0,00037 -0,02071 -0,008 -0,01235 -0,0037
22.01.2010 0,00000 0,001941 -0,00353 0,017738 0,0000
25.01.2010 0,00000 0,00308 -0,00616 -0,00179 -0,0074
26.01.2010 0,00012 -0,00529 0,006008 0,002801 -0,0075
27.01.2010 0,00000 -0,00097 -0,00485 0,00669 -0,0038
28.01.2010 0,00012 -0,00452 0,003697 -0,01174 0,0000
29.01.2010 0,00000 -0,0057 -0,00339 0,004599 -0,0038
01.02.2010 0,00000 -0,00385 -0,01133 -0,00213 0,0038
02.02.2010 0,00000 0,00358 -0,00062 -0,00732 0,0000
03.02.2010 -0,00012 0,001607 0,00304 0,003271 0,0075
04.02.2010 0,00000 -0,00465 -0,00546 -0,00451 0,0037
05.02.2010 0,00000 -0,01272 -0,01054 0,013372 -0,0075
08.02.2010 0,00000 -0,0051 -0,0085 0,003788 -0,0113

If anythink is incomprehensible pls underline. I will add information.



Thanks in advance.

Last edited by AsifA : July 22nd 10 at 11:33 AM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Correlation matrix Chrissy Wissy[_2_] Excel Discussion (Misc queries) 7 July 11th 07 12:26 PM
triangular correlation matrix jude Excel Discussion (Misc queries) 2 October 2nd 06 04:59 PM
Toolpack Correlation Matrix TarrynG Excel Worksheet Functions 0 September 4th 06 03:59 PM
Correlation Matrix katie Excel Worksheet Functions 5 May 16th 06 07:21 PM
Correlation matrix Peppino Excel Worksheet Functions 1 March 10th 05 01:32 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"