how to calculate information entropy in excel
2013-12-01azim58 - how to calculate information entropy in excel
- Paste the numbers you want to calculate the entropy of into a column in
- Copy this column into another column and then choose data->remove
- Use the countif function for each of the duplicate removed column values
=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"