Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default frequency table for continuous variable

Dear Friends.

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

Any help?

Oamr Farook


  #2   Report Post  
Posted to microsoft.public.excel.misc
Jerry W. Lewis
 
Posts: n/a
Default frequency table for continuous variable

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

Jerry

wrote:

Dear Friends.

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

Any help?

Oamr Farook




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Input cell reference is not valid (One Variable Data Table) Dottore Excel Worksheet Functions 9 September 1st 05 03:05 PM
Input Cell in One variable data table Dottore Magistrale Excel Worksheet Functions 0 August 30th 05 06:25 PM
DATA > TABLE -- 2 variable data tables? efarhat Excel Discussion (Misc queries) 0 August 24th 05 07:29 PM
How do I create a one variable data table? Prelll91 Excel Discussion (Misc queries) 1 February 27th 05 07:48 PM
Finding intersection of row and column (both variable) in table RangerAl Excel Worksheet Functions 8 January 1st 05 01:28 AM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"