EXCEL 2007

Take the following actions:-

1.

A1:-

Rating

A2 to A12:-

0 1 2 3 4 5 6 7 8 9 10

2. Column B

B1:-

Number Of Responses

B2 to B12:-

0 0 0 1 2 0 0 2 1 0 2

B13:-

=SUM(B2:B12)

The above returns a total of 8.

3. Column C

C1:-

%age Of Responses Received

C2 to C12:-

=(B2/$B$13)*100
=(B3/$B$13)*100
=(B4/$B$13)*100
=(B5/$B$13)*100
=(B6/$B$13)*100
=(B7/$B$13)*100
=(B8/$B$13)*100
=(B9/$B$13)*100
=(B10/$B$13)*100
=(B11/$B$13)*100
=(B12/$B$13)*100

C13:-

=SUM(C2:C12)

The above returns 100.

If the above is what you want please hit Yes.

Thanks.














"P. Hayes" wrote:

I have eight responses to an evaluation that scored experience from 0 (worst)
to 10 (best). From the results posted below, I need to compute % of
responses received for each 0 -10 score received. I also need to compute one
overall combined % for the evaluations received.

Rating Score # of Responses
0 0
1 0
2 0
3 1
4 2
5 0
6 0
7 2
8 1
9 0
10 2

An overall score of 24% was printed on the report that I received this data
on, but I can't seem to figure out how this overall score was calculated.

Any help anyone can provide is greatly appreciated.

Pam