Bin Array--Frequency

  • Thread starter Thread starter Excel User
  • Start date Start date
E

Excel User

I want to set a bin array for only five numbers. I have entered the results
of a survey asks people to answer on a scale of 1 to 5. I want to find out
how many 3's were provided for one question, 4's for that same question and
so on throughout the survey. Can you create a bin with only 5 numbers or is
this not a large enough interval? I am having trouble with this.
 
Excel User said:
I want to set a bin array for only five numbers. I have entered the results
of a survey asks people to answer on a scale of 1 to 5. I want to find out
how many 3's were provided for one question, 4's for that same question and
so on throughout the survey. Can you create a bin with only 5 numbers or is
this not a large enough interval? I am having trouble with this.
Click to expand...


Assuming that B2:B10 contains the results for your first question, let
D2:D6 contain 1, 2, 3, 4, and 5. Then try the following...

1) Select/highlight E2:E6

2) With E2:E6 selected/highlighted, enter the following formula...

=FREQUENCY(B2:B10,D2:D6)

3) Then, instead of confirming with just ENTER, confirm with
CONTROL+SHIFT+ENTER. Excel will automatically place curly braces {...}
around the formula.

Alternatively, you could use COUNTIF...

E2, copied down:

=COUNTIF($B$2:$B$10,D2)

Adjust the range, accordingly.
 
Back
Top