frequency table for continuous variable

omarfdawood · Nov 22, 2005

Dear Friends.

Can we use excel to create a frequency table for a continuous variable?
I using excel 2000.

Any help?

Oamr Farook
[email protected]

Jerry W. Lewis · Nov 22, 2005

Yes
=COUNTIF(range,"<3")-COUNTIF(range,"<1")
will return the number of values in the range that satisfy 1<=x<3.

Jerry