ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hi (https://www.excelbanter.com/excel-programming/424433-hi.html)

Teena

Hi
How can I calculate covariance matrix in excel vba?

Many thanks

OssieMac

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

All times are GMT +1. The time now is 10:43 AM.