1. In cell L2 type =if(the cell location of the first value in the list you are interested in.
2. Then type < or > and the value of interest for your empirical probability.
3. After the value type ,1,0). [Note: 1=success, 0=failure.]
4. Auto fill down until column L is as long as the column containing the variable in question.
5. In the G16 type =COUNTIF(L:L,1). [Note: this will count the number of successes.]
6. Determine the empirical probability:
   1. In H16 type =(G16/F16).