Warning # 849 in column 23.

Text: in_ID
The LOCALE subcommand of the SET command has an invalid parameter. It could
not be mapped to a valid backend locale.

GET DATA
/TYPE=XLSX
/FILE='D:\COURSE WORK\SEMESTER 6\STATISTIK\tugas data visualization prodi
TBI.xlsx'
/SHEET=name 'Sheet2'
/CELLRANGE=FULL
/READNAMES=ON
/DATATYPEMIN PERCENTAGE=95.0
/HIDDEN IGNORE=YES.
EXECUTE.
DATASET NAME DataSet1 WINDOW=FRONT.
FREQUENCIES VARIABLES=Jeniskelamin
/PIECHART FREQ
/ORDER=ANALYSIS.

Frequencies

Notes
Output Created 13-MAR-2021 13:37:26
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 135
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=Jeniskelamin
/PIECHART FREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:00,77
Elapsed Time 00:00:00,39

[DataSet1]

Statistics
Jenis kelamin
N Valid 135
Missing 0

Jenis kelamin
Cumulative
Frequency Percent Valid Percent Percent
Valid Laki-laki 44 32,6 32,6 32,6
Perempuan 91 67,4 67,4 100,0
Total 135 100,0 100,0
FREQUENCIES VARIABLES=DurasiBelajar
/BARCHART FREQ
/ORDER=ANALYSIS.

Frequencies

Notes
Output Created 13-MAR-2021 13:38:16
Comments
Input Active Dataset DataSet1
 Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 135
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=DurasiBelajar
/BARCHART FREQ
/ORDER=ANALYSIS.
Resources Processor Time 00:00:00,34
Elapsed Time 00:00:00,43

Statistics
Durasi Belajar
N Valid 135
Missing 0

Durasi Belajar
Cumulative
Frequency Percent Valid Percent Percent
Valid > 2 jam/hari 16 11,9 11,9 11,9
0-2 jam/hari 55 40,7 40,7 52,6
Tidak pernah 64 47,4 47,4 100,0
Total 135 100,0 100,0
FREQUENCIES VARIABLES=IPK
/HISTOGRAM
/ORDER=ANALYSIS.

Frequencies

Notes
Output Created 13-MAR-2021 13:38:51
Comments
Input Active Dataset DataSet1
 Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 135
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=IPK
/HISTOGRAM
/ORDER=ANALYSIS.
Resources Processor Time 00:00:00,42
Elapsed Time 00:00:00,39

Statistics
IPK
N Valid 135
Missing 0

IPK
Cumulative
Frequency Percent Valid Percent Percent
Valid 2,75 3 2,2 2,2 2,2
2,76 1 ,7 ,7 3,0
2,77 3 2,2 2,2 5,2
2,78 3 2,2 2,2 7,4
2,79 4 3,0 3,0 10,4
2,81 3 2,2 2,2 12,6
2,82 2 1,5 1,5 14,1
2,84 3 2,2 2,2 16,3
2,85 1 ,7 ,7 17,0
2,86 1 ,7 ,7 17,8
2,87 2 1,5 1,5 19,3
2,88 1 ,7 ,7 20,0
2,89 4 3,0 3,0 23,0
2,90 1 ,7 ,7 23,7
2,91 2 1,5 1,5 25,2
2,92 3 2,2 2,2 27,4
2,93 3 2,2 2,2 29,6
2,94 1 ,7 ,7 30,4
2,95 2 1,5 1,5 31,9
2,96 4 3,0 3,0 34,8
2,97 2 1,5 1,5 36,3
2,98 4 3,0 3,0 39,3
2,99 1 ,7 ,7 40,0
3,00 4 3,0 3,0 43,0
3,01 4 3,0 3,0 45,9
3,02 4 3,0 3,0 48,9
3,03 1 ,7 ,7 49,6
3,04 3 2,2 2,2 51,9
3,05 1 ,7 ,7 52,6
3,06 3 2,2 2,2 54,8
3,07 1 ,7 ,7 55,6
3,08 1 ,7 ,7 56,3
3,09 2 1,5 1,5 57,8
3,10 2 1,5 1,5 59,3
3,11 3 2,2 2,2 61,5
3,12 3 2,2 2,2 63,7
3,13 2 1,5 1,5 65,2
3,15 3 2,2 2,2 67,4
3,16 3 2,2 2,2 69,6
3,17 2 1,5 1,5 71,1
3,18 3 2,2 2,2 73,3
3,19 4 3,0 3,0 76,3
3,20 2 1,5 1,5 77,8
3,21 1 ,7 ,7 78,5
3,23 4 3,0 3,0 81,5
3,24 1 ,7 ,7 82,2
3,27 2 1,5 1,5 83,7
3,30 2 1,5 1,5 85,2
3,31 2 1,5 1,5 86,7
3,32 1 ,7 ,7 87,4
3,33 1 ,7 ,7 88,1
3,34 1 ,7 ,7 88,9
3,35 1 ,7 ,7 89,6
3,38 1 ,7 ,7 90,4
3,44 2 1,5 1,5 91,9
3,46 1 ,7 ,7 92,6
3,47 2 1,5 1,5 94,1
3,48 1 ,7 ,7 94,8
3,50 1 ,7 ,7 95,6
3,51 1 ,7 ,7 96,3
3,55 1 ,7 ,7 97,0
3,56 1 ,7 ,7 97,8
3,59 1 ,7 ,7 98,5
3,60 1 ,7 ,7 99,3
3,63 1 ,7 ,7 100,0
Total 135 100,0 100,0
EXAMINE VARIABLES=IPK BY Jeniskelamin
/PLOT BOXPLOT STEMLEAF
/COMPARE GROUPS
/STATISTICS DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.

