LANGKAH - LANGKAH DALAM MENYELESAIKAN RANCANGAN ACAK LENGKAP NON FAKTORIAL MELALUI EXCEL
|
Nama
|
Hengki
Hermawan (1205101050067)
|
blog :
|
||||||||
|
Skripsi
|
Muhammad
Faisal (0805101050053), Program Studi Agroteknologi, Fakultas Pertanian,
Universitas Syiah Kuala, Darussalam Banda Aceh 2013
|
|||||||||
|
Judul
|
Pengaruh
Konsentrasi Trichoderma virens Dalam Menghambat Perkembangan Penyakit
Busuk Buah (Phytophthora palmivora) Pada Buah Kakao (Theobroma
cacao)
|
|||||||||
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
|
Lampiran
1. Masa Inkubasi HSI (Hari)
|
5
|
|||||||||
|
Perlakuan
Ulangan
|
Ulangan
|
Total
|
Rerata
|
6
|
||||||
|
I
|
II
|
III
|
IV
|
V
|
VI
|
7
|
||||
|
T0
|
3,00
|
4,33
|
3,33
|
3,33
|
3,00
|
5,33
|
22,32
|
3,72
|
|
8
|
|
T1
|
3,00
|
3,00
|
3,00
|
4,33
|
3,67
|
5,00
|
22,00
|
3,67
|
9
|
|
|
T2
|
3,00
|
3,00
|
3,33
|
4,33
|
3,00
|
4,00
|
20,66
|
3,44
|
|
10
|
|
T3
|
5,67
|
3,67
|
4,33
|
4,33
|
5,33
|
4,67
|
28,00
|
4,67
|
11
|
|
|
T4
|
5,33
|
5,33
|
5,67
|
4,33
|
4,67
|
5,33
|
30,66
|
5,11
|
|
12
|
|
Total
|
|
123,64
|
|
|
13
|
|||||
|
rerata
|
|
4,12
|
|
14
|
||||||
|
=SUM(H8:H12)
|
15
|
|||||||||
|
=AVERAGE(I8:I13)
|
16
|
|||||||||
|
17
|
||||||||||
|
Jumlah
Ulangan (U) =
|
=COUNTA(B7:G7)
|
6
|
18
|
|||||||
|
Jumlah
Perlakuan(P) =
|
=COUNTA(A8:A12)
|
5
|
19
|
|||||||
|
Faktor
Koreksi (FK) =
|
Grand
Total/p.u
|
=H13^2/30
|
509,562
|
20
|
||||||
|
Derajat
Bebas (db) Perlakuan =
|
Perlakuan
- 1
|
=COUNTA(A9:A13)-1
|
4
|
21
|
||||||
|
Derajat
Bebas (db) Galat =
|
Perlakuan
(u-1)
|
=H18*(H19-1)
|
24
|
22
|
||||||
|
Derajat
Bebas (db) Total =
|
P.U
-1
|
|
=H18*H19-1
|
29
|
23
|
|||||
|
JK
Total=
|
ΣX2
- FK
|
|
=SUMSQ(B8:G12)-H20
|
26,096
|
24
|
|||||
|
JK
Perlakuan =
|
ΣP2/u
- FK
|
=SUMSQ(H8:H12)/H18-H20
|
12,614
|
25
|
||||||
|
JK
Galat =
|
JK
t - JK p
|
|
=H24-H25
|
13,482
|
26
|
|||||
|
KT
Perlakuan =
|
JK
p/ p-1
|
|
=H25/(H19-1)
|
3,153
|
27
|
|||||
|
Kuadrat
Tengah (KT) galat =
|
JK
g/p (u-1)
|
=H26/H22
|
0,539
|
28
|
||||||
|
F
Hitung =
|
KT
p / KT g
|
=H27/H28
|
5,847413
|
29
|
||||||
|
30
|
||||||||||
|
tabel
2. sidik ragam masa inkubasi HSI (Hari)
|
31
|
|||||||||
|
SK
|
DB
|
JK
|
KT
|
F hitung
|
F Tabel
|
32
|
||||
|
0,05
|
0,01
|
33
|
||||||||
|
Perlakuan
|
4
|
12,614
|
3,153
|
5,847
|
**
|
2,76
|
4,18
|
34
|
||
|
Galat
|
24
|
13,482
|
0,539
|
|
35
|
|||||
|
Total
|
29
|
26,096
|
|
36
|
||||||
|
Keterangan
:
|
37
|
|||||||||
|
38
|
||||||||||
|
KK
=
|
17,81%
|
39
|
||||||||
|
F
Hitung > F Tabel =
|
**
|
Berpengaruh
Sangat Nyata
|
40
|
|||||||
|
F34
|
=IF(E34<G34,"tn",IF(E34<H34,"*",IF(E34>H34,"**")))
|
41
|
||||||||
|
|
42
|
|||||||||
|
Kesimpulan
: Pengaruh Konsentrasi Trichoderma virens Berpengaruh Sangat Nyata
Dalam Menghambat Perkembangan Penyakit Busuk Buah (Phytophthora palmivora)
Pada Buah Kakao (Theobroma cacao).
|
43
|
|||||||||
0 comments:
Post a Comment