Latihan Excel Anova 27 Maret 2019.xlsx

ULANG 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

PUPUK 1 2 3 4 5 1 2 3 4 5 1 2 3 4 5

1 1 1 1 1 2 2 2 2 2 3 3 3 3 3

PRODUKSI 16 19 20 23 17 24 30 19 22 20 19 25 18 23 20 315

jk kuadrat FK JK TOTAL 6795 jk perlaku 33275 6655

6615

PUPUK 1 PUPUK 2 PUPUK 3 16 24 19 19 30 25 20 19 18 23 22 23 17 20 20 95 115 105

Anova: Single Factor SUMMARY Groups Count Column 1 5 Column 2 5 Column 3 5

ANOVA Source of VariationSS Between G 40 Within Gro 140 Total

180

Sum

Average 95 19 115 23 105 21

df

MS 2 20 12 11.66667 14

db Variance 7.5 19 8.5

F P-value F crit 1.7142857143 0.221377 3.885294

perlakuan galat total

Jk 2 12 14

KT

Fhitung 40 20 1.714286 140 11.66667 180

ftabel 3.885294