You can use the Frequency function within Excel in Microsoft Office ... From that calculation you can then create a graph which shows the frequency distribution of the data you've collected.

2) Determine the probability for each outcome: Divide the number of favorable events (i.e., the specific outcome you’re interested in) by the total number of events. 3) Create your distribution table ...