Frequency

[Guest]

I have 22 different populations taken from a poll. I want to calculate the
frequencies by using the less than or equal to function. For example the
number of people that live in of 200,000 or less, then 100,000 or less and
down the line. I only have one column, that of the different populations.

 

[Guest]

Do you want the frequency or the count? Your descriptions sounds like you're
looking for the count. Assume the data are in A1:A100.
=COUNTIF(A1:A100,"<=200000") will count the number of populations less than
or equal to 200,000 etc.

If you're looking to create a frequency distribution, then see here for info
on the FREQUENCY function: http://www.meadinkent.co.uk/xlfreq.htm

Dave

 

[Guest]

I want to know how to show the number of people that live in populations
between 200,000 and 150,000. An example being, there are 5 people from
populations between 200,000 and 150,000. I want to reflect that in order to
create a histogram.
Sorry if its not making sense, I am new to this. I appreciate any help.

 

[Bob Phillips]

have you looked at FREQUENCY in help. It seems to do what you want.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[T. Valko]

Assume your raw data is in the range A1:A100. You have the bins in the range
B1:B10.

Goto the menu Tools>Data Analysis>Histogram>OK

Fill in the info

Biff