How do I create a weighted ranking in excel?

by user256448   Last Updated August 14, 2019 19:19 PM

I'm working in Excel on data related to hotels. Responses need to be weighted based the percent of total rooms in the sample. (E.g. Hotel A has 12 rooms, sample is 100 rooms spread over x hotels. Hotel A's responses are weighted at 12%.)

Respondents were asked to rank their priorities 1-6, with 1 being their top priority. (There were 6 possible categories.)

I was able to figure out how to do a straight ranking (no weight) using excel. The problem I'm having is weighting the responses. In other words, I want Hotel A's ranking to have an impact of 12% rather than 1/x.

(I'm not a statistician, nor am I an expert in excel...Please help!)

Tags : ranking excel


Related Questions



Power rank/Composite score help needed

Updated November 24, 2018 06:19 AM

Ranking based on number & production of referrals

Updated October 18, 2018 13:19 PM

GRG non-linear algorithm

Updated February 25, 2016 02:08 AM