frequency table for continuous variable

O

omarfdawood

Dear Friends.

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

Any help?

Oamr Farook
(e-mail address removed)
 
J

Jerry W. Lewis

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

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

frequency table 4
Excel Inverse Fft 0
How to apply frequency? 1
Multi-demensional frequency distribution 4
How to reference variable range? 8
make continuous list of days of week without Sunday 3
word frequency counting 16
How to assign "" for any error on frequency analysis? 4

Top