analisis soal.xls

5
ANALISIS RELIABILITAS No Nama Skor Siswa untuk Butir Soal Nomor Y 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 MA 1 1 1 0 0 0 1 0 1 0 0 1 0 1 0 7 2 EMN 1 1 1 0 0 1 1 0 0 1 0 0 1 1 1 9 3 DS 1 1 0 0 1 0 1 0 0 1 0 0 0 0 1 6 4 RSR 1 1 1 0 1 0 1 0 0 0 0 0 0 0 1 6 5 IFS 1 1 1 1 1 1 1 1 0 1 0 1 1 0 1 12 6 NHD 1 1 1 1 1 0 1 0 0 1 0 1 1 0 1 10 7 TWA 1 1 0 0 0 0 0 1 0 0 1 1 1 1 1 8 8 DH 1 1 1 0 0 0 1 1 0 0 0 1 0 0 0 6 9 MTN 0 0 1 0 1 0 0 0 0 1 0 0 1 0 1 5 10 NL 1 0 0 1 1 0 1 0 0 1 0 0 1 0 1 7 11 LAM 1 1 1 0 1 0 0 0 1 0 1 1 1 1 0 9 12 MAA 1 1 0 0 1 1 0 0 0 0 1 0 1 0 1 7 13 MF 1 1 1 0 1 0 1 0 0 0 1 0 0 0 1 7 14 KY 1 1 1 1 1 1 1 0 1 1 1 0 0 1 1 12 15 BK 1 1 1 1 1 0 1 0 0 0 1 0 1 0 0 8 16 DRA 1 1 1 1 1 0 1 0 0 0 0 0 1 1 1 9 17 ASJ 1 1 1 1 1 1 1 1 0 0 1 1 1 0 1 12 18 FB 1 1 1 1 1 1 1 0 0 0 0 1 1 1 0 10 19 PNW 1 1 1 0 1 0 0 1 1 0 0 0 0 1 1 8 20 SNR 1 1 1 0 1 1 0 0 1 0 0 0 0 1 1 8

Upload: iwan-wicaksono

Post on 25-Oct-2015

8 views

Category:

Documents


0 download

DESCRIPTION

f

TRANSCRIPT

Page 1: analisis soal.xls

ANALISIS RELIABILITAS

No NamaSkor Siswa untuk Butir Soal Nomor

Y1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

1 MA 1 1 1 0 0 0 1 0 1 0 0 1 0 1 0 72 EMN 1 1 1 0 0 1 1 0 0 1 0 0 1 1 1 93 DS 1 1 0 0 1 0 1 0 0 1 0 0 0 0 1 64 RSR 1 1 1 0 1 0 1 0 0 0 0 0 0 0 1 65 IFS 1 1 1 1 1 1 1 1 0 1 0 1 1 0 1 126 NHD 1 1 1 1 1 0 1 0 0 1 0 1 1 0 1 107 TWA 1 1 0 0 0 0 0 1 0 0 1 1 1 1 1 88 DH 1 1 1 0 0 0 1 1 0 0 0 1 0 0 0 69 MTN 0 0 1 0 1 0 0 0 0 1 0 0 1 0 1 510 NL 1 0 0 1 1 0 1 0 0 1 0 0 1 0 1 711 LAM 1 1 1 0 1 0 0 0 1 0 1 1 1 1 0 912 MAA 1 1 0 0 1 1 0 0 0 0 1 0 1 0 1 713 MF 1 1 1 0 1 0 1 0 0 0 1 0 0 0 1 714 KY 1 1 1 1 1 1 1 0 1 1 1 0 0 1 1 1215 BK 1 1 1 1 1 0 1 0 0 0 1 0 1 0 0 816 DRA 1 1 1 1 1 0 1 0 0 0 0 0 1 1 1 917 ASJ 1 1 1 1 1 1 1 1 0 0 1 1 1 0 1 1218 FB 1 1 1 1 1 1 1 0 0 0 0 1 1 1 0 1019 PNW 1 1 1 0 1 0 0 1 1 0 0 0 0 1 1 820 SNR 1 1 1 0 1 1 0 0 1 0 0 0 0 1 1 8

Page 2: analisis soal.xls

1 14 14 14 14 14 14 14 14 14 14 14 14 14 0 142 13 13 13 13 13 13 13 0 13 13 13 13 0 13 133 13 13 13 13 13 13 13 13 13 13 0 13 0 13 134 12 12 12 12 12 0 12 0 12 12 0 12 12 12 125 11 11 11 11 11 11 11 11 0 0 11 11 0 11 06 10 10 10 10 0 10 10 10 0 10 0 0 10 10 07 12 12 12 12 12 0 0 12 12 12 12 12 12 12 08 0 8 8 8 8 0 8 8 0 0 0 0 0 8 89 6 6 0 0 0 0 0 6 0 0 6 6 0 0 610 8 8 8 8 8 0 8 0 0 0 8 0 8 0 011 7 0 7 0 7 0 0 7 7 0 0 0 0 7 712 9 9 9 0 9 9 0 9 9 0 0 0 0 9 913 0 6 6 0 0 0 6 0 6 0 0 6 0 6 014 7 0 0 7 7 0 7 0 0 7 0 0 7 0 715 0 7 0 7 7 7 0 0 7 0 7 0 0 0 716 0 5 5 0 5 0 5 0 0 0 5 0 0 0 017 7 7 0 7 7 0 7 0 0 7 0 0 0 7 018 4 0 4 0 4 0 4 0 0 0 0 0 0 0 019 6 6 6 0 0 0 6 6 0 0 0 6 0 0 020 0 0 5 0 5 0 0 0 0 5 0 0 5 0 5

