I'm new to using VBA, but looking to learn. I'm having trouble with the code for a correlation matrix function. The code is below and I keep getting a #NAME? error but I can't figure out where the issue is.
Function CorrelationMatrix(rng As Range) As Variant
Dim i As Integer
Dim j As...
So, I have a pretty specific thing to do that is rather hard to explain in the title but I hope it gives a general idea. Now, on to what I actually would like to be able to do and I'm not sure what is the best way to tackle it:
* have a set of data tables that are something like:
A - 100...
I'll try and explain this as best as I can.
I have a data set with say 5 companies across the top and then data for the next 5days underneath the company headings.
On the next sheet I want to show the cross correlation of this data for each company combination. I know how to do this and so...
Would appreciate any help with the following:
I have a dataset which looks like this:
<TABLE style="WIDTH: 368pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=491><COLGROUP><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913"...
Hi all, I am a total novice to VBA and I need to build a macro that takes
data ordered by row (each rows has about 15 data cells) and calculate a correlation matrix.
Thus comparing each row with each other.
I know that Tools/data analalysis/correlation is the command I need
but I need an...