Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hi
Hi
How can I calculate Covariance matrices in Excel VBA? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|