Not it's not an estimation of data.

I'm compiling results from a staff survey. Each of the subgroups are the "general causes" i.e. material, methods, measurements, equipment, environment, and people (cause and effect). From those general subgroups the results are then further catagorized by department. For example, a subgroup is People/Customer Service, then People/Warehouse, then equipment/warehouse, etc.

The method of grading importance was from a practice called Nominal Prioritization where the team of supervisors and senior managers each gave a grade (or priority) beside each response question per subgroup. The grade logic, applied to each response, from the survey was, the higher the number assigned to a response the more priority is was to that manager. The problem with this grading is that each subgroup had a different # of responses from the survey...therefore one subgroup had 3 responses where the highest grading for a response would be 3 and another subgroup has 14 with the highest grading per response to be 14. Since the highest priority grading in one could go as high as 14 and the other could only go to 3, I want to "weight" the subgroup with only 3 so that it had the same ranking to the total of all subgroups as the one with 14 so that I can sort all responses by the "weighted" priority # to the total of all responses.

If this sounds like a nightmare to explain I could email you the excel file for a quick peek if you want.....