* Analysis For Fall 2007 PY603 exam 2

GET
  FILE='C:\Classes\00 Data Sets\CARS.sav'.

RECODE
  Size
  ('Small'=1) ('Compact'=1) ('Sporty'=1) (MISSING=SYSMIS)  (ELSE=0)  INTO  Dsmal
   l .
EXECUTE .
RECODE
  Size
  ('Large'=1) ('Van'=1) (MISSING=SYSMIS)  (ELSE=0)  INTO  Dlarge .
EXECUTE .

DESCRIPTIVES
  VARIABLES=Cylinders Engine CityMpg  /SAVE
  /STATISTICS=MEAN STDDEV MIN MAX .

Descriptives

Notes
Output Created 07-DEC-2007 17:30:11
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Missing Value Handling Definition of Missing User defined missing values are treated as missing.
Cases Used All non-missing data are used.
Syntax DESCRIPTIVES
VARIABLES=Cylinders Engine CityMpg /SAVE
/STATISTICS=MEAN STDDEV MIN MAX .
Resources Elapsed Time 0:00:00.00
Variables Created or Modified ZCylinders Zscore(Cylinders)
ZEngine Zscore(Engine)
ZCityMpg Zscore(CityMpg)

Descriptive Statistics

N Minimum Maximum Mean Std. Deviation
Cylinders 92 3.00 8.00 4.9674 1.30469
Engine 93 1.00 5.70 2.6677 1.03736
CityMpg 93 15.00 46.00 22.3656 5.61981
Valid N (listwise) 92 




compute engXdsmall = Zengine*Dsmall.
compute engXdlarge = Zengine*Dlarge.
execute.

REGRESSION
  /MISSING LISTWISE
  /STATISTICS COEFF OUTS R ANOVA CHANGE
  /CRITERIA=PIN(.05) POUT(.10)
  /NOORIGIN
  /DEPENDENT ZCityMpg
  /METHOD=ENTER ZEngine ZCylinders engXdsmall engXdlarge /method=enter Dsmall Dl
   arge
  /SAVE RESID .

Regression

Notes
Output Created 07-DEC-2007 17:30:11
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics are based on cases with no missing values for any variable used.
Syntax REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA CHANGE
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT ZCityMpg
/METHOD=ENTER ZEngine ZCylinders engXdsmall engXdlarge /method=enter Dsmall Dlarge
/SAVE RESID .
Resources Elapsed Time 0:00:00.06
Memory Required 3668 bytes
Additional Memory Required for Residual Plots 0 bytes
Variables Created or Modified RES_1 Unstandardized Residual

Variables Entered/Removed(b)
Model Variables Entered Variables Removed Method
1 engXdlarge, engXdsmall, Zscore(Cylinders), Zscore(Engine)(a) . Enter
2 Dsmall, Dlarge(a) . Enter
a All requested variables entered.
b Dependent Variable: Zscore(CityMpg)

Model Summary(c)
Model R R Square Adjusted R Square Std. Error of the Estimate Change Statistics
R Square Change F Change df1 df2 Sig. F Change
1 .789(a) .623 .606 .62830566 .623 35.929 4 87 .000
2 .815(b) .664 .640 .60009103 .041 5.187 2 85 .007
a Predictors: (Constant), engXdlarge, engXdsmall, Zscore(Cylinders), Zscore(Engine)
b Predictors: (Constant), engXdlarge, engXdsmall, Zscore(Cylinders), Zscore(Engine), Dsmall, Dlarge
c Dependent Variable: Zscore(CityMpg)

ANOVA(c)
Model
Sum of Squares df Mean Square F Sig.
1 Regression 56.734 4 14.183 35.929 .000(a)
Residual 34.345 87 .395

Total 91.079 91


2 Regression 60.469 6 10.078 27.987 .000(b)
Residual 30.609 85 .360

Total 91.079 91


a Predictors: (Constant), engXdlarge, engXdsmall, Zscore(Cylinders), Zscore(Engine)
b Predictors: (Constant), engXdlarge, engXdsmall, Zscore(Cylinders), Zscore(Engine), Dsmall, Dlarge
c Dependent Variable: Zscore(CityMpg)



Coefficients(a)
Model
Unstandardized Coefficients Standardized Coefficients t Sig.
B Std. Error Beta
1 (Constant) -.207 .084
-2.453 .016
Zscore(Engine) -.220 .244 -.219 -.904 .369
Zscore(Cylinders) -.201 .148 -.201 -1.358 .178
engXdsmall -.731 .228 -.437 -3.207 .002
engXdlarge -.005 .204 -.003 -.025 .980
2 (Constant) -.374 .146
-2.566 .012
Zscore(Engine) -.241 .246 -.240 -.981 .329
Zscore(Cylinders) -.090 .146 -.090 -.619 .537
engXdsmall -.655 .225 -.392 -2.915 .005
engXdlarge .222 .255 .129 .871 .386
Dsmall .390 .182 .195 2.140 .035
Dlarge -.339 .265 -.140 -1.276 .205
a Dependent Variable: Zscore(CityMpg)

