Means are reported on between in multilevel modeling. I doubt that SPSS gives both within and between sample statistics. To compare the programs use TYPE=GENERAL.
Zen Goh posted on Thursday, June 26, 2014 - 7:57 pm
Hi, thanks for the quick reply!
Yes, SPSS doesn't give within sample statistics- I compared only for between sample statistics. I wasn't clear. I also used your suggestion.
it says that:
TITLE: Workload and Life Satisfaction Multilevel moderated mediation analysis L1: X (wload), Y (lsat), M1 (wfc-timestrain), M2 (wfc-emo3) L2: W (wfc specific-mgsup) - L2 DATA: FILE IS IC_Aggregate_WFCemo and WFCtsb.csv; VARIABLE: NAMES = clust x m1 m2 y w; MISSING ARE ALL (-1); USEVARIABLES ARE x m1 m2 y w; ANALYSIS: TYPE = GENERAL;
*** WARNING in MODEL command All variables are uncorrelated with all other variables in the model. Check that this is what is intended. 1 WARNING(S) FOUND IN THE INPUT INSTRUCTIONS
2 problems I found: > The variables are correlated in SPSS but not in Mplus > my Mplus estimates for W are way too high: mean = 6.2 (it's a 5 point scale)and variance is 312.
Could it be some problem with the way I saved/formatted the data? I simply saved SPSS as a .csv file.
You may be reading your data incorrectly. I would do a TYPE=BASIC with no MODEL command and compare that to the same in SPSS. I would not complicate things with the multilevel component until I was sure that data are being read correctly. Check the means and sample size. You may have blanks in the data set. SPSS uses blanks as certain types of missing data and this is not allowed with free format data.
Then your multilevel results should be correct. I don't believe SPSS does multilevel analysis so the comparison should not be with multilevel results.
Tyler Burch posted on Friday, October 30, 2015 - 9:08 am
I have a related issue. I run ANALYSIS: TYPE=BASIC and compare it to the descriptives produced in SPSS. The ESTIMATED SAMPLE STATISTICS and the UNIVARIATE HIGHER-ORDER MOMENT DESCRIPTIVE STATISTICS means do not match within the MPLUS output. I am not sure why this is. The UNIVARIATE HIGHER-ORDER MOMENT DESCRIPTIVE STATISTICS descriptive statistics match the SPSS descriptives output perfectly, but I want to make sure that I am not missing something being that the means within the output do not match.
You can use some code like that to get the estimated quartiles.
MODEL: [y] (m); y (v); model constraints: new(q1); q1= m-0.6745*v; new(q2); q2= m+0.6745*v;
If you want the sample values you can get these in excel by ordering the data and adding up the weights - form a column that has sum(w1:wi) and then find the values in the summed weights column that matches 0.25*N, 0.5*N, 0.75*N You can use the standardized weights that Mplus produces with the savedata command.