I replicated table 9 column A.
You should add the following in your spreadsheet "syntax".
if J_Q06a_T = 2 or J_Q07a_T =2 and J_Q04a =1 Immigrant =2.
if J_Q06a_T = 2 and J_Q07a_T =2 and J_Q04a =2 Immigrant =1.
if J_Q06a_T = 1 and J_Q07a_T =1 and J_Q04a =1 Immigrant =3.
SET MXCELLS=9000.
FREQUENCIES VARIABLES=J_Q05cUSX3a J_Q05cUSX3b J_Q05cUSX3d J_Q05cUSX3e
/ORDER=ANALYSIS.
FACTOR
/VARIABLES J_Q05cUSX3a J_Q05cUSX3b J_Q05cUSX3d J_Q05cUSX3e
/MISSING LISTWISE
/ANALYSIS J_Q05cUSX3a J_Q05cUSX3b J_Q05cUSX3d J_Q05cUSX3e
/PRINT UNIVARIATE INITIAL EXTRACTION
/CRITERIA MINEIGEN(1) ITERATE(25)
/EXTRACTION PAF
/ROTATION NOROTATE
/SAVE REG(ALL)
/METHOD=CORRELATION.
SORT CASES BY RACETHN_5CAT.
SPLIT FILE SEPARATE BY RACETHN_5CAT.
MEANS TABLES=PVLIT2 PVLIT3 PVLIT4 PVNUM1 PVNUM2 PVNUM3 PVNUM4 PVNUM5 PVNUM6 PVNUM7 PVNUM8 PVNUM9 PVNUM10 PVLIT5 PVLIT6 PVLIT7 PVLIT8 PVLIT10 PVLIT1 PVLIT9 BY Immigrant
/CELLS=MEAN COUNT STDDEV.
MEANS TABLES=FAC1_1 PVLIT2 BY Immigrant
/CELLS=MEAN COUNT STDDEV.
WEIGHT BY SPFWT0.
MEANS TABLES=PVLIT2 PVLIT3 PVLIT4 PVNUM1 PVNUM2 PVNUM3 PVNUM4 PVNUM5 PVNUM6 PVNUM7 PVNUM8 PVNUM9 PVNUM10 PVLIT5 PVLIT6 PVLIT7 PVLIT8 PVLIT10 PVLIT1 PVLIT9 BY Immigrant
/CELLS=MEAN COUNT STDDEV.
MEANS TABLES=FAC1_1 PVLIT2 BY Immigrant
/CELLS=MEAN COUNT STDDEV.
Also, you must say explicitly what the sign of the d gap means here. because it's not what one would expect. The highest score means "not at all". So, 1st generation people have higher score on the english variable, which is not even an ability test, as said (wrongly) in your text because it's just a questionnaire. Categorical variable (4 values). I don't think it's good method to perform PCA or PAF on this type of variables.
Look here
https://nces.ed.gov/surveys/piaac/final_en_bq.htm[J_R05cUSX3a] With regard to English, how well do you ...
[J_Q05cUSX3a] understand it when it is spoken to you? Would you say ...
Responses
[ layout = radioButton ]
01 Very well
02 Well
03 Not well
04 Not at all
DK
RF
[J_Q05cUSX3b] speak it? Would you say ...
[J_Q05cUSX3d] read it? Would you say ...
[J_Q05cUSX3e] write it? Would you say ...
That's very, very wrong...
If you want to add it nonetheless, I want you to write the sample size in your text, or at the bottom of the table 9.
For english "ability" the sample is 249, 160, 131 for hisp 1st, 2nd, 3rd, and 92, 185, and 3005 for white 1st, 2nd, 3rd, and 57, 28, 544, for black 1st, 2nd, 3rd, and 157, 49, 22, for asians 1st, 2nd, 3rd, respectively.
For the other scales (literacy/numeracy) the sample is the same for every groups, except for asian 1st generation (N=158).
I will need to figure out how you did for the column b and c. But now I'm exhausted. Too much.
Concerning grade 8 TIMSS 2003, I just said it's better to display the information, and let the reader knows that the d gaps in this year has the same pattern as the others. Same thing for sample size (unweighted) for various (sub)groups which must be always reported when the numbers are available.
----
----
EDIT- I attach my replication (xls spreadsheet), if you really want to add that analysis (but which should better be deleted in my opinion) I want you to add the numbers on my file in yours. We need transparency about the method, analysis and all.