Scribd
Upload
5 views4 pages

Binning and Frequency Analysis of VAR00002

This document contains code to bin a variable called VAR00002 into groups. It recodes the values of VAR00002 into a new binned variable called VAR00002_GROUPS. It then runs frequency statistics on VAR00002_GROUPS to show the mean, median and mode of the binned variable. It also displays the frequency and percentage of cases in each bin.

Uploaded by

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

Binning and Frequency Analysis of VAR00002

This document contains code to bin a variable called VAR00002 into groups. It recodes the values of VAR00002 into a new binned variable called VAR00002_GROUPS. It then runs frequency statistics on VAR00002_GROUPS to show the mean, median and mode of the binned variable. It also displays the frequency and percentage of cases in each bin.

Uploaded by

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

* Visual Binning. *VAR00002.

RECODE VAR00002 (MISSING=COPY) (91 THRU HI=6)


(87 THRU HI=5) (83 THRU HI=4) (79 THRU HI=3) (75 THRU HI=2) (LO THRU HI=1)
(ELSE=SYSM IS) INTO VAR00002_GROUPS. VARIABLE LABELS VAR00002_GROUPS
'VAR00002 (Binned)'. FORMAT VAR00002_GROUPS (F5.0). VALUE LABELS
VAR00002_GROUPS 1 ' 75.00' 2 '75.00 - 78.00' 3 '79.00 - 82.00' 4 '83.00 -
86.00' 5 '87.00 - 90.00' 6 '91.00+'. MISSING VALUES VAR00002_GROUPS ( ).
VARIABLE LEVEL VAR00002_GROUPS (ORDINAL). EXECUTE. FREQUENCIES
VARIABLES=VAR00002_GROUPS /STATISTICS=MEAN MEDIAN MODE /FORMAT=DVALUE
/ORDER=ANALYSIS.

Frequencies

Notes

Output Created 26-Oct-2017 14:10:27

Comments

Input Active Dataset DataSet0

Filter <none>

Weight <none>

Split File <none>

N of Rows in Working Data 60


File

Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.

Cases Used Statistics are based on all cases with


valid data.

Syntax FREQUENCIES
VARIABLES=VAR00002_GROUPS
/STATISTICS=MEAN MEDIAN MODE
/FORMAT=DVALUE
/ORDER=ANALYSIS.

Resources Processor Time 0:00:00.000

Elapsed Time 0:00:00.000

[DataSet0]
Statistics

VAR00002 (Binned)

N Valid 60

Missing 0

Mean 4.08

Median 4.00

Mode 4

VAR00002 (Binned)

Cumulative
Frequency Percent Valid Percent Percent

Valid 91.00+ 9 15.0 15.0 15.0

87.00 - 90.00 12 20.0 20.0 35.0

83.00 - 86.00 19 31.7 31.7 66.7

79.00 - 82.00 15 25.0 25.0 91.7

75.00 - 78.00 5 8.3 8.3 100.0

Total 60 100.0 100.0

FREQUENCIES VARIABLES=VAR00002 /STATISTICS=MEAN MEDIAN MODE


/FORMAT=DVALUE /ORDER=ANALYSIS.

Frequencies
Notes

Output Created 26-Oct-2017 14:10:47

Comments

Input Active Dataset DataSet0

Filter <none>

Weight <none>

Split File <none>

N of Rows in Working Data 60


File

Missing Value Handling Definition of Missing User-defined missing values are treated
as missing.

Cases Used Statistics are based on all cases with


valid data.

Syntax FREQUENCIES
VARIABLES=VAR00002
/STATISTICS=MEAN MEDIAN MODE
/FORMAT=DVALUE
/ORDER=ANALYSIS.

Resources Processor Time 0:00:00.000

Elapsed Time 0:00:00.000

[DataSet0]

Statistics

VAR00002

N Valid 60

Missing 0

Mean 84.9000

Median 85.0000

Mode 85.00a

a. Multiple modes exist. The


smallest value is shown
VAR00002

Cumulative
Frequency Percent Valid Percent Percent

Valid 94.00 1 1.7 1.7 1.7

93.00 6 10.0 10.0 11.7

91.00 2 3.3 3.3 15.0

90.00 2 3.3 3.3 18.3

89.00 3 5.0 5.0 23.3

88.00 2 3.3 3.3 26.7

87.00 5 8.3 8.3 35.0

86.00 4 6.7 6.7 41.7

85.00 7 11.7 11.7 53.3

84.00 7 11.7 11.7 65.0

83.00 1 1.7 1.7 66.7

82.00 4 6.7 6.7 73.3

81.00 4 6.7 6.7 80.0

80.00 5 8.3 8.3 88.3

79.00 2 3.3 3.3 91.7

78.00 1 1.7 1.7 93.3

77.00 1 1.7 1.7 95.0

76.00 2 3.3 3.3 98.3

75.00 1 1.7 1.7 100.0

Total 60 100.0 100.0

You might also like