0% found this document useful (0 votes)
5 views13 pages

Descriptive Statistics Analysis Report

The document provides the results of descriptive statistical analyses performed on variables from a dataset named DataSet1. The analyses included calculating measures such as mean, standard deviation, variance, range, minimum, and maximum for variables like educational level, weight, height, age, smoking status, physical activity, blood glucose levels, cholesterol levels, blood pressure, and body mass index. The results showed the distribution of values for each variable across 100 observations in the dataset.

Uploaded by

erin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views13 pages

Descriptive Statistics Analysis Report

The document provides the results of descriptive statistical analyses performed on variables from a dataset named DataSet1. The analyses included calculating measures such as mean, standard deviation, variance, range, minimum, and maximum for variables like educational level, weight, height, age, smoking status, physical activity, blood glucose levels, cholesterol levels, blood pressure, and body mass index. The results showed the distribution of values for each variable across 100 observations in the dataset.

Uploaded by

erin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd

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

You might also like