News1 min ago
counting frequencies from an excel data sheet
8 Answers
hello,
is anyone any good with excel. if so do you know how I can count frequencies from it. I have a data sheet with individual people score, which were either 0,1,2, or 3. I want to count the number of people who scored 0, the number who scored 2, etc. It would be nice to have it in a chart but just a table would do. hope that makes sense. basically I just want to be able to look at it and say things like: most people scored 2 for this question..that sort of thing. Of course I could just physically count them up on a tally sheet but I'm sure there must be some quick and reliable way of doing it.
thanks
is anyone any good with excel. if so do you know how I can count frequencies from it. I have a data sheet with individual people score, which were either 0,1,2, or 3. I want to count the number of people who scored 0, the number who scored 2, etc. It would be nice to have it in a chart but just a table would do. hope that makes sense. basically I just want to be able to look at it and say things like: most people scored 2 for this question..that sort of thing. Of course I could just physically count them up on a tally sheet but I'm sure there must be some quick and reliable way of doing it.
thanks
Answers
Best Answer
No best answer has yet been selected by rabbitdrop. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.You can use the 'COUNTIF' function. Assuming that you have a column with numbers in it to reflect the scores you would go to an empty cell and type in the following:
=COUNTIF(beginning of range:end of range ,"number of word to count")
So if I had entered the scores in Row B, cell numbers 2 - 50, in order to calculate how many cells contained the value 1, I would type:
=COUNTIF(B2:B50,"1")
I'd then do the same in the next free cell, but replace the 1 with 2 etc
There's probably a more efficient way to do it but i'm not brilliant with excel.
Hope that's helpful
K
=COUNTIF(beginning of range:end of range ,"number of word to count")
So if I had entered the scores in Row B, cell numbers 2 - 50, in order to calculate how many cells contained the value 1, I would type:
=COUNTIF(B2:B50,"1")
I'd then do the same in the next free cell, but replace the 1 with 2 etc
There's probably a more efficient way to do it but i'm not brilliant with excel.
Hope that's helpful
K
katy thanks for your help. I tried and nothing happened. I'm sue it's me not following your instructions right. Could you clarify for me please. What I did is;
I went to an empty cell elsewhere on the spread sheet then typed in COUNTIF(D2:D70,"1")
Then I pressed enter and .... nothing happened!
the formula just stayed in the box
what did I do wrong
I went to an empty cell elsewhere on the spread sheet then typed in COUNTIF(D2:D70,"1")
Then I pressed enter and .... nothing happened!
the formula just stayed in the box
what did I do wrong
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.