SPSS Syntax Coding

Document Sample
SPSS Syntax Coding Powered By Docstoc
					                                                                  Computer Example #25
                                                          ACOVA - LA & OC High Schools

SPSS Syntax Coding

(Click here to download the SPSS syntax file)


title 'LA & Orange County High Schools'.
data list records=1
  /1 schid api99 strank pctmeal pctel avged pctcred district
  (1x,f7.0,2x,f6.2,4x,f4.2,3x,f5.2,3x,f5.2,4x,f4.2,3x,f5.2,4x,f1.0).
begin data.
 6011225 504.00 2.00 56.00 39.00 2.25 92.00 1.00
   (Entire data list is five pages long, so only first and last listed here)
 6115588 538.00 3.00 82.00 61.00 1.91 86.00 2.00
end data.
var labels schid 'school code' api99 '1999 API Score'
  strank 'state rank score' pctmeal 'percent free/reduced meal'
  pctel 'percent english language learners' pctcred 'percent credentialed teachers'
  avged 'average parent education' district '1=LA, 2=OC'.
missing values strank,pctmeal,pctcred (0).
compute inter1=pctmeal*district.
compute inter2=avged*district.
compute inter3=pctcred*district.
comment start here.
select if (pctmeal ge 0 and avged ge 0 and pctcred ge 0).
means var=api99,pctmeal,avged,pctcred by district.
regression var=api99,district/statistics=cha,coeff,anova/dep=api99/method=enter..
regression var=api99,pctmeal to pctcred,district/statistics=cha,coeff,anova/dep=api99/
    forward pctmeal to pctcred/forward district.
regression var=api99,pctmeal,avged,pctcred,district,inter1 to inter3/
   statistics=cha,coeff,anova/dep=api99/
    enter pctmeal,avged,pctcred/enter district/enter inter1 inter2 inter3.




                                                                                     Page 1 of 7
                                                                     Computer Example #25
                                                             ACOVA - LA & OC High Schools
Output
LA & Orange County High Schools
Data List will read 1 records from the command file

Variable               Rec       Start        End     Format

schid                    1           2          8     F7.0
api99                    1          11         16     F6.2
strank                   1          21         24     F4.2
pctmeal                  1          28         32     F5.2
pctel                    1          36         40     F5.2
avged                    1          45         48     F4.2
pctcred                  1          52         56     F5.2
district                 1          61         61     F1.0

Means
                                     Case Processing Summary

                                                             Cases
                                    Included                Excluded                     Total
                                  N        Percent        N       Percent          N          Percent
  1999 API Score * 1=LA,
                                   225       100.0%            0        .0%            225    100.0%
  2=OC
  percent free/reduced
                                   225       100.0%            0        .0%            225    100.0%
  meal * 1=LA, 2=OC
  average parent education
                                   225       100.0%            0        .0%            225    100.0%
  * 1=LA, 2=OC
  percent credentialed
                                   225       100.0%            0        .0%            225    100.0%
  teachers * 1=LA, 2=OC


                                          Report

                                                  percent        average         percent
                                  1999 API     free/reduced       parent      credentialed
  1=LA, 2=OC                       Score           meal         education       teachers
  1             Mean              567.6183           55.4247       2.6287          77.8441
                N                      186               186          186              186
                Std. Deviation   120.19853         27.19812        .61445         11.61604
  2             Mean              650.2564           44.4615       2.7372          92.0000
                N                       39                39            39               39
                Std. Deviation   123.26837         26.31774        .72030          4.77383
  Total         Mean              581.9422           53.5244       2.6475          80.2978
                N                      225               225          225              225
                Std. Deviation   124.47038         27.30827        .63366         12.00615




                                                                                       Page 2 of 7
                                                                      Computer Example #25
                                                              ACOVA - LA & OC High Schools

