auto pengiraan sisihan piawai, min, varian,population dan korelasi linear terutamanya untuk kajian...

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