I was hoping to get some help please with understanding the weighted percentage in a word frequency query.
I am unsure how the percentage is calculated as there seem to be some inconsistencies with my results. For example, a word may have a lower percentage than a word with a lower count, i.e. the count and weighted percentage do not align, e.g. "rainfall" has a count of 22 and weighted percentage of 0.32 while "action" has a count of 27 and a weighted percentage of 0.30. I'm not sure if it has something to do with similar word groupings? I have attached my results table to show the numbers I am referring to.
Any help to explain how the weighted percentage is calculated and how best to interpret the result would be really appreciated.