Excluded Variables(b)
Model
Beta In t Sig. Partial Correlation Collinearity Statistics
Tolerance
1 Dsmall .244(a) 2.947 .004 .303 .579
Dlarge -.240(a) -2.359 .021 -.247 .398
a Predictors in the Model: (Constant), engXdlarge, engXdsmall, Zscore(Cylinders), Zscore(Engine)
b Dependent Variable: Zscore(CityMpg)

Residuals Statistics(a)

Minimum Maximum Mean Std. Deviation N
Predicted Value -2.8141699 1.5929598 .0103779 .81516689 92
Residual -.99424303 2.61259198 .00000000 .57997049 92
Std. Predicted Value -3.465 1.941 .000 1.000 92
Std. Residual -1.657 4.354 .000 .966 92
a Dependent Variable: Zscore(CityMpg)

REGRESSION
  /MISSING LISTWISE
  /STATISTICS COEFF OUTS R ANOVA CHANGE
  /CRITERIA=PIN(.05) POUT(.10)
  /NOORIGIN
  /DEPENDENT ZCityMpg
  /METHOD=ENTER ZCylinders ZEngine Dsmall Dlarge /method=enter engXdsmall engXdl
   arge
.

Regression

Notes
Output Created 07-DEC-2007 17:30:12
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics are based on cases with no missing values for any variable used.
Syntax REGRESSION
/MISSING LISTWISE
/STATISTICS COEFF OUTS R ANOVA CHANGE
/CRITERIA=PIN(.05) POUT(.10)
/NOORIGIN
/DEPENDENT ZCityMpg
/METHOD=ENTER ZCylinders ZEngine Dsmall Dlarge /method=enter engXdsmall engXdlarge
.
Resources Elapsed Time 0:00:00.02
Memory Required 3660 bytes
Additional Memory Required for Residual Plots 0 bytes

Variables Entered/Removed(b)
Model Variables Entered Variables Removed Method
1 Dlarge, Zscore(Cylinders), Dsmall, Zscore(Engine)(a) . Enter
2 engXdsmall, engXdlarge(a) . Enter
a All requested variables entered.
b Dependent Variable: Zscore(CityMpg)

Model Summary
Model R R Square Adjusted R Square Std. Error of the Estimate Change Statistics
R Square Change F Change df1 df2 Sig. F Change
1 .760(a) .578 .559 .66459725 .578 29.801 4 87 .000
2 .815(b) .664 .640 .60009103 .086 10.855 2 85 .000
a Predictors: (Constant), Dlarge, Zscore(Cylinders), Dsmall, Zscore(Engine)
b Predictors: (Constant), Dlarge, Zscore(Cylinders), Dsmall, Zscore(Engine), engXdsmall, engXdlarge

ANOVA(c)
Model
Sum of Squares df Mean Square F Sig.
1 Regression 52.652 4 13.163 29.801 .000(a)
Residual 38.427 87 .442

Total 91.079 91


2 Regression 60.469 6 10.078 27.987 .000(b)
Residual 30.609 85 .360

Total 91.079 91


a Predictors: (Constant), Dlarge, Zscore(Cylinders), Dsmall, Zscore(Engine)
b Predictors: (Constant), Dlarge, Zscore(Cylinders), Dsmall, Zscore(Engine), engXdsmall, engXdlarge
c Dependent Variable: Zscore(CityMpg)



Coefficients(a)
Model
Unstandardized Coefficients Standardized Coefficients t Sig.
B Std. Error Beta
1 (Constant) -.270 .147
-1.840 .069
Zscore(Cylinders) -.085 .156 -.085 -.543 .588
Zscore(Engine) -.522 .159 -.520 -3.278 .002
Dsmall .498 .194 .250 2.563 .012
Dlarge .079 .215 .033 .370 .713
2 (Constant) -.374 .146
-2.566 .012
Zscore(Cylinders) -.090 .146 -.090 -.619 .537
Zscore(Engine) -.241 .246 -.240 -.981 .329
Dsmall .390 .182 .195 2.140 .035
Dlarge -.339 .265 -.140 -1.276 .205
engXdsmall -.655 .225 -.392 -2.915 .005
engXdlarge .222 .255 .129 .871 .386
a Dependent Variable: Zscore(CityMpg)

