The real wordsTheory
Entropy
EntropyA measure of impurity in bits. For a node whose classes have proportions p1, p2, ..., entropy = minus the sum of p_i times log base 2 of p_i.
Entropy = -p1 log2(p1) - p2 log2(p2)
Excel: =-I4*LOG(I4,2) - I5*LOG(I5,2)
Read the scale. A node all of one class has entropy 0: perfectly pure, nothing left to learn. A node split exactly 50/50 has entropy 1: maximally impure. Everything else lies between.