Regression
         Variables Entered/Removed b

          Variables      Variables
 Model    Entered        Removed         Method
 1       1=LA,a
                                     .   Enter
         2=OC
   a. All requested variables entered.
   b. Dependent Variable: 1999 API Score


                            Model Summary

                                Change Statistics
          R Square                                                   Sig. F
 Model    Change     F Change             df1            df2        Change
 1             .063a    15.106                    1         223         .000
   a. Predictors: (Constant), 1=LA, 2=OC


                                           ANOVAb

                          Sum of
 Model                   Squares            df         Mean Square        F         Sig.
 1       Regression      220168.9                  1    220168.915       15.106       .000a
         Residual         3250235                223     14575.046
         Total            3470404                224
   a. Predictors: (Constant), 1=LA, 2=OC
   b. Dependent Variable: 1999 API Score


                                          Coefficients a

                             Unstandardized             Standardized
                              Coefficients              Coefficients
 Model                       B        Std. Error            Beta            t        Sig.
 1       (Constant)        484.980       26.214                            18.501      .000
         1=LA, 2=OC         82.638       21.262                   .252      3.887      .000
   a. Dependent Variable: 1999 API Score




                                                                                       Page 3 of 7
                                                                     Computer Example #25
                                                             ACOVA - LA & OC High Schools

Regression
           Variables Entered/Removed a

            Variables     Variables
 Model      Entered       Removed          Method
 1
                                          Forward
                                          (Criterion:
           average
                                          Probabilit
           parent                     .
                                          y-of-
           education
                                          F-to-enter
                                          <= .050)
 2
                                          Forward
                                          (Criterion:
           percent
                                          Probabilit
           credentiale                .
                                          y-of-
           d teachers
                                          F-to-enter
                                          <= .050)
 3
                                          Forward
                                          (Criterion:
           percent
                                          Probabilit
           free/reduc                 .
                                          y-of-
           ed meal
                                          F-to-enter
                                          <= .050)
 4
                                          Forward
                                          (Criterion:
           1=LA,                          Probabilit
                                      .
           2=OC                           y-of-
                                          F-to-enter
                                          <= .050)

     a. Dependent Variable: 1999 API Score


                             Model Summary

                                Change Statistics
            R Square                                                 Sig. F
 Model      Change      F Change      df1               df2         Change
 1               .778a    779.341           1              223          .000
 2               .078 b   119.340           1              222          .000
 3               .010c     15.856           1              221          .000
 4               .005d      8.148           1              220          .005
     a. Predictors: (Constant), average parent education
     b. Predictors: (Constant), average parent education, percent
        credentialed teachers
     c. Predictors: (Constant), average parent education, percent
        credentialed teachers, percent free/reduced meal
     d. Predictors: (Constant), average parent education, percent
        credentialed teachers, percent free/reduced meal, 1=LA, 2=OC




                                                                                Page 4 of 7
                                                                     Computer Example #25
                                                             ACOVA - LA & OC High Schools

                                          ANOVAe

                           Sum of
Model                     Squares         df         Mean Square        F          Sig.
1         Regression       2698312               1   2698311.574      779.341        .000a
          Residual        772092.7             223      3462.299
          Total            3470404             224
2         Regression       2968252               2   1484126.019      656.128         .000b
          Residual        502152.2             222      2261.947
          Total            3470404             224
3         Regression       3001868               3   1000622.818      471.976         .000c
          Residual        468535.8             221      2120.071
          Total            3470404             224
4         Regression       3018601               4    754650.251      367.468         .000d
          Residual        451803.2             220      2053.651
          Total            3470404             224
    a. Predictors: (Constant), average parent education
    b. Predictors: (Constant), average parent education, percent credentialed teachers
    c. Predictors: (Constant), average parent education, percent credentialed teachers,
       percent free/reduced meal
    d. Predictors: (Constant), average parent education, percent credentialed teachers,
       percent free/reduced meal, 1=LA, 2=OC
    e. Dependent Variable: 1999 API Score


                                                Coefficients a

                                          Unstandardized           Standardized
                                           Coefficients            Coefficients
Model                                     B        Std. Error          Beta           t           Sig.
1         (Constant)                    123.385       16.888                          7.306         .000
          average parent education      173.206        6.204               .882      27.917         .000
2         (Constant)                    -67.805       22.195                         -3.055         .003
          average parent education      150.480        5.429               .766      27.717         .000
          percent credentialed
                                           3.130           .287            .302      10.924         .000
          teachers
3         (Constant)                     51.284         36.826                        1.393         .165
          average parent education      128.162          7.684             .652      16.679         .000
          percent credentialed
                                           2.868           .285            .277      10.057         .000
          teachers
          percent free/reduced
                                            -.727          .183           -.160      -3.982         .000
          meal