Excluded Variables(b)
Model
Beta In t Sig. Partial Correlation Collinearity Statistics
Tolerance
1 engXdsmall -.468(a) -4.584 .000 -.443 .378
engXdlarge .409(a) 3.486 .001 .352 .312
a Predictors in the Model: (Constant), Dlarge, Zscore(Cylinders), Dsmall, Zscore(Engine)
b Dependent Variable: Zscore(CityMpg)

GRAPH
  /HISTOGRAM(NORMAL)=RES_1 .

Graph

Notes
Output Created 07-DEC-2007 17:30:12
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Syntax GRAPH
/HISTOGRAM(NORMAL)=RES_1 .
Resources Elapsed Time 0:00:00.25

Histogram of RES_1 

PPLOT
  /VARIABLES=RES_1
  /NOLOG
  /NOSTANDARDIZE
  /TYPE=Q-Q
  /FRACTION=BLOM
  /TIES=MEAN
  /DIST=NORMAL.

PPlot

Notes
Output Created 07-DEC-2007 17:30:12
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Date <none>
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used For a given sequence or time series variable, cases with missing values are not used in the analysis. Cases with negative or zero values are also not used, if the log transform is requested.
Syntax PPLOT
/VARIABLES=RES_1
/NOLOG
/NOSTANDARDIZE
/TYPE=Q-Q
/FRACTION=BLOM
/TIES=MEAN
/DIST=NORMAL.
Resources Elapsed Time 0:00:00.52
Use From First observation
To Last observation
Time Series Settings (TSET) Amount of Output PRINT = DEFAULT
Saving New Variables NEWVAR = CURRENT
Maximum Number of Lags in Autocorrelation or Partial Autocorrelation Plots MXAUTO = 16
Maximum Number of Lags Per Cross-Correlation Plots MXCROSS = 7
Maximum Number of New Variables Generated Per Procedure MXNEWVAR = 60
Maximum Number of New Cases Per Procedure MXPREDICT = 1000
Treatment of User-Missing Values MISSING = EXCLUDE
Confidence Interval Percentage Value CIN = 95
Tolerance for Entering Variables in Regression Equations TOLER = .0001
Maximum Iterative Parameter Change CNVERGE = .001
Method of Calculating Std. Errors for Autocorrelations ACFSE = IND
Length of Seasonal Period Unspecified
Variable Whose Values Label Observations in Plots Unspecified
Equations Include CONSTANT

Model Description
Model Name MOD_2
Series or Sequence 1 Unstandardized Residual
Transformation None
Non-Seasonal Differencing 0
Seasonal Differencing 0
Length of Seasonal Period No periodicity
Standardization Not applied
Distribution Type Normal
Location estimated
Scale estimated
Fractional Rank Estimation Method Blom's
Rank Assigned to Ties Mean rank of tied values
Applying the model specifications from MOD_2

Case Processing Summary


Unstandardized Residual
Series or Sequence Length 93
Number of Missing Values in the Plot User-Missing 0
System-Missing 1
The cases are unweighted.

Estimated Distribution Parameters


Unstandardized Residual
Normal Distribution Location .0000000
Scale .57997049
The cases are unweighted.

Unstandardized Residual

Normal Q-Q Plot of Unstandardized Residual

Detrended Normal Q-Q Plot of Unstandardized Residual 

GRAPH
  /SCATTERPLOT(BIVAR)=ZCylinders WITH RES_1
  /MISSING=LISTWISE .

Graph

Notes
Output Created 07-DEC-2007 17:30:12
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Syntax GRAPH
/SCATTERPLOT(BIVAR)=ZCylinders WITH RES_1
/MISSING=LISTWISE .
Resources Elapsed Time 0:00:00.30

Scatter of RES_1 ZCylinders 

GRAPH
  /SCATTERPLOT(BIVAR)=ZEngine WITH RES_1
  /MISSING=LISTWISE .

Graph

Notes
Output Created 07-DEC-2007 17:30:13
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Syntax GRAPH
/SCATTERPLOT(BIVAR)=ZEngine WITH RES_1
/MISSING=LISTWISE .
Resources Elapsed Time 0:00:00.25

Scatter of RES_1 ZEngine 

RECODE
  Size
  ('Small'=1) ('Compact'=1) ('Sporty'=1) ('Midsize'=2) ('Large'=3) ('Van'=3) (MI
   SSING=SYSMIS)  (ELSE=0)  INTO  Size3groups .
EXECUTE .

GRAPH
  /SCATTERPLOT(BIVAR)=Size3groups WITH RES_1
  /MISSING=LISTWISE .

Graph

Notes
Output Created 07-DEC-2007 17:30:13
Comments
Input Data C:\Classes\00 Data Sets\CARS.sav
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 93
Syntax GRAPH
/SCATTERPLOT(BIVAR)=Size3groups WITH RES_1
/MISSING=LISTWISE .
Resources Elapsed Time 0:00:00.27

Scatter of RES_1 Size3groups