Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correlation Matrix using VBA
Hi
I was wondering if anyone was able to provide some assistance to produce a correlation matrix code in VBA? Any help would be greatful Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correlation Matrix using VBA
Range? sheet? cell?
"Zoheb" wrote: Hi I was wondering if anyone was able to provide some assistance to produce a correlation matrix code in VBA? Any help would be greatful Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correlation Matrix using VBA
Zoheb -
The Correlation tool of Excel's Analysis ToolPak provides this feature, i.e., all pairwise correlation coefficients for data sets with two or more variables. The results are equivalent to using the CORREL worksheet function on pairs of variables in a multivariate data set. Do you want to replicate that functionality, or do you want something that the Correlation tool doesn't provide? - Mike Middleton http://www.MikeMiddleton.com "Zoheb" wrote in message ... Hi I was wondering if anyone was able to provide some assistance to produce a correlation matrix code in VBA? Any help would be greatful Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correlation Matrix using VBA
Mike -
Thanks for the response I have 30 sets of data over a certain time period and want to produce a correlation matrix of it. I have used the Analysis ToolPak to calculate what the answers should be and I want to replicate this in VBA, preferably using loop functions. Thanks Zoheb "Mike Middleton" wrote: Zoheb - The Correlation tool of Excel's Analysis ToolPak provides this feature, i.e., all pairwise correlation coefficients for data sets with two or more variables. The results are equivalent to using the CORREL worksheet function on pairs of variables in a multivariate data set. Do you want to replicate that functionality, or do you want something that the Correlation tool doesn't provide? - Mike Middleton http://www.MikeMiddleton.com "Zoheb" wrote in message ... Hi I was wondering if anyone was able to provide some assistance to produce a correlation matrix code in VBA? Any help would be greatful Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correlation Matrix using VBA
Zoheb -
I'm working on other projects, and I'm not interested in writing VBA code to replicate the Analysis ToolPak. If you have thought about the exact specifications, like the specific input data and specific output, and if you have decided how general-purpose you want your code to be (variable number of columns, etc.), then if you post the code you have so far, it's likely that someone will help you. - Mike "Zoheb" wrote in message ... Mike - Thanks for the response I have 30 sets of data over a certain time period and want to produce a correlation matrix of it. I have used the Analysis ToolPak to calculate what the answers should be and I want to replicate this in VBA, preferably using loop functions. Thanks Zoheb "Mike Middleton" wrote: Zoheb - The Correlation tool of Excel's Analysis ToolPak provides this feature, i.e., all pairwise correlation coefficients for data sets with two or more variables. The results are equivalent to using the CORREL worksheet function on pairs of variables in a multivariate data set. Do you want to replicate that functionality, or do you want something that the Correlation tool doesn't provide? - Mike Middleton http://www.MikeMiddleton.com "Zoheb" wrote in message ... Hi I was wondering if anyone was able to provide some assistance to produce a correlation matrix code in VBA? Any help would be greatful Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Correlation Matrix | New Users to Excel | |||
Correlation matrix | Excel Discussion (Misc queries) | |||
Correlation Matrix | Excel Worksheet Functions | |||
Correlation matrix | Excel Worksheet Functions | |||
correlation matrix | Excel Programming |