4         (Constant)                     42.946         36.362                        1.181         .239
          average parent education      131.093          7.632             .667      17.177         .000
          percent credentialed
                                           2.477           .312            .239       7.932         .000
          teachers
          percent free/reduced
                                            -.694          .180           -.152      -3.855         .000
          meal
          1=LA, 2=OC                    25.739            9.017            .078       2.854         .005
    a. Dependent Variable: 1999 API Score




                                                                                          Page 5 of 7
                                                                     Computer Example #25
                                                             ACOVA - LA & OC High Schools

Regression
           Variables Entered/Removed b

            Variables      Variables
 Model       Entered       Removed         Method
 1         percent
           credentiale
           d teachers,
           average
           parent                      .   Enter
           education,
           percent
           free/reduc
                   a
           ed meal
 2         1=LA,a
                                       .   Enter
           2=OC
 3         inter1,
           inter2,
                 a
                                       .   Enter
           inter3
     a. All requested variables entered.
     b. Dependent Variable: 1999 API Score


                              Model Summary

                               Change Statistics
            R Square                                              Sig. F
 Model      Change     F Change      df1               df2       Change
 1               .865a   471.976           3              221        .000
 2               .005b     8.148           1              220        .005
 3               .000c      .053           3              217        .984
     a. Predictors: (Constant), percent credentialed teachers, average
        parent education, percent free/reduced meal
     b. Predictors: (Constant), percent credentialed teachers, average
        parent education, percent free/reduced meal, 1=LA, 2=OC
     c. Predictors: (Constant), percent credentialed teachers, average
        parent education, percent free/reduced meal, 1=LA, 2=OC,
        inter1, inter2, inter3




                                                                                Page 6 of 7
                                                                     Computer Example #25
                                                             ACOVA - LA & OC High Schools

                                          ANOVAd

                           Sum of
Model                     Squares         df         Mean Square        F          Sig.
1         Regression       3001868               3   1000622.818      471.976        .000a
          Residual        468535.8             221      2120.071
          Total            3470404             224
2         Regression       3018601               4    754650.251      367.468         .000b
          Residual        451803.2             220      2053.651
          Total            3470404             224
3         Regression       3018934               7    431276.226      207.294         .000c
          Residual        451470.7             217      2080.510
          Total            3470404             224
    a. Predictors: (Constant), percent credentialed teachers, average parent education,
       percent free/reduced meal
    b. Predictors: (Constant), percent credentialed teachers, average parent education,
       percent free/reduced meal, 1=LA, 2=OC
    c. Predictors: (Constant), percent credentialed teachers, average parent education,
       percent free/reduced meal, 1=LA, 2=OC, inter1, inter2, inter3
    d. Dependent Variable: 1999 API Score


                                                Coefficients a

                                           Unstandardized          Standardized
                                            Coefficients           Coefficients
Model                                      B        Std. Error         Beta           t           Sig.
1         (Constant)                      51.284       36.826                         1.393         .165
          percent free/reduced
                                            -.727         .183            -.160      -3.982         .000
          meal
          average parent education      128.162          7.684             .652      16.679         .000
          percent credentialed
                                           2.868          .285             .277      10.057         .000
          teachers
2         (Constant)                      42.946        36.362                        1.181         .239
          percent free/reduced
                                            -.694         .180            -.152      -3.855         .000
          meal
          average parent education      131.093          7.632             .667      17.177         .000
          percent credentialed
                                           2.477          .312             .239       7.932         .000
          teachers
          1=LA, 2=OC                      25.739         9.017             .078       2.854         .005
3         (Constant)                      -7.834       209.351                        -.037         .970
          percent free/reduced
                                            -.756         .968            -.166       -.780         .436
          meal
          average parent education      129.011         36.718             .657       3.514         .001
          percent credentialed
                                           3.126         1.819             .302       1.718         .087
          teachers
          1=LA, 2=OC                      75.017       198.851             .229        .377         .706
          inter1                            .059          .913             .017        .065         .948
          inter2                           2.254        33.876             .024        .067         .947
          inter3                           -.634         1.731            -.213       -.366         .714
    a. Dependent Variable: 1999 API Score




                                                                                          Page 7 of 7