LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Calculate % from list of scores or ratings

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the formula to calculate tenpin bowling scores in excel? BrianEBest Excel Discussion (Misc queries) 1 April 14th 09 09:09 AM
Calculate average of ratings as a function of length rodeo Excel Worksheet Functions 2 November 2nd 07 12:44 PM
How do I average 4 of the last 8 golf scores to calculate a handic Handicapper1 Excel Worksheet Functions 3 August 20th 06 07:43 PM
Can Excel list order according to Total scores? PaulT Excel Worksheet Functions 2 March 25th 06 11:54 AM
Using functions to calculate multiple scores according to their level of difficulty cheski Excel Worksheet Functions 6 March 13th 05 08:32 PM


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"