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!)