Excel Kelompok 17-1.xlsx

  • Uploaded by: Irfan Amaterasu
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Excel Kelompok 17-1.xlsx as PDF for free.

More details

  • Words: 466
  • Pages: 8
perlakuan

I 1 0 1 2 2 0 1 2 1 10 1.11

P1F1 P1F2 P1F3 P2F1` P2F2 P2F3 P3F1 P3F2 P3F3 Total Rata-Rata

FK JKT JKK

JKP JKG

ulangan II 0 0 1 1 0 0 2 2 1 7 0.78

∑ Yij² t*r 21.33 ∑ Yij ² - FK 14.67 2 ∑Yj t 0.67 2 ∑Yi r 8.67 JKT -JKK - JKP 5.33

III 0 0 1 1 0 1 2 1 1 7 0.78

⁻ FK

⁻ FK

Tabel Annova

sumber Kelompok Perlakuan Galat Total

dB

Jumlah Kuadrat Kuadrat Tengah 2 8 16 26

0.67 8.67 5.33 14.67 kesimpulan

0.33 1.08 0.33

f hitung H0 Ditolak

BNT(0,05)

=

t (0.05/2) (16) x √((2x KTG)/r) 1.00

BNT (0,01)

=

t (0.01/2) (16) x √((2xKTG)/r) 1.38

Nilai Tengah

P1F1 P1F2 P1F3 P2F1 P2F2 P2F3 P3F1 P3F2 P3F3

0.33 0 1 1.33 0.67 0.33 1.67 1.67 1

Perlakuan dan nilai tengah 0 0.33 0.33 0.67 1 1 1.33 1.67 1.67 BNT 0,05 1.00

P1F2 0 -

P1F1 0.33 0.33 -

P2F3 0.33 0.33 0 -

a

a b

a b c

a

ab

abc

Perlakuan dan Nilai Tengah P2F2 0.67 0.67 0.33 0.33 -

a b c d

abcd

BNT 1.38

a

a

a

a

b

a

ab

b c

abc

b c d

abcd

Total

Rata-rata

1 0 3 4 2 1 5 5 3 24 2.67

0.33 0 1 1.33 0.67 0.33 1.67 1.67 1 8 0.89

t r

9 3

JKK dBk 0.33 JKP KTP dBP 1.08 JKG KTG dBgalat 0.33 F Hitung K KTK KTG KTK

F hitung 1 3.25

>

F Tabel 5% 3.63 2.59

Ftabel(5%)

1% 6.23 3.89

1

F Hitung P

KTP KTG 3.25

F Tabel K F Tabel P

KK

kuan dan Nilai Tengah P1F3 1 1 0.67 0.67 0.33 -

P3F3 1 1 0.67 0.67 0.33 0 -

P2F1 1.33 1.33 1 1 0.67 0.33 0.33 -

P3F1 1.67 1.67 1.33 1.33 1 0.67 0.67 0.33 -

bcde

b c d e f

bcdef

a

a

d e f g

defg

a

e f g h efgh

3.63 6.23 2.59 3.89

64.95

P3F2 1.67 1.67 1.33 1.33 1 0.67 0.67 0.33 0 -

b c d e

0.05 0.01 0.05 0.01

e f g h efgh

P1F2 P1F1 P2F3 P2F2 P1F3 P3F3 P2F1 P3F1 P3F2

0.05 a ab abc abcd bcde bcdef defg efgh efgh

b c d e

abcde

b c d e f

abcdef

b c d e f g

b c d e f g h

abcdefg bcdefgh

b c d e f g h bcdefgh

Kesimpulan :

Perlakuan P3F1 dan P3F2 berbeda san dengan P1F3, P3F3, dan P2F1

0.01 a ab abc abcd abcde abcdef abcdefg bcdefgh bcdefgh

n P3F1 dan P3F2 berbeda sangat nyata dengan yang lain kecuali 1F3, P3F3, dan P2F1

Related Documents

Excel
November 2019 4
Excel
November 2019 5
Excel
October 2019 18
Excel
May 2020 7

More Documents from ""