Hi,

I have the following format of the arrival data to center. I need to plot the frequency graph to compare it with the Poisson graph which I have done it. What is the graph should I plot to compare it with the Poisson distribution? and how can I do that?

*the tasks to the center more than 3000 but I have put below an example.

04/03/2013 13:41

04/03/2013 13:49

04/03/2013 13:50

04/03/2013 13:53

04/03/2013 14:02

04/03/2013 14:07

04/03/2013 14:10

04/03/2013 14:18

04/03/2013 14:27

04/03/2013 14:31

04/03/2013 14:52

04/03/2013 14:52

04/03/2013 15:06

06/03/2013 08:43

06/03/2013 09:20

06/03/2013 09:32

06/03/2013 09:52

06/03/2013 09:56

06/03/2013 10:30

06/03/2013 10:58

06/03/2013 11:09

06/03/2013 11:17

06/03/2013 11:21

06/03/2013 11:32

06/03/2013 11:55

06/03/2013 12:03

06/03/2013 12:10

06/03/2013 12:19

06/03/2013 12:24

06/03/2013 12:26

06/03/2013 12:39

06/03/2013 12:45

06/03/2013 12:46

1. Put an event counter in the first column.

2. Put your data in the second column.

3. Calculate the interarrival times in the third column.

4. Use

CopyandPaste Special Valuesto copy the IntArr values in a new columm.5. Sort this column in descending order.

6. Calculate the Average Interarrival Time for your data.

7. Generate an Ideal Poisson distribution based on the measured average.

8. Plot the Sorted and Ideal distributions on a log-log scatter plot.

You should get a straight line, as in the attached example.

Poisson-for-ExEx.pdf