hi
 

Hi

How can I calculate Covariance matrices in Excel VBA?


Many thanks

hi
 

Hi Teena,

Look up COVAR function in help

--
Regards,

OssieMac


"Teena" wrote:

Hi

How can I calculate Covariance matrices in Excel VBA?


Many thanks

hi
 

Hi again Teena,

Perhaps an example of using the code in VBA is what you are really after.
You need to specify that it is a worksheet function.

Dim MyResult As Double

MyResult = WorksheetFunction.Covar(Range("A2:A6"), Range("B2:B6"))

MsgBox MyResult


--
Regards,

OssieMac


"Teena" wrote:

Hi

How can I calculate Covariance matrices in Excel VBA?


Many thanks