| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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> |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a Two Dimensional Table | Excel Discussion (Misc queries) | |||
| Export 1-dimensional array values to a two-dimensional table? | Excel Programming | |||
| CORREL versus COVAR/STDEV^2.......why different? | Excel Discussion (Misc queries) | |||
| Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
| how do i set up a three dimensional table | Excel Discussion (Misc queries) | |||
![joel[_160_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
