Contingency Table (possibly being constructed with Pivot-table)

[David_23]

Hi guys,

I have a set of data of the form

X Data , Y Data
x1 , y1
x2 , y2
...
xn , yn

now both X Data and Y Data are just continuous data points that both lie in the interval a<X Data,Y Data<b which I want to group into intervals of length say h, from this I want to calculate the count per interval furthermore a cumulative frequency.

Now doing this individually for say one lot of data (i.e. one column of data here say X Data) very easily using a Pivot Table. I.e. to get the results

X Data Frequency Cumulative Frequency
interval 1 f1 cf1
interval 2 f2 cf2
,... ... ...
interval m fm cfm


what I'm hoping to achieve is (here only with the frequencies)
Frequency of X Frequency of Y
interval 1 fx1 fy1
interval 2 fx2 fy2
.... .... ....
interval m fxm fym

Can this be done with a Pivot Table? and if not, how can I go about it?

Any guidance would be greatly appreciated,

David