Scoring or Rating
From a previous post. Thought this example might be easier to understand.
I have an Evaluation Sheet that has four cells of different ratings each represented in a cell per rating: i.e.
Cell 1 represents an Excelent rating
Cell 2 represents a Good rating
Cell 3 represents a Fair rating
Cell 4 represents an Unsat rating
There are 7 total people rating on the Evaluation Sheet
I need to average the scores from the four cells to another cell. The total scores add to 7.
Example 1:
(Excelent) Cell 1 = 2
(Good) Cell 2 = 1
(Fair) Cell 3 = 2
(Unsat) Cell 4 = 2
or
Example 2:
(Excelent) Cell 1 = 5
(Good) Cell 2 = 0
(Fair) Cell 3 = 2
(Unsat) Cell 4 = 0
How do I get the average score in Cell 5?
Please Help!
Thanks,
JamesZ
Last edited by JamesZ : June 20th, 2010 at 04:53 AM.
|