correl covar for two dimensional table
 

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

correl covar for two dimensional table
 

ALNIOS ANOGIS;545066 Wrote:
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

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.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149985

<a href="http://www.thecodecage.com">Microsoft Office Help</a>