* Encoding: UTF-8.
##Remove all NON-IL, MO, and TX people into separate document
 
DATASET ACTIVATE DataSet1.
DATASET COPY  NotILMOTX.
DATASET ACTIVATE  NotILMOTX.
FILTER OFF.
USE ALL.
SELECT IF (tea_STATEcoded < 9).
EXECUTE.
DATASET ACTIVATE  DataSet1.

#Create Filter Variable for Included v. excluded 
    
DATASET ACTIVATE DataSet1.
USE ALL.
COMPUTE filter_$=((sch_pub = 1) AND (sch_grade <9) AND (tea_sped =1) AND (case_IDD = 1) AND 
    (stu_goal <9) AND (NVALID(tea_course)) AND (NVALID(tea_prof)) AND (NVALID(SexMastery)) AND 
    (tea_STATEcoded < 9)).
VARIABLE LABELS filter_$ '(sch_pub = 1) AND (sch_grade <9) AND (tea_sped =1) AND (case_IDD = 1) '+
    'AND (stu_goal <9) AND (NVALID(tea_course)) AND (NVALID(tea_prof)) AND (NVALID(SexMastery)) '+
    'AND (tea_STATEcoded < 9) (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.


####Turn Filter Off 
    
FILTER OFF .
USE ALL.

##Compare gender differences between responders and non-responders
    
CROSSTABS
  /TABLES=tea_gen BY filter_$
  /FORMAT=AVALUE TABLES
  /STATISTICS=CHISQ 
  /CELLS=COUNT ROW 
  /COUNT ROUND CELL.

## Create White v. Nonwhite variable 
   
RECODE tea_race_1 (1=1) (ELSE=0) INTO WhitevNonwhite.
EXECUTE.

##Compare white v. non white responders and non-responders
    
CROSSTABS
  /TABLES=WhitevNonwhite BY filter_$
  /FORMAT=AVALUE TABLES
  /STATISTICS=CHISQ 
  /CELLS=COUNT ROW 
  /COUNT ROUND CELL.


##Create a Course + PD variable

COMPUTE CourseandPD=CourseRegression + ProfDevRegression.
EXECUTE.

##Create HSvMid variable

RECODE sch_grade (1=1) (ELSE=2) INTO MidHighSchool.
EXECUTE.

##Combine suburban and urban

RECODE sch_comm (3=2) (ELSE=Copy) INTO SchLocationRegression.
EXECUTE.

##Descriptives 
    
DATASET ACTIVATE DataSet1.
FREQUENCIES VARIABLES=tea_sped case_IDD sch_pub sch_grade sch_comm stu_alt sch_coord stu_gen 
    stu_goal stu_num tea_years tea_STATEcoded tea_course tea_prof tea_age tea_gen
  /ORDER=ANALYSIS.

##Univariate 
    
#Correlation between years of experience and mastery 
    
* Chart Builder.
GGRAPH
  /GRAPHDATASET NAME="graphdataset" VARIABLES=tea_years TOTALMastery MISSING=LISTWISE 
    REPORTMISSING=NO
  /GRAPHSPEC SOURCE=INLINE
  /FITLINE TOTAL=NO SUBGROUP=NO.
BEGIN GPL
  SOURCE: s=userSource(id("graphdataset"))
  DATA: tea_years=col(source(s), name("tea_years"))
  DATA: TOTALMastery=col(source(s), name("TOTALMastery"))
  GUIDE: axis(dim(1), label("How many years have you been a special education teacher?"))
  GUIDE: axis(dim(2), label("TOTALMastery"))
  GUIDE: text.title(label("Scatter Plot of TOTALMastery by How many years have you been a ",
    "special education teacher?"))
  ELEMENT: point(position(tea_years*TOTALMastery))
END GPL.

CORRELATIONS
  /VARIABLES=tea_years TOTALMastery
  /PRINT=TWOTAIL NOSIG FULL
  /STATISTICS DESCRIPTIVES
  /MISSING=PAIRWISE.

EXAMINE VARIABLES=tea_years TOTALMastery
  /PLOT STEMLEAF NPPLOT
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

##Univariate for Race - T test 

