LANGKAH - LANGKAH DALAM MENYELESAIKAN RANCANGAN ACAK KELOMPOK FAKTORIAL MELALUI PROGRAM EXCEL
|
Nama
|
Hengki
Hermawan (1205101050067)
|
Blog
:
|
||||||||
|
Skripsi
|
Bayhaqqi
(0705101010046), Program Studi Agroteknologi Fakultas Pertanian Universitas
Syiah Kuala, Tahun 2013
|
|||||||||
|
Judul
|
Pengaruh
Varietas dan Jenis Pupuk Terhadap Pertumbuhan Dan Hasil Bawang Merah (Alliumcepa
L)
|
|||||||||
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
4
|
|
|
Lampiran
7.
|
Rata-rata
Tinggi Tanaman 35 HST (cm)
|
5
|
||||||||
|
Perlakuan
|
BLOK
|
Jumlah
|
Rerata
|
6
|
||||||
|
I
|
II
|
III
|
7
|
|||||||
|
V1P1
|
44,08
|
37,49
|
41,16
|
122,73
|
40,91
|
8
|
||||
|
V1P2
|
45,48
|
37,49
|
43,18
|
126,15
|
42,05
|
9
|
||||
|
V1P3
|
28,21
|
35,55
|
41,16
|
104,92
|
34,97
|
10
|
||||
|
V2P1
|
30,64
|
23,85
|
35,56
|
90,05
|
30,02
|
11
|
||||
|
V2P2
|
26,11
|
30,13
|
31,66
|
87,90
|
29,30
|
12
|
||||
|
V2P3
|
30,85
|
28,03
|
32,04
|
90,92
|
30,31
|
13
|
||||
|
V3P1
|
34,76
|
37,10
|
33,74
|
105,6
|
35,20
|
14
|
||||
|
V3P2
|
36,46
|
36,99
|
31,74
|
105,19
|
35,06
|
15
|
||||
|
V3P3
|
29,69
|
41,86
|
45,16
|
116,71
|
38,90
|
16
|
||||
|
Total
|
306,28
|
308,49
|
335,40
|
950,17
|
|
=SUM(E8:E16)
|
17
|
|||
|
Rerata
|
|
35,19
|
=AVERAGE(F8:F16)
|
18
|
||||||
|
19
|
||||||||||
|
Jumlah
Perlakuan =
|
9
|
=COUNTA(A8:A16)
|
20
|
|||||||
|
Jumlah
Ulangan =
|
3
|
=COUNTA(B7:D7)
|
21
|
|||||||
|
Perlakuan
V =
|
3
|
=COUNTA(A8,A11,A14)
|
22
|
|||||||
|
Perlakuan
P =
|
3
|
=COUNTA(A8,A9,A10)
|
23
|
|||||||
|
Faktor
Koreksi (FK) =
|
|
|
33437,89
|
=E17^2/(3*3*3)
|
24
|
|||||
|
db
Perlakuan =
|
(VP-1)
|
|
8
|
=E22*E23-1
|
25
|
|||||
|
db
V =
|
V-1
|
|
2
|
=E22-1
|
|
26
|
||||
|
db
P =
|
P-1
|
|
2
|
=E23-1
|
|
27
|
||||
|
V
x P = (V-1)(P-1)
|
(V-1)(P-1)
|
|
4
|
=E26*E27
|
|
28
|
||||
|
db
Galat = (VP-1)(ulangan-1)
|
(VP-1)(ulangan-1)
|
16
|
=(E22*E23-1)*(E21-1)
|
29
|
||||||
|
db
Total = V.P.Ulangan - 1
|
(V.P.Ulangan)-1
|
26
|
=E22*E23*E21-1
|
30
|
||||||
|
JK
Total =
|
 |
926,268
|
=SUMSQ(B8:D16)-E24
|
31
|
||||||
|
JK
Ulangan
|
 |
 |
