Hi,
I was hoping someone could help me with this particular statistics+excel problem that I cannot solve, or, at least need some confirmation that I am solving it correctly...
MY DILEMMA: Let's say I am asking people to choose their favorite letter(s) ranging from a-vvv (1-100). I ask 9 people to choose their favorites, but they can't choose more than 100 #'s (obviously since a-vvv represents 100 letters). Once I gather the information, the only way I know how to create the proper order is to AVERAGE the data by inputting zero into the fields/letters that were not chosen (since no one chose all 100 letters). My question is... HOW DO I PROPERLY ORDER THE "LETTERS" FROM MOST TO LEAST POPULAR BASED ON THE SUBMISSIONS??? I realize this is a statistics problem, but I'm hoping something efficient can be done in excel.
I've also attached the working excel file to use as a working document. Feel free to PM if you would like to attach an excel file.
Thanks in advance everyone!
-Ryan
Bookmarks