EXAMINE VARIABLES=TOTALMastery BY WhitevNonwhite
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS=WhitevNonwhite(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##UNivariate for Course- T-Test 

EXAMINE VARIABLES=TOTALMastery BY CourseRegression
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= CourseRegression (1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univariate for PD- T -test 
   
EXAMINE VARIABLES=TOTALMastery BY ProfDevRegression
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= ProfDevRegression (1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univariate for location of school 
    
EXAMINE VARIABLES=TOTALMastery BY SchLocationRegression
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= SchLocationRegression (1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univariate for Type of school 
    
EXAMINE VARIABLES=TOTALMastery BY MidHighSchool
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= MidHighSchool (1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univariate for teacher education 
    
EXAMINE VARIABLES=TOTALMastery BY TeacherEdRegression
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= TeacherEdRegression (1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univarite for student support needs

EXAMINE VARIABLES=TOTALMastery BY StuSupportRegression
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= StuSupportRegression (1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univariate for transition coordinator 
    
EXAMINE VARIABLES=TOTALMastery BY TransCoordRegression
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

T-TEST GROUPS= TransCoordRegression(1 0)
  /MISSING=ANALYSIS
  /VARIABLES=TOTALMastery
  /ES DISPLAY(TRUE)
  /CRITERIA=CI(.95).

##Univariate for STate - ANOVA 
   

EXAMINE VARIABLES=TOTALMastery BY tea_STATEcoded
  /PLOT BOXPLOT NPPLOT
  /COMPARE GROUPS
  /STATISTICS DESCRIPTIVES
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

ONEWAY TOTALMastery BY tea_STATEcoded
  /ES=OVERALL
  /STATISTICS DESCRIPTIVES HOMOGENEITY WELCH 
  /PLOT MEANS
  /MISSING ANALYSIS
  /CRITERIA=CILEVEL(0.95)
  /POSTHOC=TUKEY GH ALPHA(0.05).

UNIANOVA TOTALMastery BY tea_STATEcoded
  /METHOD=SSTYPE(3)
  /INTERCEPT=INCLUDE
  /PRINT ETASQ
  /CRITERIA=ALPHA(.05)
  /DESIGN=tea_STATEcoded.


##LINEAR REGRESSION 

REGRESSION
  /DESCRIPTIVES MEAN STDDEV CORR SIG N
  /MISSING LISTWISE
  /STATISTICS COEFF OUTS CI(95) R ANOVA COLLIN TOL ZPP
  /CRITERIA=PIN(.05) POUT(.10)
  /NOORIGIN 
  /DEPENDENT TOTALMastery
  /METHOD=ENTER WhitevNonwhite tea_years CourseRegression ProfDevRegression SchLocationRegression 
    MidHighSchool TeacherEdRegression StuSupportRegression TransCoordRegression IllinoisRegression 
    MissouriRegression
  /PARTIALPLOT ALL
  /SCATTERPLOT=(*ZRESID ,*ZPRED)
  /RESIDUALS DURBIN HISTOGRAM(ZRESID) NORMPROB(ZRESID)
  /CASEWISE PLOT(ZRESID) OUTLIERS(3)
  /SAVE PRED COOK LEVER SRESID.

* Chart Builder.
GGRAPH
  /GRAPHDATASET NAME="graphdataset" VARIABLES=PRE_1 SRE_1 MISSING=LISTWISE REPORTMISSING=NO
  /GRAPHSPEC SOURCE=INLINE
  /FITLINE TOTAL=NO SUBGROUP=NO.
BEGIN GPL
  SOURCE: s=userSource(id("graphdataset"))
  DATA: PRE_1=col(source(s), name("PRE_1"))
  DATA: SRE_1=col(source(s), name("SRE_1"))
  GUIDE: axis(dim(1), label("Unstandardized Predicted Value"))
  GUIDE: axis(dim(2), label("Studentized Residual"))
  GUIDE: text.title(label("Scatter Plot of Studentized Residual by Unstandardized Predicted Value"))    
  ELEMENT: point(position(PRE_1*SRE_1))
END GPL.


##TABLE1 Demographics

DATASET ACTIVATE DataSet1.
FREQUENCIES VARIABLES=tea_gen tea_race_6 tea_race_5 tea_race_3 tea_race_4 tea_race_2 tea_race_1 
    tea_race_9 tea_race_9_TEXT tea_edu_9_TEXT sch_comm sch_grade stu_alt stu_gen stu_goal sch_coord
  /ORDER=ANALYSIS.

##Demographics by state
    
CROSSTABS
  /TABLES=tea_STATEcoded BY tea_gen tea_race_6 tea_race_5 tea_race_3 tea_race_4 tea_race_2 tea_race_1 
    tea_race_9 tea_race_9_TEXT tea_edu_9_TEXT sch_comm sch_grade stu_alt stu_gen stu_goal sch_coord
  /FORMAT=AVALUE TABLES
  /CELLS=COUNT ROW
  /COUNT ROUND CELL.

CROSSTABS
  /TABLES=tea_race_6 tea_race_5 tea_race_3 tea_race_4 tea_race_2 tea_race_1 tea_race_9 tea_edu 
    sch_grade sch_comm sch_grade stu_alt stu_goal stu_gen sch_coord BY tea_STATEcoded
  /FORMAT=AVALUE TABLES
  /CELLS=COUNT COLUMN
  /COUNT ROUND CELL.

DATASET ACTIVATE DataSet1.
FILTER OFF.
USE ALL.
EXECUTE.