Excel - Statistics help

[rhysduck]

Hi,
Can someone please help in what I could get, statistics wise, out of this spreadsheet?

Spoiler

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

 

[gregorius]

Whenever you're faced with a heap of numbers, the first thing you should do is to ask "What is the question that I want to answer?". The statistical analysis will follow from the answer to this question.

So, what are you attempting to do?

 

[rhysduck]

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

 

[Grrrrr]

I think your question is impossibly vague to answer. Can you upload a spreadsheet (or screenshot) with the data so we can actually see what you have?