contoh perhitungan geometric mean
TRANSCRIPT
Kasus Pertumbuhan Rata - Rata Pertumb. per th2005 2006 2007 2008 A B C GM Manual
1 -50% 100% -50% 100% 25% Err:502 0% 71% Err:5022 -20% 30% -20% 10% 0% Err:502 -2% 19% Err:5023 30% 20% -40% -10% 0% Err:502 -4% 22%4 20% 30% 40% 50% 35% 33% 35% 33%5 10% 10% 10% 10% 10% 10% 10% 10%6 50% 40% 30% 20% 35% 33% 35% 33%7 10% 30% 20% 40% 25% 22% 24% 22%8 10% 60% -50% 30% 12% Err:502 3% #NUM!
Rumus A Rata - rata aritmetikaRumus B Excel Command GeomeanRumus C Levine PPT