1 FUNCTIONS

2 DATA PREPARATION

2.1 Load all sheets of an Excel

2.2 Convert all data in wide-format within one sheet

2.3 Convert all data in matrix format

## 正在处理行:  r 
## 正在处理行:  C-r 
## 正在处理行:  SD-r 
## 正在处理行:  SD-cr 
## 正在处理行:  Sample size 
## 正在处理行:  K Size 
## 正在处理行:  95%CI-L 
## 正在处理行:  95%CI-U
## Statistics of matrix
## ────────────────────────────
##    harmonic_mean         sum
## ────────────────────────────
## 1      26688.743 1665319.286
## ────────────────────────────
## Descriptive Statistics:
## ────────────────────────────────────────────────────────────────────────
##     N      Mean        SD |   Median     Min       Max Skewness Kurtosis
## ────────────────────────────────────────────────────────────────────────
##    10 166531.93 279212.22 | 69520.14 6647.00 936177.57     2.03     2.81
## ────────────────────────────────────────────────────────────────────────
## Statistics of matrix
## ──────────────────────────
##    harmonic_mean       sum
## ──────────────────────────
## 1        143.080 10395.000
## ──────────────────────────
## Descriptive Statistics:
## ──────────────────────────────────────────────────────────────
##     N    Mean      SD | Median   Min     Max Skewness Kurtosis
## ──────────────────────────────────────────────────────────────
##    10 1039.50 1373.53 | 603.00 37.00 4543.00     1.53     1.34
## ──────────────────────────────────────────────────────────────

3 FULL MODEL

## 
## Fit Measures (lavaan):
## χ²(1, N = 26688) = 1752.614, p < 1e-99 ***
## χ²/df = 1752.614
## AIC = 296132.760 (Akaike Information Criterion)
## BIC = 296239.256 (Bayesian Information Criterion)
## CFI = 0.796 (Comparative Fit Index)
## TLI = -1.041 (Tucker-Lewis Index; Non-Normed Fit Index, NNFI)
## NFI = 0.796 (Normed Fit Index)
## IFI = 0.796 (Incremental Fit Index)
## GFI = 0.969 (Goodness-of-Fit Index)
## AGFI = 0.536 (Adjusted Goodness-of-Fit Index)
## RMSEA = 0.256, 90% CI [0.246, 0.266] (Root Mean Square Error of Approximation)
## SRMR = 0.068 (Standardized Root Mean Square Residual)
## 
## Model Estimates (lavaan):
## ──────────────────────────────────────────────────────────────────────────
##                    Estimate    S.E.       z     p       LLCI   ULCI   Beta
## ──────────────────────────────────────────────────────────────────────────
## Regression Paths:                                                         
##   Mp <- X (Xp)        0.159 (0.006)  26.242 <.001 ***  0.147  0.170  0.159
##   Ms <- X (Xs)        0.134 (0.006)  22.105 <.001 ***  0.122  0.146  0.134
##   Yi <- X (Xi)        0.042 (0.006)   7.106 <.001 ***  0.031  0.054  0.043
##   Yi <- Mp (Yip)      0.121 (0.006)  20.498 <.001 ***  0.109  0.132  0.122
##   Yi <- Ms (Yis)      0.245 (0.006)  41.681 <.001 ***  0.233  0.256  0.247
##   Yt <- X (Xt)        0.063 (0.006)  10.485 <.001 ***  0.051  0.074  0.063
##   Yt <- Mp (Ytp)      0.104 (0.006)  17.603 <.001 ***  0.093  0.116  0.105
##   Yt <- Ms (Yts)      0.232 (0.006)  39.306 <.001 ***  0.220  0.243  0.233
## Defined Effects:                                                          
##   XMdiff              0.025 (0.009)   2.862  .004 **   0.008  0.041  0.025
##   XYdiff             -0.020 (0.008)  -2.609  .009 **  -0.036 -0.005 -0.020
##   YMidiff            -0.124 (0.008) -14.898 <.001 *** -0.140 -0.108 -0.125
##   YMtdiff            -0.128 (0.008) -15.272 <.001 *** -0.144 -0.111 -0.128
##   MedMpYi             0.019 (0.001)  16.154 <.001 ***  0.017  0.021  0.019
##   MedMpYt             0.017 (0.001)  14.619 <.001 ***  0.014  0.019  0.017
##   MedMsYi             0.033 (0.002)  19.529 <.001 ***  0.030  0.036  0.033
##   MedMsYt             0.031 (0.002)  19.267 <.001 ***  0.028  0.034  0.031
##   MdifYi             -0.014 (0.002)  -6.640 <.001 *** -0.018 -0.010 -0.014
##   MdifYt             -0.015 (0.002)  -7.390 <.001 *** -0.018 -0.011 -0.015
## ──────────────────────────────────────────────────────────────────────────
## Note. Raw (Standard) Confidence Interval (CI) and SE.

4 COMPARE MS ON X

5 COMPARE YI ON MS

6 COMPARE YT ON MS

7 FIT SUMMARY

## ──────────────────────────────────────────────────────────────────────────────────────
##      Model ChiSqM_Value ChiSqM_DF ChiSqM_PValue   CFI  SRMR ChiSq_Diff DF_Diff ChiSq_p
## ──────────────────────────────────────────────────────────────────────────────────────
## 1  Model 1     1752.614     1.000         0.000 0.796 0.068                           
## 2  Model 2     1760.806     2.000         0.000 0.795 0.068      8.192   1.000   0.004
## 3  Model 3     1918.091     2.000         0.000 0.777 0.070    165.477   1.000   0.000
## 4  Model 4     1926.479     2.000         0.000 0.776 0.070    173.865   1.000   0.000
## ──────────────────────────────────────────────────────────────────────────────────────