Weighted Questionnaire Calculation in Performance Template
We have a Performance Document that includes a questionnaire with 4 sections, and each section contains a different number of questions. We need to calculate the Overall Summary Rating based on the weighted average score of each questionnaire section.
Example:
Section | Number of Questions | Weightage |
|---|---|---|
Section A | 10 | 60% |
Section B | 5 | 15% |
Section C | 3 | 15% |
Section D | 2 | 10% |
The requirement is to:
- Calculate the average score for each questionnaire section based on the responses to the questions within that section.
- Apply the configured weightage to each section average.
- Calculate the final score using the weighted section averages.
Formula Example:
Final Score =
(Section A Average × 60%) +
(Section B Average × 15%) +
Tagged:
0