Uji Dengan Excel
Uji Dengan Excel
Uji Dengan Excel
2 43 61
2 51 73
2 52 74
2 43 61
4 49 70
2 55 79
2 34 49
2 34 49
2 46 66
2 48 69
2 48 69
2 49 70
2 48 69
2 41 59
2 45 64
2 46 66
2 45 64
2 55 79
2 49 70
2 59 84
No Nama
1 2 3 4 5 6 7
1 Aqila 1 0 0 0 1 0 1
2 Hila 1 0 1 1 1 1 1
3 Alena 0 1 0 1 1 1 1
4 Alzia 1 1 1 0 1 1 1
5 Nuansa 1 1 1 1 1 1 1
6 Syifa 0 1 1 1 1 1 1
7 Gunawan 1 1 1 1 1 1 0
8 Sigit 1 1 0 0 0 0 1
9 Khanza 1 1 1 1 1 1 1
10 Anastasya 0 1 1 1 1 0 1
11 Wiwi 1 1 1 0 1 1 1
12 Diwa 1 1 1 1 1 0 1
13 Dinda 1 1 0 0 1 1 0
14 Indra 1 1 0 0 1 1 1
15 Faiz 1 1 0 0 1 1 0
16 Inaya 1 1 0 0 1 1 1
17 Ade Nuri 1 1 0 1 1 1 1
18 Sania 1 1 0 0 1 1 0
19 Rodiah 0 1 1 0 1 1 1
20 Nisa 1 1 1 0 1 1 0
r Hitung -0.09549 -0.20291 0.02519 0.26272 0.408 0.2029 0.03446
r Tabel 0.444 0.444 0.444 0.444 0.444 0.444 0.444
V/T T T T T T T T
8 9 10 11 12 13 14 15 16 17
1 1 0 1 1 0 1 1 1 0
1 1 1 1 1 1 1 1 1 1
0 1 0 1 1 0 1 1 1 1
0 1 1 1 1 0 1 1 1 0
1 1 1 1 1 1 1 1 1 0
1 1 1 1 1 1 1 1 1 1
0 1 0 0 1 0 1 1 1 0
1 0 0 1 1 0 1 1 1 0
1 1 0 1 1 0 1 1 1 0
1 1 0 1 1 0 1 1 1 0
1 1 0 1 1 0 1 1 1 0
1 1 0 1 1 0 1 1 1 0
1 1 0 1 1 0 1 1 0 1
1 1 0 1 1 0 1 1 1 0
1 1 0 1 1 0 1 1 1 1
1 1 0 1 1 1 1 1 0 1
1 1 0 1 1 1 1 1 1 1
1 1 1 0 0 1 0 1 1 1
1 1 1 1 0 0 0 0 0 1
1 1 1 1 1 0 1 1 1 0
0.212266 0.408 0.29654 0.3143 0.195 0.4506 0.195 0.2985 -0.022 0.35869
0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444
T T T T T V T T T T
Butir-butit soal pilihan ganda yang valid y 13, 22, 24, 32, 37,38, 40 (7 soal)
kategori :
Cukup : 13, 22, 24, 37, 38 dan 40
Tinggi : 32
Butir-butit soal essay yang valid yaitu nomor : 41, 42, 43, 44 (4 soal)
kategori :
Cukup : 44
Tinggi : 42
Sangat tinggi: 41 dan 43
Nomor soal
18 19 20 21 22 23 24 25 26 27
1 1 1 0 1 0 1 0 1 0
1 1 1 1 1 1 1 1 1 0
1 0 0 1 1 1 1 1 1 1
1 0 1 1 1 1 1 0 0 1
1 1 0 1 1 1 1 0 0 1
1 1 1 0 1 0 1 1 1 1
1 0 0 0 0 0 1 0 0 1
1 1 0 1 1 0 0 0 0 0
1 0 1 0 0 0 0 1 1 1
1 1 1 0 1 0 0 1 1 1
1 1 1 0 1 0 1 1 1 1
1 0 0 0 1 0 1 1 1 1
1 0 1 1 1 1 1 1 1 1
1 0 1 0 0 1 0 1 1 1
1 1 0 0 0 1 0 1 1 1
1 0 0 0 0 0 1 1 0 1
1 0 0 0 0 0 1 1 1 1
1 1 1 1 1 0 0 1 1 1
0 0 0 0 0 0 0 1 1 1
1 0 1 1 1 0 1 1 0 1
0.29848 0.02279 0.36109 0.35085 0.50425 0.24649 0.5543 0.42037 0.2787 0.0786
0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444
T T T T V T V T T T
0 (7 soal)
28 29 30 31 32 33 34 35 36
0 0 0 1 1 1 1 1 1
0 0 0 1 1 1 0 0 1
1 1 1 1 1 0 1 0 1
0 0 0 1 1 0 0 1 1
0 0 0 1 1 1 1 0 1
1 1 0 0 1 0 1 0 1
0 0 0 1 0 1 1 0 1
0 1 0 1 0 1 1 0 1
0 1 0 0 1 0 1 0 0
0 1 0 0 1 0 1 0 1
0 0 0 1 1 0 1 0 0
0 1 1 1 1 0 1 0 1
1 1 1 1 1 1 1 1 1
1 0 0 1 1 0 1 0 1
0 0 0 1 1 1 1 0 0
0 1 0 1 1 1 1 1 1
0 0 1 1 1 1 1 1 1
0 1 1 1 1 0 1 0 1
0 1 1 1 1 0 1 0 1
0 1 1 1 1 0 1 1 1
0.3939 0.1452 0.371619 -0.0886 0.63261 -0.07318 -0.16313 0.32037 0.245694
0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444 0.444
T T T T V T T T T
Skor Total
37 38 39 40 41 42 43
1 1 1 1 26 4 3 4
1 1 0 1 32 4 3 6
1 0 1 1 30 8 4 4
0 0 0 1 25 4 4 4
1 0 0 0 29 4 4 4
0 1 1 1 32 8 3 6
0 0 0 0 18 3 3 6
0 0 1 0 19 3 4 4
0 1 0 1 24 4 6 6
0 1 1 1 26 4 6 6
0 0 1 1 26 4 6 6
0 1 1 1 28 4 5 6
1 1 1 1 33 4 3 2
0 0 0 1 24 4 3 6
0 0 0 0 22 6 5 6
0 1 1 0 26 4 4 6
0 1 1 1 30 4 3 2
0 1 0 1 27 8 6 8
0 1 0 1 21 8 6 8
1 1 1 1 31 8 6 8
0.5808 0.45318 0.38508 0.503066 0.807085 0.772562 0.801846
0.444 0.444 0.444 0.444 0.444 0.444 0.444
V V T V V V V
44 45 Skor Total
4 2 17
4 2 19
4 2 22
4 2 18
4 4 20
4 2 23
2 2 16
2 2 15
4 2 22
4 2 22
4 2 22
4 2 21
4 2 15
2 2 17
4 2 23
4 2 20
4 2 15
4 2 28
4 2 28
4 2 28
0.46706 -0.030833
0.444 0.444
V T