139 147 143 122 142 77 124 96 93 93 76 93 68 108 101

Page 3: analisis soal.xls

No NamaSkor Siswa untuk Butir Soal Nomor

Y Y2 ƩX ƩX2 ƩY2 (ƩX)2 (ƩY)21 2 3 4 5 6 7 8 9 10 11 12 13 14 15

1 IFS 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 14 196 15 170 139 15 1622 225 289002 KY 1 1 1 1 1 1 1 0 1 1 1 1 0 1 1 13 169 16 170 147 16 1622 256 289003 ASJ 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 13 169 16 170 143 16 1622 256 289004 NHD 1 1 1 1 1 0 1 0 1 1 0 1 1 1 1 12 144 12 170 122 12 1622 144 289005 FB 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 11 121 16 170 142 16 1622 256 289006 EMN 1 1 1 1 0 1 1 1 0 1 0 0 1 1 0 10 100 7 170 77 7 1622 49 289007 LAM 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 12 144 14 170 124 14 1622 196 289008 DRA 0 1 1 1 1 0 1 1 0 0 0 0 0 1 1 8 64 10 170 96 10 1622 100 289009 TWA 1 1 0 0 0 0 0 1 0 0 1 1 0 0 1 6 36 9 170 93 9 1622 81 2890010 BK 1 1 1 1 1 0 1 0 0 0 1 0 1 0 0 8 64 9 170 93 9 1622 81 2890011 PWN 1 0 1 0 1 0 0 1 1 0 0 0 0 1 1 7 49 8 170 76 8 1622 64 2890012 SNR 1 1 1 0 1 1 0 1 1 0 0 0 0 1 1 9 81 9 170 93 9 1622 81 2890013 MA 0 1 1 0 0 0 1 0 1 0 0 1 0 1 0 6 36 7 170 68 7 1622 49 2890014 NL 1 0 0 1 1 0 1 0 0 1 0 0 1 0 1 7 49 11 170 108 11 1622 121 2890015 MAA 0 1 0 1 1 1 0 0 1 0 1 0 0 0 1 7 49 11 170 101 11 1622 121 2890016 MF 0 1 1 0 1 0 1 0 0 0 1 0 0 0 0 5 2517 DS 1 1 0 1 1 0 1 0 0 1 0 0 0 1 0 7 4918 RSR 1 0 1 0 1 0 1 0 0 0 0 0 0 0 0 4 1619 DH 1 1 1 0 0 0 1 1 0 0 0 1 0 0 0 6 3620 MTN 0 0 1 0 1 0 0 0 0 1 0 0 1 0 1 5 25

X 15 16 16 12 16 7 14 10 9 9 8 9 7 11 11 170 1622BA 9 10 9 9 8 5 8 7 5 6 6 7 5 7 6BB 6 6 7 3 8 2 6 3 4 3 2 2 2 4 5JA 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10JB 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10

ƩY ƩXY

Page 4: analisis soal.xls

N*(ƩXY) (ƩX)(ƩY) N*ƩX2 N*ƩY2 N*ƩX2-(ƩX)2 N*ƩY2-(ƩY)2 √(N*ƩX2-(ƩX)2)(N*ƩY2-(ƩY)2) N*ƩXY-(ƩX)(ƩY) AKAR Rxy

2780 2550 300 32440 75 3540 265500 230 515.2669 0.446372940 2720 320 32440 64 3540 226560 220 475.9832 0.46222860 2720 320 32440 64 3540 226560 140 475.9832 0.294132440 2040 240 32440 96 3540 339840 400 582.958 0.686162840 2720 320 32440 64 3540 226560 120 475.9832 0.252111540 1190 140 32440 91 3540 322140 350 567.5738 0.616662480 2380 280 32440 84 3540 297360 100 545.3073 0.183381920 1700 200 32440 100 3540 354000 220 594.979 0.369761860 1530 180 32440 99 3540 350460 330 591.9966 0.557441860 1530 180 32440 99 3540 350460 330 591.9966 0.557441520 1360 160 32440 96 3540 339840 160 582.958 0.274461860 1530 180 32440 99 3540 350460 330 591.9966 0.557441360 1190 140 32440 91 3540 322140 170 567.5738 0.299522160 1870 220 32440 99 3540 350460 290 591.9966 0.489872020 1870 220 32440 99 3540 350460 150 591.9966 0.25338

Page 5: analisis soal.xls

Rxy tabel Keterangan

0.444 Valid0.444 Valid0.444 Tidak Valid0.444 Valid0.444 Tidak Valid0.444 Valid0.444 Tidak Valid0.444 Tidak Valid0.444 Valid0.444 Valid0.444 Tidak Valid0.444 Valid0.444 Tidak Valid0.444 Valid0.444 Tidak Valid