Explore

Notes
Output Created 13-MAR-2021 13:39:14
Comments
Input Active Dataset DataSet1
Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data 135
File
Missing Value Handling Definition of Missing User-defined missing values
for dependent variables are
treated as missing.
Cases Used Statistics are based on cases
with no missing values for
any dependent variable or
factor used.
Syntax EXAMINE VARIABLES=IPK
BY Jeniskelamin
/PLOT BOXPLOT
STEMLEAF
/COMPARE GROUPS
/STATISTICS
DESCRIPTIVES
/CINTERVAL 95
/MISSING LISTWISE
/NOTOTAL.
Resources Processor Time 00:00:00,31
Elapsed Time 00:00:00,25

Warnings
Text: Jeniskelamin Command: EXAMINE
This procedure cannot use string variables longer than 8 bytes. The
values will be truncated.

Jenis kelamin
 Case Processing Summary
Cases
Jenis kelamin Valid Missing Total
N Percent N Percent N Percent
IPK Laki-lak 44 100,0% 0 0,0% 44 100,0%
Perempua 91 100,0% 0 0,0% 91 100,0%

Descriptives
Jenis kelamin Statistic Std. Error
IPK Laki-lak Mean 3,0575 ,03200
95% Confidence Interval for Lower Bound 2,9930
Mean Upper Bound 3,1220
5% Trimmed Mean 3,0442
Median 3,0200
Variance ,045
Std. Deviation ,21225
Minimum 2,75
Maximum 3,63
Range ,88
Interquartile Range ,28
Skewness ,908 ,357
Kurtosis ,633 ,702
Perempua Mean 3,0777 ,02263
95% Confidence Interval for Lower Bound 3,0327
Mean Upper Bound 3,1226
5% Trimmed Mean 3,0693
Median 3,0500
Variance ,047
Std. Deviation ,21586
Minimum 2,75
Maximum 3,60
Range ,85
Interquartile Range ,28
Skewness ,504 ,253
 Kurtosis -,409 ,500

IPK

Stem-and-Leaf Plots

IPK Stem-and-Leaf Plot for

Frequency Stem & Leaf

3,00 27 . 558
8,00 28 . 11445799
8,00 29 . 24566678
10,00 30 . 0122246667
5,00 31 . 05588
4,00 32 . 3377
3,00 33 . 015
,00 34 .
2,00 35 . 19
1,00 Extremes (>=3,63)

Stem width: ,10

IPK Stem-and-Leaf Plot for

Frequency Stem & Leaf

11,00 27 . 56777889999
9,00 28 . 122467899
15,00 29 . 011223335678889
14,00 30 . 00011123445899
20,00 31 . 01112223356667789999
6,00 32 . 001334
6,00 33 . 012348
6,00 34 . 446778
3,00 35 . 056
 1,00 36 . 0

Stem width: ,10