I have a set of eight principles and have been tasked with working out what the top five preferred principles are. In a series of interviews, participants were asked to rank their top five, with 1 being the most preferred, and 5 being the least preferred.
We had asked participants to leave the remaining three principles blank, however, several participants misread the instructions, and ranked all of the principles, (i.e., gave all eight principles a score between 1-5). This is an example of the kind of data I am working with:
I want to work out what the top five principles are, giving more weight to where participants have ranked the principle as 1, and less to principles of 5. How would I do this? Is there a way I can do this in excel?