LANGKAH LANGKAH DALAM MENGERJAKAN RANCANGAN ACAK KELOMPOK NON FAKTORIAL MELALUI EXCEL
|
Nama
|
Hengki
Hermawan (1205101050067)
|
blog :
|
||||||||
|
Skripsi
|
Zulfikri
(0805101050066) Program Studi Agroteknologi Fakultas Pertanian Universitas Syiah Kuala Darussalam, Banda
Aceh 2014
|
|||||||||
|
Judul
|
Penampilan
Fenotifik, Parameter Genetik, Karakter Hasil Dan Komponen Hasil Tanaman Melon
(Cucumis melo L)
|
|||||||||
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
|
|
Lampiran
4. Rata - Rata Diameter Buah Melon (cm)
|
5
|
|||||||||
|
Genotipe
|
BLOK
|
TOTAL
|
RERATA
|
6
|
||||||
|
|
I
|
II
|
III
|
|
7
|
|||||
|
G1
|
13,78
|
13,63
|
12,97
|
40,38
|
13,46
|
8
|
||||
|
G2
|
14,76
|
14,56
|
14,32
|
43,64
|
14,55
|
9
|
||||
|
G3
|
12,78
|
13,32
|
13,52
|
39,62
|
13,21
|
10
|
||||
|
G4
|
14,73
|
14,85
|
14,83
|
44,41
|
14,80
|
11
|
||||
|
G5
|
13,83
|
13,58
|
13,12
|
40,53
|
13,51
|
12
|
||||
|
G6
|
11,67
|
11,82
|
11,38
|
34,87
|
11,62
|
13
|
||||
|
TOTAL
|
81,55
|
81,76
|
80,14
|
243,45
|
|
14
|
||||
|
Rerata
|
|
|
|
|
13,53
|
15
|
||||
|
=SUM(B15:D15)
|
16
|
|||||||||
|
=AVERAGE(F9:F14)
|
17
|
|||||||||
|
18
|
||||||||||
|
Jumlah
Ulangan =
|
=COUNTA(B7:D7)
|
|
3
|
19
|
||||||
|
Jumlah
Perlakuan =
|
=COUNTA(A8:A13)
|
|
6
|
20
|
||||||
|
Faktor
Koreksi (FK) =
|
Grand
Total/P.U
|
=E14^2/18
|
|
3292,661
|
21
|
|||||
|
Derajat
Bebas (DB) Ulangan =
|
Ulangan
- 1
|
=COUNTA(B7:D7)-1
|
|
2
|
22
|
|||||
|
Derajat
Bebas (DB) Perlakuan =
|
Perlakuan
- 1
|
=COUNTA(A8:A13)-1
|
|
5
|
23
|
|||||
|
Derajat
Bebas (DB) Galat =
|
(P
- 1)(U - 1)
|
=I23*I22
|
|
|
10
|
24
|
||||
|
Derajat
Bebas (DB) Total =
|
(P
. U) -1
|
|
=(I20*I19)-1
|
|
17
|
25
|
||||
|
JK
Total=
|
ΣX2
- FK
|
|
=SUMSQ(B8:D13)-I21
|
|
20,32945
|
26
|
||||
|
JK
Ulangan =
|
ΣU2/P
- FK
|
|
=SUMSQ(B14:D14)/I20-I21
|
0,2587
|
27
|
|||||
|
JK
Perlakuan =
|
ΣP2/U
-FK
|
|
=SUMSQ(E8:E13)/I19-I21
|
19,20018
|
28
|
|||||
|
JK
Galat =
|
JK
t - JK u - JK p
|
=I26-I27-I28
|
|
0,870567
|
29
|
|||||
|
KT
Ulangan =
|
JK
u/ U-1
|
|
=I27/I22
|
|
|
0,12935
|
30
|
|||
|
KT
Perlakuan =
|
JK
p/ P -1
|
|
=I28/I23
|
|
|
3,840037
|
31
|
|||
|
KT
Galat =
|
JK
g / (P-1)(U-1)
|
=I29/I24
|
|
|
0,087057
|
32
|
||||
|
F
Hitung =
|
KT
p / KT g
|
|
=I31/I32
|
|
|
44,10962
|
33
|
|||
|
34
|
||||||||||
|
Lampiran
5. Analisis Ragam Rata - Rata Diameter Buah Melon
|
35
|
|||||||||
|
SK
|
DB
|
JK
|
KT
|
F Hitung
|
F Tabel
|
36
|
||||
|
0,05
|
0,01
|
37
|
||||||||
|
Ulangan
|
2
|
0,2587
|
0,12935
|
1,485814
|
tn
|
4,10
|
7,56
|
38
|
||
|
Perlakuan
|
5
|
19,20018
|
3,840037
|
44,10962
|
**
|
3,33
|
5,64
|
39
|
||
|
Galat
|
10
|
0,870567
|
0,087057
|
|
40
|
|||||
|
Total
|
17
|
20,32945
|
|
41
|
||||||
|
Keterangan
:
|
42
|
|||||||||
|
KK
(%) = 6.90%
|
43
|
|||||||||
|
44
|
||||||||||
|
F
Hitung > Ftabel =
|
**
|
Berpengaruh
Sangat Nyata
|
45
|
|||||||
|
F
40
|
=IF(E40<G40,"tn",IF(E40<H40,"*",IF(E40>H40,"**")))
|
46
|
||||||||
|
47
|
||||||||||
|
Kesimpulan
: Parameter Genotipe Berpengaruh Sangat Nyata Terhadap Diameter Buah Melon (Cucumis melo L)
|
48
|
|||||||||
0 comments:
Post a Comment