Home
News
Feed
search engine
by
freefind
advanced
how to calculate information entropy in excel
2013-12-01
azim58 - 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"
azim58wiki: