Excel - Statistics help

Soldato
Joined
25 Oct 2009
Posts
6,706
Location
Caerphilly
Hi,
Can someone please help in what I could get, statistics wise, out of this spreadsheet?
Rating






Question 1 2 3 4 5 6 7 8 9 10 1 0 2 1 1 3 5 10 25 17 34 2 1 2 3 0 5 4 11 16 20 34 3 1 1 1 1 0 2 4 12 18 56 4 2 2 2 0 2 3 10 16 15 42 5 1 3 2 3 2 2 12 18 19 33 6 2 0 2 1 2 5 7 13 22 35 7 COMMENTS ONLY 8 1 1 0 0 0 4 5 12 22 48 9 2 1 1 0 0 2 4 12 18 48 10 COMMENTS ONLY 11 3 0 0 0 0 1 2 7 15 60 12 2 1 0 0 0 1 3 8 16 61 13 COMMENTS ONLY
It's a list of question (1-13) from a questionnaire and the ratings for each questions (1-10). The numbers indicate how many people gave each rating for the particular question.
I've not got much so far, only total number of people for each question and the average of the ratings for each question (=AVERAGE(B5:K5) where B5 is the cell with 0 in for Q1:R1 and K5 is the cell with 34 in for Q1:R10)

Any help greatly appreicated, IE what other statistics could I get out of these numbers?
Thanks :)
 
There is no question though.

I was just hoping to be able to get some simple statistics out of the numbers.. like average rating per question, that sort of thing.

Edit: Just noticed the numbers in the OP are all screwed up :(
 
Back
Top Bottom