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) = 2424.376, p < 1e-99 ***
## χ²/df = 2424.376
## AIC = 293737.276 (Akaike Information Criterion)
## BIC = 293843.771 (Bayesian Information Criterion)
## CFI = 0.792 (Comparative Fit Index)
## TLI = -1.080 (Tucker-Lewis Index; Non-Normed Fit Index, NNFI)
## NFI = 0.792 (Normed Fit Index)
## IFI = 0.792 (Incremental Fit Index)
## GFI = 0.958 (Goodness-of-Fit Index)
## AGFI = 0.371 (Adjusted Goodness-of-Fit Index)
## RMSEA = 0.301, 90% CI [0.291, 0.311] (Root Mean Square Error of Approximation)
## SRMR = 0.081 (Standardized Root Mean Square Residual)
## 
## Model Estimates (lavaan):
## ──────────────────────────────────────────────────────────────────────────
##                    Estimate    S.E.       z     p       LLCI   ULCI   Beta
## ──────────────────────────────────────────────────────────────────────────
## Regression Paths:                                                         
##   Mp <- X (Xp)        0.188 (0.006)  31.253 <.001 ***  0.176  0.200  0.188
##   Ms <- X (Xs)        0.158 (0.006)  26.157 <.001 ***  0.146  0.170  0.158
##   Yi <- X (Xi)        0.033 (0.006)   5.647 <.001 ***  0.022  0.045  0.034
##   Yi <- Mp (Yip)      0.137 (0.006)  23.653 <.001 ***  0.126  0.149  0.139
##   Yi <- Ms (Yis)      0.285 (0.006)  49.304 <.001 ***  0.274  0.296  0.288
##   Yt <- X (Xt)        0.070 (0.006)  11.720 <.001 ***  0.058  0.081  0.070
##   Yt <- Mp (Ytp)      0.104 (0.006)  17.762 <.001 ***  0.093  0.116  0.105
##   Yt <- Ms (Yts)      0.271 (0.006)  46.572 <.001 ***  0.260  0.283  0.274
## Defined Effects:                                                          
##   XMdiff              0.030 (0.009)   3.495 <.001 ***  0.013  0.047  0.030
##   XYdiff             -0.036 (0.008)  -4.703 <.001 *** -0.051 -0.021 -0.036
##   YMidiff            -0.148 (0.008) -18.001 <.001 *** -0.164 -0.131 -0.149
##   YMtdiff            -0.167 (0.008) -20.251 <.001 *** -0.184 -0.151 -0.169
##   MedMpYi             0.026 (0.001)  18.860 <.001 ***  0.023  0.029  0.026
##   MedMpYt             0.020 (0.001)  15.442 <.001 ***  0.017  0.022  0.020
##   MedMsYi             0.045 (0.002)  23.107 <.001 ***  0.041  0.049  0.046
##   MedMsYt             0.043 (0.002)  22.806 <.001 ***  0.039  0.047  0.043
##   MdifYi             -0.019 (0.002)  -8.071 <.001 *** -0.024 -0.015 -0.019
##   MdifYt             -0.023 (0.002) -10.298 <.001 *** -0.028 -0.019 -0.024
## ──────────────────────────────────────────────────────────────────────────
## 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     2424.376     1.000         0.000 0.792 0.081                           
## 2  Model 2     2436.593     2.000         0.000 0.791 0.081     12.217   1.000   0.000
## 3  Model 3     2651.948     2.000         0.000 0.773 0.083    227.572   1.000   0.000
## 4  Model 4     2712.062     2.000         0.000 0.767 0.083    287.686   1.000   0.000
## ──────────────────────────────────────────────────────────────────────────────────────