correl covar for two dimensional table

A

ALNIOS ANOGIS

Dear,

I have table.

x/y 4 6 8 p(x)
14 0.16 0.19 0.12 0.47
16 0.14 0.19 0.2 0.53
p(y) 0.3 0.38 0.32 1

correl=0.1976 covar=0.1257

Would you give me the way to get results of ?

Regards,Junho
 
J

joel

ALNIOS said:
Dear,

I have table.

x/y 4 6 8 p(x)
14 0.16 0.19 0.12 0.47
16 0.14 0.19 0.2 0.53
p(y) 0.3 0.38 0.32 1

correl=0.1976 covar=0.1257

Would you give me the way to get results of ?

Regards,Junho
Click to expand...

You can use the following from VBA

Results = Application.WorksheetFunction.Correl(Array1, Array2)

Results = Application.WorksheetFunction.Covar(Array1, Array2)

The Arrays have to start at index 0.
 
Top