I asked 9 people to rank the following steps of a supply chain process (planning, Sourcing, Production, Inventory Management, Logistics) from “Most Seamless” to “Least Seamless.”
Now that their answers are in an excel sheet and I am trying to find the weighted average of their answers.
I read a bit about Ranked Choice voting, but I don’t want the output to be “X is the highest voted”.
I want the output to be something like Inventory management holds a weight of 76 and product has a weight of 56, etc and then sort them from highest to lowest.
I split the rankings between 100 to 0 and I counted the number of times each step occurs per rank.
Then I multiplied the number of times the step occurs by each rank. Finally, I added the product of each rank and divided by 9
Here is what I did so far:
I was wondering if there was a better way to do this ranking and if there was a function an excel to make this easier.
