* Label Housing.sps Peter Schmidt, 14.11.2010. * Here the data (from XL) are labeled. * Variable Label = Name of the Variable itself. * Value Label = Name of a specific Items (see below). *** Import data from Excel *** GET DATA /TYPE=XLS /FILE='XXXXX' /SHEET=name 'HPRICE' /CELLRANGE=range 'A8:M554' /READNAMES=on. *DATASET NAME HousingData WINDOW=FRONT. * Variable Label = Name of the Variable itself. variable labels y 'sale price'. variable labels x_1 'lot size'. variable labels x_2 '#bedroom'. variable labels x_3 '#bath'. variable labels x_4 '#stories'. variable labels x_5 'driveway'. variable labels x_6 'rec room'. variable labels x_7 'basement'. variable labels x_8 'gas'. variable labels x_9 'air cond'. variable labels x_10 '#garage'. variable labels x_11 'desired location'. * Value Label = Name of a specific Items (see below). value labels x_5 1 'yes' 0 'no'. value labels x_6 1 'yes' 0 'no'. value labels x_7 1 'yes' 0 'no'. value labels x_8 1 'yes' 0 'no'. value labels x_9 1 'yes' 0 'no'. value labels x_11 1 'yes' 0 'no'. * Some (descriptive) Data analysis: * Descriptive Statistics: DESCRIPTIVES all. *or in short form. desc all. FREQUENCIES x_2, x_3, x_4, x_5, x_6, x_7, x_8, x_9, x_10, x_11. * Correlation (of metric variables) ---------------------- . CORRELATIONS /VARIABLES=y x_1 x_2 x_3 x_4 x_10 /PRINT=TWOTAIL NOSIG /MISSING=PAIRWISE. * Regressions ---------------------- . * Syntax produced automatically. REGRESSION /MISSING LISTWISE /STATISTICS COEFF OUTS R ANOVA /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT y /METHOD=ENTER x_1 x_2 . * Different SPECIFICATIONS: * simple regression on lot size. REGRESSION /DEP y /METHOD=ENTER x_1. * Multiple regressions. REGRESSION /DEP y /METHOD=ENTER x_1 x_2 x_3 x_4 x_5 . * Dummy variables. REGRESSION /DEP y /METHOD=ENTER x_5 x_6 x_7 x_8 x_9 x_11. REGRESSION /DEP y /METHOD=ENTER x_1 x_2 x_3 x_4 x_5 x_6 x_7 x_8. REGRESSION /DEP y /METHOD=ENTER x_1 x_2 x_3 x_4 x_5 x_6 x_7 x_8 x_9 x_10 x_11.