Using tableau to compute entropy from a estimated probability distribution.

Question

I have the following situation: after sniffing multiple packets from a WLAN, I consider the random variable X with values given by the protocol number and probabilities given by the number of packets with that protocol number over the total of the packets (that is, I poorly estimate the probability that a given protocol occurs on the network).

Answer 1

To find the estimated probability distribution using TABLEAU. You need to replace SUM with WINDOW_SUM to create a table calculation and set "compute using" for that calculation to your protocol number field

And to get more information and do experiments with the datasets. If you want to understand more, learn how table calculations work. In a nutshell, the sum() calculation is performed by the outside data source or database in response to the query sent by Tableau. Then the aggregated query result is delivered to Tableau as a summary table. Table calcs such as Window_Sum() operate on that summary table.

The "compute using" directive instructs Tableau on how to partition the report table; that is to define the scope of the window used to compute Window_Sum()