I'm not sure the correct term for my problem is weighted average. But let me explain.
I've conducted a survey where participants answer on a scale betweeen $1$ and $7$. The questions fall into three categories. In category one & two there are $12$ questions, and in category three there are four questions.
Lets assume there are nine participants and the distribution of the answers are $579$ points in category one. $450$ points in category two and $87$ in category three.
I want to calculate/show the answer distribution of each category (compared to the total points), taking into account that category three is three times smaller.
I hope I'm making sense.