auto pengiraan sisihan piawai, min, varian,population dan korelasi linear terutamanya untuk kajian...
TRANSCRIPT
Jadual Pengiraan Perbandingan Ujian ( Bagi 2 Ujian)
Kad PerkataanUjian 1 (Pra) Ujian 2 (Pos) Ujian 1 (Pra)
Ayat Pendek
X1 Ujian X2 beza Pra Responden 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20Jumlah 0 Min 0 Sisihan piawai #DIV/0! Varian 0 Population #DIV/0! kolerasi linear
X3 kuasa 2 Y1 Ujian Y2 beza Y3 kuasa X1 Ujian X2 beza X3 kuasa (X2*X2) Pos 2 (Y2*Y2) X2 * Y2 Pos 2 (X2*X2) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
40 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34 34686 34.3 1.34 1.8 1.3077 #DIV/0!
5.7 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.3 -0.30
32.49 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.0934.2
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32640 32 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00
#DIV/0!
2 Ujian)
Ayat PendekUjian 2 (Pos)
Y1 Ujian Y2 beza Y3 kuasa 2 X2 * Y2 Pos (Y2*Y2) 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12240 12 0 0 0 #DIV/0!
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0