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.
--
blackhawk

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Blackhawk.34" wrote:

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.
--
blackhawk

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.
--
blackhawk


"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Blackhawk.34" wrote:

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.
--
blackhawk

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)



"Blackhawk.34" wrote in message
...
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.
--
blackhawk

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

Goto the menu ToolsData AnalysisHistogramOK

Fill in the info

Biff

"Blackhawk.34" wrote in message
...
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.
--
blackhawk


"Dave F" wrote:

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Blackhawk.34" wrote:

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.
--
blackhawk