金融建模（EXCEL）課程ch10

1、1.1 2006 by shao jianli l e c t u r e 1 0 1.2 2006 by shao jianli 1.3 2006 by shao jianli 1.4 2006 by shao jianli 1.5 2006 by shao jianli 1.6 2006 by shao jianli 1.7 2006 by shao jianli 1.8 2006 by shao jianli 1.9 2006 by shao jianli 1.10 2006 by shao jianli 1 m m 1.11 2006 by shao jianli 1.12 2006

2、by shao jianli function varcovar(rng.range) as variant dim i as integer dim j as integer dim numcols as integer numcols = rng. columns.count dim matrix( ) as double redim matrix(numcols - 1, numcols- 1) for i = j to numcols for j = 1 to numcols matrix(i - 1, j - 1) = application.worksheetfunction. c

3、ovar(rng.columns(i), rng.columns(j) next j varcovar=matrix end function 1.13 2006 by shao jianli 1.14 2006 by shao jianli 1.15 2006 by shao jianli 1.16 2006 by shao jianli 1.17 2006 by shao jianli 1.18 2006 by shao jianli 1.19 2006 by shao jianli 1.20 2006 by shao jianli 1.21 2006 by shao jianli 1.2

4、2 2006 by shao jianli 1.23 2006 by shao jianli 1.24 2006 by shao jianli 1.25 2006 by shao jianli 1.26 2006 by shao jianli 1.27 2006 by shao jianli 1.28 2006 by shao jianli ij 1.29 2006 by shao jianli 1.30 2006 by shao jianli 1.31 2006 by shao jianli 1.32 2006 by shao jianli 1.33 2006 by shao jianli 1.34 2006 by shao jianli 1.35 2006 by shao jianli 1.36 2006 by shao jianli 1.37 2006 by shao jianli 1.38 2006 by shao jianli 1.39 2006 by shao jianli 1.40 2006 by shao ji