58,408
|
=SUMSQ(B17:D17)/(E22*E23)-E24
|
32
|
|||||
|
JK
Perlakuan =
|
536,797
|
=SUMSQ(E8:E16)/E21-E24
|
33
|
|||||||
|
JK
(Jumlah Kuadrat) Galat =
|
JKT-JKU-JKP
|
331,064
|
=E31-E32-E33
|
34
|
||||||
|
35
|
||||||||||
|
Ketebalan M.T.
|
Jumlah Hasil
|
Jumlah V
|
36
|
|||||||
|
P1
|
P2
|
P3
|
37
|
|||||||
|
V1
|
122,73
|
126,15
|
104,92
|
353,8
|
38
|
|||||
|
V2
|
90,05
|
87,90
|
90,92
|
268,87
|
39
|
|||||
|
V3
|
105,6
|
105,19
|
116,71
|
327,5
|
40
|
|||||
|
Jumlah
P
|
318,38
|
319,24
|
312,55
|
|
41
|
|||||
|
42
|
||||||||||
|
JK
V =
|
 |
420,08
|
=SUMSQ(E38:E40)/E20-E24
|
43
|
||||||
|
JK
P =
|
|
2,94
|
=SUMSQ(B41:D41)/E20-E24
|
44
|
||||||
|
JK
VxP =
|
JK Per - JK V
-JK P
|
113,77
|
=E33-E43-E44
|
45
|
||||||
|
KT
Perlakuan =
|
JK Per / DB
Per
|
67,10
|
=E33/E25
|
|
46
|
|||||
|
KT
V =
|
JK V /V-1
|
|
210,04
|
=E43/E26
|
|
47
|
||||
|
KT
P =
|
JK P /P-1
|
|
1,47
|
=E44/E27
|
|
48
|
||||
|
KT
V x P =
|
JK V x P
/(V-1) (P-1)
|
28,44
|
=E45/E28
|
|
49
|
|||||
|
KT
Galat
|
JK Gal
/(U-1)(VP-1)
|
20,69
|
=E34/E29
|
|
50
|
|||||
|
F
Hitung Perlakuan =
|
KT Per / KT
Gal
|
3,24
|
=E46/E50
|
|
51
|
|||||
|
F
Hitung (V) =
|
KT V / KT Gal
|
10,15
|
=E47/E50
|
|
52
|
|||||
|
F
Hitung (P) =
|
KT P / KT Gal
|
0,07
|
=E48/E50
|
|
53
|
|||||
|
F
Hitung (V x P) =
|
KT V x P / KT
Gal
|
1,37
|
=E49/E50
|
|
54
|
|||||
|
Koefisien
Keragaman (KK) =
|
 |
|
12,93
|
=SQRT(E50)/F18*100
|
55
|
|||||
|
56
|
||||||||||
|
SK
|
DB
|
JK
|
KT
|
F hitung
|
F Tabel
|
57
|
||||
|
0,05
|
0,01
|
58
|
||||||||
|
Perlakuan
|
8
|
536,797
|
67,100
|
3,243
|
*
|
2,59
|
3,89
|
59
|
||
|
V
|
2
|
420,084
|
210,042
|
10,151
|
**
|
3,63
|
6,23
|
60
|
||
|
P
|
2
|
2,944
|
1,472
|
0,071
|
tn
|
3,63
|
6,23
|
61
|
||
|
V
x P
|
4
|
113,769
|
28,442
|
1,375
|
tn
|
3,01
|
4,77
|
62
|
||
|
Galat
|
16
|
331,064
|
20,691
|
|
63
|
|||||
|
Total
|
26
|
926,268
|
|
64
|
||||||
|
65
|
||||||||||
|
66
|
||||||||||
|
Koefisien
Keragaman (KK) : 12.93%
|
67
|
|||||||||
|
68
|
||||||||||
|
Kesimpulan
:
|
1.
Pengaruh Varietas Berpengaruh Sangat Nyata Terhadap Tinggi Tanaman Bawang
Merah
|
69
|
||||||||
|
2.
Pengaruh Jenis Pupuk Berpengaruh Nyata Terhadap Tinggi Tanaman Bawang
Merah
|
70
|
|||||||||
|
3.
Interaksi Antara Pengaruh Varietas dan Jenis Pupuk Tidak Berpengaruh Nyata
Terhadap Tinggi Tanaman Bawang Merah
|
71
|
|||||||||
0 comments:
Post a Comment