Correlation matrix and different variables average correlation.

W

wytautas

New Member
Joined
Apr 9, 2013
Messages
20
Hallo,

I am working with my investment portfolio improvement. There is 120 variables and them correlation matrix. 10 is always the same. I have done average correlations with 11 and 12variables manually, but wit 13, 14 and 15... I will be faster gradfather that finish it :) I couldnt attach excel file (size, format is correct) so attached here:
FileSwap.com : CORRELATION.xlsx download free

If anyone can show a little way how to do it, I will be really thankful!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Hello. Thank you for your post. But can you please explain further how to know which ranges do we need to average?

Thank you in advance.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
384
AndyEd
A
W
  • Solved
Conditional formatting of invoice lists of varying lengths for presence of a given string
5 6 7
Replies
65
Views
4K
Alex Blakenburg
A
D
  • Question
Variable Mortgage Payment Scheduler with Extra Payments and Offset Account
Replies
4
Views
1K
Daburger
D
L
  • Question
VBA works on work PC but not home PC
Replies
3
Views
2K
rollis13
rollis13
M
  • Question
Push Schedule
Replies
0
Views
670
maghrabi
M

Forum statistics

Threads
1,214,641
Messages
6,120,693
Members
448,979
Latest member
DET4492

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top