GET DATA /TYPE=XLSX
/FILE='H:\DELARA_ERIN.xlsx'
/SHEET=name 'original'
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
EXECUTE.
DATASET NAME DataSet1 WINDOW=FRONT.
DESCRIPTIVES VARIABLES=ID EducationalLevel Weightkg Heightcm Ageyrsold
SmokingStatus PhysicalActivityatHome BloodGlucose SerumCholesterol
SystolicBloodPressure BodyMassIndexBMI
/STATISTICS=MEAN STDDEV VARIANCE RANGE MIN MAX SEMEAN KURTOSIS SKEWNESS.
Descriptives
Notes
Output Created 24-AUG-2017 10:04:10
Comments
Active Dataset DataSet1
Filter <none>
Weight <none>
Input
Split File <none>
N of Rows in Working Data
100
File
User defined missing values
Definition of Missing
are treated as missing.
Missing Value Handling
All non-missing data are
Cases Used
used.
DESCRIPTIVES
VARIABLES=ID
EducationalLevel Weightkg
Heightcm Ageyrsold
SmokingStatus
PhysicalActivityatHome
BloodGlucose
Syntax
SerumCholesterol
SystolicBloodPressure
BodyMassIndexBMI
/STATISTICS=MEAN
STDDEV VARIANCE
RANGE MIN MAX SEMEAN
KURTOSIS SKEWNESS.
Processor Time 00:00:00.00
Resources
Elapsed Time 00:00:00.00
[DataSet1]
Descriptive Statistics
N Range Minimum Maximum Mean
Statistic Statistic Statistic Statistic Statistic Std. Error
ID 100 99 1 100 50.50 2.901
Educational Level 100 4 1 5 2.47 .124
Weight (kg) 100 44 47 91 64.22 .861
Height (cm) 100 58 117 175 161.22 .711
Age (yrs old) 100 21 46 67 53.67 .510
Smoking Status 100 1 0 1 .37 .049
Physical Activity at Home 100 1 1 2 1.51 .050
Blood Glucose 100 384 58 442 152.14 5.476
Serum Cholesterol 100 248 134 382 217.05 3.880
Systolic Blood Pressure 100 116 92 208 130.20 2.128
Body Mass Index (BMI) 100 16 18 34 24.56 .308
Valid N (listwise) 100
Descriptive Statistics
Std. Deviation Variance Skewness Kurtosis
Statistic Statistic Statistic Std. Error Statistic Std. Error
ID 29.011 841.667 .000 .241 -1.200 .478
Educational Level 1.243 1.545 .618 .241 -.487 .478
Weight (kg) 8.610 74.133 .561 .241 .218 .478
Height (cm) 7.112 50.577 -2.309 .241 13.932 .478
Age (yrs old) 5.101 26.021 .927 .241 .050 .478
Smoking Status .485 .235 .547 .241 -1.736 .478
Physical Activity at Home .502 .252 -.041 .241 -2.040 .478
Blood Glucose 54.756 2998.202 1.815 .241 7.010 .478
Serum Cholesterol 38.796 1505.159 .930 .241 2.302 .478
Systolic Blood Pressure 21.277 452.727 .868 .241 1.275 .478
Body Mass Index (BMI) 3.076 9.461 .349 .241 .175 .478
Valid N (listwise)
DESCRIPTIVES VARIABLES=EducationalLevel Weightkg Heightcm Ageyrsold
SmokingStatus PhysicalActivityatHome BloodGlucose SerumCholesterol
SystolicBloodPressure BodyMassIndexBMI
/STATISTICS=MEAN STDDEV VARIANCE RANGE MIN MAX KURTOSIS SKEWNESS.
Descriptives
Notes
Output Created 24-AUG-2017 10:07:51
Comments
Active Dataset DataSet1
Filter <none>
Weight <none>
Input
Split File <none>
N of Rows in Working Data
100
File
User defined missing values
Definition of Missing
are treated as missing.
Missing Value Handling
All non-missing data are
Cases Used
used.
DESCRIPTIVES
VARIABLES=EducationalLev
el Weightkg Heightcm
Ageyrsold SmokingStatus
PhysicalActivityatHome
BloodGlucose
Syntax SerumCholesterol
SystolicBloodPressure
BodyMassIndexBMI
/STATISTICS=MEAN
STDDEV VARIANCE
RANGE MIN MAX
KURTOSIS SKEWNESS.
Processor Time 00:00:00.02
Resources
Elapsed Time 00:00:00.00
[DataSet1]
Descriptive Statistics
N Range Minimum Maximum Mean Std. Deviation
Statistic Statistic Statistic Statistic Statistic Statistic
Educational Level 100 4 1 5 2.47 1.243
Weight (kg) 100 44 47 91 64.22 8.610
Height (cm) 100 58 117 175 161.22 7.112
Age (yrs old) 100 21 46 67 53.67 5.101
Smoking Status 100 1 0 1 .37 .485
Physical Activity at Home 100 1 1 2 1.51 .502
Blood Glucose 100 384 58 442 152.14 54.756
Serum Cholesterol 100 248 134 382 217.05 38.796
Systolic Blood Pressure 100 116 92 208 130.20 21.277
Body Mass Index (BMI) 100 16 18 34 24.56 3.076
Valid N (listwise) 100
Descriptive Statistics
Variance Skewness Kurtosis
Statistic Statistic Std. Error Statistic Std. Error
Educational Level 1.545 .618 .241 -.487 .478
Weight (kg) 74.133 .561 .241 .218 .478
Height (cm) 50.577 -2.309 .241 13.932 .478
Age (yrs old) 26.021 .927 .241 .050 .478
Smoking Status .235 .547 .241 -1.736 .478
Physical Activity at Home .252 -.041 .241 -2.040 .478
Blood Glucose 2998.202 1.815 .241 7.010 .478
Serum Cholesterol 1505.159 .930 .241 2.302 .478
Systolic Blood Pressure 452.727 .868 .241 1.275 .478
Body Mass Index (BMI) 9.461 .349 .241 .175 .478
Valid N (listwise)
SAVE OUTFILE='H:\DELARA_DESCRIPTIVE.sav'
/COMPRESSED.
CROSSTABS
/TABLES=PhysicalActivityatHome EducationalLevel BodyMassIndexBMI BY
SmokingStatus
/FORMAT=AVALUE TABLES
/CELLS=COUNT
/COUNT ROUND CELL
/BARCHART.
Crosstabs
Notes
Output Created 24-AUG-2017 10:25:59
Comments
H:\DELARA_DESCRIPTIVE.
Data
sav
Active Dataset DataSet1
Filter <none>
Input
Weight <none>
Split File <none>
N of Rows in Working Data
100
File
User-defined missing values
Definition of Missing
are treated as missing.
Statistics for each table are
Missing Value Handling based on all the cases with
Cases Used valid data in the specified
range(s) for all variables in
each table.
CROSSTABS
/TABLES=PhysicalActivityatH
ome EducationalLevel
BodyMassIndexBMI BY
Syntax SmokingStatus
/FORMAT=AVALUE
TABLES
/CELLS=COUNT
/COUNT ROUND CELL
/BARCHART.
Processor Time 00:00:00.61
Elapsed Time 00:00:00.63
Resources
Dimensions Requested 2
Cells Available 174762
[DataSet1] H:\DELARA_DESCRIPTIVE.sav
Case Processing Summary
Cases
Valid Missing Total
N Percent N Percent N Percent
Physical Activity at Home *
100 100.0% 0 0.0% 100 100.0%
Smoking Status
Educational Level * Smoking
100 100.0% 0 0.0% 100 100.0%
Status
Body Mass Index (BMI) *
100 100.0% 0 0.0% 100 100.0%
Smoking Status
Physical Activity at Home * Smoking Status Crosstabulation
Count
Smoking Status Total
non smoking smoking
mostly sitting 31 18 49
Physical Activity at Home
moderate 32 19 51
Total 63 37 100
Educational Level * Smoking Status Crosstabulation
Count
Smoking Status Total
non smoking smoking
1 16 9 25
2 17 15 32
Educational Level 3 12 12 24
4 8 1 9
5 10 0 10
Total 63 37 100
Body Mass Index (BMI) * Smoking Status Crosstabulation
Count
Smoking Status Total
non smoking smoking
18 1 1 2
19 0 2 2
20 3 1 4
21 2 5 7
22 8 1 9
23 12 5 17
Body Mass Index (BMI)
24 5 6 11
25 8 3 11
26 9 4 13
27 3 3 6
28 6 2 8
29 3 1 4
30 0 3 3
31 1 0 1
32 1 0 1
34 1 0 1
Total 63 37 100
* Visual Binning.
*Ageyrsold.
RECODE Ageyrsold (MISSING=COPY) (LO THRU 46=1) (LO THRU 49=2) (LO THRU
52=3) (LO THRU 55=4) (LO THRU 58=5) (LO THRU 61=6) (LO THRU 64=7) (LO THRU
67=8) (LO THRU HI=9) (ELSE=SYSMIS) INTO agebinned.
VARIABLE LABELS agebinned 'Age (yrs old) (Binned)'.
FORMATS agebinned (F5.0).
VALUE LABELS agebinned 1 '<= 46' 2 '47 - 49' 3 '50 - 52' 4 '53 - 55' 5 '56
- 58' 6 '59 - 61' 7 '62 - 64' 8 '65 - 67' 9 '68+'.
VARIABLE LEVEL agebinned (ORDINAL).
*Heightcm.
RECODE Heightcm (MISSING=COPY) (LO THRU 117=13) (LO THRU 122=12) (LO THRU
127=11) (LO THRU 132=10) (LO THRU 137=9) (LO THRU 142=8) (LO THRU 147=7)
(LO THRU 152=6) (LO THRU 157=5) (LO THRU 162=4) (LO THRU 167=3) (LO THRU
172=2) (LO THRU HI=1)
(ELSE=SYSMIS) INTO heightbinned.
VARIABLE LABELS heightbinned 'Height (cm) (Binned)'.
FORMATS heightbinned (F5.0).
VALUE LABELS heightbinned 13 '<= 117' 12 '118 - 122' 11 '123 - 127' 10
'128 - 132' 9 '133 - 137' 8 '138 - 142' 7 '143 - 147' 6 '148 - 152' 5 '153
- 157' 4 '158 - 162' 3 '163 - 167' 2 '168 - 172' 1 '173+'.
VARIABLE LEVEL heightbinned (ORDINAL).
EXECUTE.
FREQUENCIES VARIABLES=agebinned heightbinned
/HISTOGRAM NORMAL
/ORDER=ANALYSIS.
Frequencies
Notes
Output Created 24-AUG-2017 11:01:03
Comments
H:\DELARA_DESCRIPTIVE.
Data
sav
Active Dataset DataSet1
Filter <none>
Input
Weight <none>
Split File <none>
N of Rows in Working Data
100
File
User-defined missing values
Definition of Missing
are treated as missing.
Missing Value Handling
Statistics are based on all
Cases Used
cases with valid data.
FREQUENCIES
VARIABLES=agebinned
Syntax heightbinned
/HISTOGRAM NORMAL
/ORDER=ANALYSIS.
Processor Time 00:00:00.23
Resources
Elapsed Time 00:00:00.21
[DataSet1] H:\DELARA_DESCRIPTIVE.sav
Statistics
Age (yrs old) Height (cm)
(Binned) (Binned)
Valid 100 100
N
Missing 0 0
Frequency Table
Age (yrs old) (Binned)
Frequency Percent Valid Percent Cumulative
Percent
<= 46 1 1.0 1.0 1.0
47 - 49 21 21.0 21.0 22.0
50 - 52 28 28.0 28.0 50.0
53 - 55 23 23.0 23.0 73.0
Valid 56 - 58 8 8.0 8.0 81.0
59 - 61 6 6.0 6.0 87.0
62 - 64 8 8.0 8.0 95.0
65 - 67 5 5.0 5.0 100.0
Total 100 100.0 100.0
Height (cm) (Binned)
Frequency Percent Valid Percent Cumulative
Percent
173+ 2 2.0 2.0 2.0
168 - 172 12 12.0 12.0 14.0
163 - 167 26 26.0 26.0 40.0
158 - 162 33 33.0 33.0 73.0
Valid
153 - 157 19 19.0 19.0 92.0
148 - 152 7 7.0 7.0 99.0
<= 117 1 1.0 1.0 100.0
Total 100 100.0 100.0
Histogram