LANGKAH - LANGKAH DALAM MENYELESAIKAN RANCANGAN ACAK LENGKAP FAKTORIAL MELALUI EXCEL
|
Nama
:
|
Hengki
Hermawan (1205101050067)
|
blog
:
|
|||||||||
|
Skripsi
:
|
Mulyana
(0705101030015) Program Studi Agroteknologi, Fakultas Pertanian, Universitas
Syiah Kuala, Darussalam Banda Aceh 2013
|
||||||||||
|
Judul
:
|
Kadar Air Optimum Untuk Penyimpanan Benih
Beberapa Jenis Jeruk (Citrus sp)
|
||||||||||
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
|
|
Lampiran
21. Rata - Rata Nilai T20 Benih Beberapa Jenis Jeruk Setelah 25 Hari
Penyimpanan Pada Berbagai Taraf Desikasi
|
5
|
||||||||||
|
Perlakuan
|
Ulangan (%)
|
|
Total
|
Rerata
|
6
|
||||||
|
I
|
II
|
III
|
I
|
II
|
III
|
7
|
|||||
|
K1V1
|
13,33
|
12,00
|
13,50
|
21,41
|
20,27
|
21,56
|
63,24
|
21,08
|
8
|
||
|
K2V1
|
13,00
|
8,750
|
12,11
|
21,13
|
17,20
|
20,36
|
58,69
|
19,56
|
9
|
||
|
K3V1
|
13,11
|
12,33
|
11,85
|
21,23
|
20,56
|
20,13
|
61,92
|
20,64
|
10
|
||
|
K1V2
|
11,06
|
14,00
|
14,00
|
19,97
|
21,97
|
21,97
|
63,91
|
21,30
|
11
|
||
|
K2V2
|
13,50
|
10,71
|
11,71
|
21,56
|
19,10
|
20,01
|
60,67
|
20,22
|
12
|
||
|
K3V2
|
11,75
|
10,75
|
12,00
|
20,05
|
19,14
|
20,27
|
59,46
|
19,82
|
13
|
||
|
K1V3
|
12,33
|
16,00
|
14,66
|
20,56
|
23,58
|
22,51
|
66,65
|
22,22
|
14
|
||
|
K2V3
|
13,83
|
15,00
|
14,43
|
21,83
|
22,79
|
22,32
|
66,94
|
22,31
|
15
|
||
|
K3V3
|
13,00
|
12,66
|
14,66
|
21,13
|
20,84
|
22,51
|
64,48
|
21,49
|
16
|
||
|
Total
|
|
|
|
188,87
|
185,45
|
191,64
|
565,96
|
20,96
|
17
|
||
|
=SUM(H8:H16)
|
Ȳ
= 20.96
|
18
|
|||||||||
|
=AVERAGE(I8:I16)
|
19
|
||||||||||
|
20
|
|||||||||||
|
Jumlah
Ulangan (U) =
|
=COUNTA(B7:D7)
|
3
|
21
|
||||||||
|
Jumlah
Perlakuan (P) =
|
=COUNTA(A8:A16)
|
9
|
22
|
||||||||
|
Jumlah
Perlakuan Kadar Air (K) =
|
=COUNTA(A8:A10)
|
3
|
23
|
||||||||
|
Jumlah
Perlakuan Varietas (V) =
|
=COUNTA(A8:A10)
|
3
|
24
|
||||||||
|
Faktor
Koreksi (FK) =
|
Grand
Total^2 / UKV
|
=H17^2/27
|
11863,36
|
25
|
|||||||
|
Derajat
Bebas Perlakuan =
|
KV
- 1
|
|
=COUNTA(A8:A16)-1
|
8
|
26
|
||||||
|
Derajat
Bebas (DB) Perlakuan "K" =
|
K
- 1
|
|
=I23-1
|
|
2
|
27
|
|||||
|
Derajat
Bebas (DB) Perlakuan "V" =
|
V
-1
|
|
=I24-1
|
|
2
|
28
|
|||||
|
Derajat
Bebas (DB) Interaksi "K x V" =
|
(K-1)
(V-1)
|
=I27*I28
|
|
4
|
29
|
||||||
|
Derajat
Bebas (DB) Galat =
|
(K.V)
(U-1)
|
=(I23*I24)*(I21-1)
|
18
|
30
|
|||||||
|
Derajat
Bebas (DB) Total =
|
K.V.U
- 1
|
|
=I23*I24*I21-1
|
26
|
31
|
||||||
|
JK
Total =
|
Σx2
- FK
|
|
=SUMSQ(E8:G16)-I25
|
46,673941
|
32
|
||||||
|
JK
Perlakuan =
|
Σp2/U
- FK
|
=SUMSQ(H8:H16)/I21-I25
|
23,168341
|
33
|
|||||||
|
JK
Galat =
|
JK
Tot -JK Per
|
=I32-I33
|
|
23,5056
|
34
|
||||||
|
35
|
|||||||||||
|
Tabel
Interaksi Kadar Air (K) Dengan Varietas Jeruk (V)
|
36
|
||||||||||
|
Kadar Air
|
Jumlah Hasil (KV)
|
Jumlah K
|
37
|
||||||||
|
V1
|
V2
|
V3
|
38
|
||||||||
|
K1
|
63,24
|
63,91
|
66,65
|
193,80
|
39
|
||||||
|
K2
|
58,69
|
60,67
|
66,94
|
186,30
|
40
|
||||||
|
K3
|
61,92
|
59,46
|
64,48
|
185,86
|
41
|
||||||
|
Jumlah
V
|
183,85
|
184,04
|
198,07
|
565,96
|
42
|
||||||
|
43
|
|||||||||||
|
JK
Kadar Air (K) =
|
ΣK2/UV
- FK
|
=SUMSQ(B42:D42)/I22-I25
|
4,4254519
|
44
|
|||||||
|
JK
Varietas (V) =
|
ΣV2/UK
- FK
|
=SUMSQ(E39:E41)/I22-I25
|
14,780941
|
45
|
|||||||
|
JK
K x V =
|
JK
Per - JK K -JK V
|
=I33-I44-I45
|
3,9619481
|
46
|
|||||||
|
KT
Perlakuan =
|
JK
Per / DB Per
|
=I33/I26
|
|
2,8960426
|
47
|
||||||
|
KT
K =
|
JK
K /K-1
|
|
=I44/I27
|
|
2,2127259
|
48
|
|||||
|
KT
V =
|
JK
V /V-1
|
=I45/I28
|
|
7,3904704
|
49
|
||||||
|
KT
K x V =
|
JK
K x V /(K-1) (V-1)
|
=I46/I29
|
|
0,990487
|
50
|
||||||
|
KT
Galat
|
JK
Gal /(U-1)(KV)
|
=I34/I30
|
|
1,3058667
|
51
|
||||||
|
F
Hitung Perlakuan =
|
KT
Per / KT Gal
|
=I47/I51
|
|
2,2177169
|
52
|
||||||
|
F
Hitung (K) =
|
KT
K / KT Gal
|
=I48/I51
|
|
1,6944501
|
53
|
||||||
|
F
Hitung (V) =
|
KT
V / KT Gal
|
=I49/I51
|
|
5,6594372
|
54
|
||||||
|
F
Hitung (K x V) =
|
KT
K x V / KT Gal
|
=I50/I51
|
|
0,7584902
|
55
|
||||||
|
Koefisien
Keragaman (KK) =
|
56
|
||||||||||
|
57
|
|||||||||||
|
Lampiran
22. Analisis Ragam Nilai T20 Benih Beberapa Jenis Jeruk Setelah 25 Hari
Penyimpanan Pada Berbagai Taraf Desikasi
|
58
|
||||||||||
|
SK
|
DB
|
JK
|
KT
|
F Hitung
|
F Tabel
|
59
|
|||||
|
0,05
|
0,01
|
60
|
|||||||||
|
Perlakuan
|
8
|
23,17
|
2,90
|
2,22
|
tn
|
2,51
|
3,71
|
61
|
|||
|
K
|
2
|
4,43
|
2,21
|
1,69
|
tn
|
3,55
|
6,01
|
62
|
|||
|
V
|
2
|
14,78
|
7,39
|
5,66
|
*
|
3,55
|
6,01
|
63
|
|||
|
K x V
|
4
|
3,96
|
0,99
|
0,76
|
tn
|
2,93
|
4,58
|
64
|
|||
|
Galat
|
18
|
23,51
|
1,31
|
|
65
|
||||||
|
Total
|
26
|
46,67
|
|
66
|
|||||||
|
67
|
|||||||||||
|
Keterangan :
|
68
|
||||||||||
|
Koefisien
Keragaman (KK) :
|
5,45%
|
69
|
|||||||||
|
F
Hitung < F Tabel α 0.05 :
|
tn
(Tidak Berbeda Nyata)
IF(E61<G61,"tn",IF(E61<H61,"*",IF(E61>H61,"**")))
|
|
70
|
||||||||
|
F
Hitung > F Tabel α 0.05 :
|
*
(Berbeda Nyata)
=IF(E62<G62,"tn",IF(E62<H62,"*",IF(E62>H62,"**")))
|
|
71
|
||||||||
|
72
|
|||||||||||
|
Kesimpulan
:
|
1.
Kadar Air Optimum Berpengaruh Nyata Terhadap Penyimpanan Benih Jeruk (Citrus
sp.)
|
73
|
|||||||||
|
2.
Jenis Varietas Tidak Berpengaruh Nyata Terhadap Penyimpanan Benih Jeruk (Citrus
sp.)
|
74
|
||||||||||
|
3.
Interaksi Antara Kadar Air Dan Jenis Varietas Tidak Berpengaruh Nyata
Terhadap Penyimpanan Benih Jeruk (Citrus sp.)
|
75
|
||||||||||
0 comments:
Post a Comment