how+to+calculate+information+entropy+in+excel

-Paste the numbers you want to calculate the entropy of into a column in excel. -Copy this column into another column and then choose data->remove duplicates -Use the countif function for each of the duplicate removed column values to count the number of times each item occurs in the original column like =COUNTIF($A$1:$A$13,E1) -Calculate p(x)*ln(p(x)) for each count -sum all of the p(x)*ln(p(x)) values -take the negative value of the sum for the final entropy value

example entropy excel file here "F:\kurt\storage\CIM Research Folder\DR\2013\5-29-13\entropy\test entropy calculation.xlsx"