| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hi
Hi
How can I calculate covariance matrix in excel vba? Many thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hi
You have posted twice but here is the answer again.
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 matrix in excel vba? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
