Hi,
I am asking respondents to put a list in order of preference. How do I weight each item in the list based on it's place.
For example, "List these five items in order of highest priority to lowest priority". The results will appear in two cells as follows:
Participant #1 - 12345
Participant #2 - 54321
Participant #3 - 32154
How do I give more importance to the "5" given by Participant# 2 than I do to the "5" given by Participant #1
Thank you
Last edited by Qwizdom; 04-22-2013 at 02:24 PM.
Assuming this the data is all in one cell starting in A2... use a series of LEFT() RIGHT() functions to pull out the individual scores as below:
First Ranking
=LEFT(RIGHT(A2,5),1)
Second Ranking
=LEFT(RIGHT(A2,4),1)
etc...
Then once you have the rankings isolated you can apply formulas to them.
Hope that helps.
Thanks. I'm still not sure which formula to use. Weighted Average does not work because I don't just want to weight the response of "5". But I also need to weigh the position that the "5" fell into. In the example above, for Participant #1, "5" was least important. For Participant #2 is was most important. How do I find out how option #5 ranked overall among all participants' choices?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks