tobrien
Flashlight Enthusiast
so I've got 113 surveys that have response options as such:
Poor
Fair
Adequate
Good
Excellent
there were four different questions where you could select a single option from above in each question.
What I want to do is, in essence, grade my department's effectiveness by assigning numbers like so to each response:
Poor: 0%
Fair: 25%
Adequate: 50%
Good: 75%
Excellent: 100%
From giving those descriptors a number, I want to be able to say, "hey the department averages a 90% (an A) if we give responses these values"
what Excel function(s) do I need? I want to have it graded (by traditional letter grades and percentages) to see how we're excelling (no pun intended) potentially in one aspect over another, etc.
I think I need a mix of IF and VLOOKUP, but I'm not entirely sure.
Thanks for any help guys!
edit: I do have the responses (e.g, how many people said "Excellent" for question 1) summed up in their own areas on a single sheet (the raw responses per survey are on a separate sheet), if it makes a difference
Poor
Fair
Adequate
Good
Excellent
there were four different questions where you could select a single option from above in each question.
What I want to do is, in essence, grade my department's effectiveness by assigning numbers like so to each response:
Poor: 0%
Fair: 25%
Adequate: 50%
Good: 75%
Excellent: 100%
From giving those descriptors a number, I want to be able to say, "hey the department averages a 90% (an A) if we give responses these values"
what Excel function(s) do I need? I want to have it graded (by traditional letter grades and percentages) to see how we're excelling (no pun intended) potentially in one aspect over another, etc.
I think I need a mix of IF and VLOOKUP, but I'm not entirely sure.
Thanks for any help guys!
edit: I do have the responses (e.g, how many people said "Excellent" for question 1) summed up in their own areas on a single sheet (the raw responses per survey are on a separate sheet), if it makes a difference