How do I compare a weighted completion rate with a simple average of team rates?
Completed records must be a subset of eligible records. Empty teams are excluded from the unweighted average.
Open Metric Rollup LabTry the worked example
These are the example inputs from Metric Rollup Lab. Replace them in the tool to run your own case.
| Team | Eligible | Complete |
|---|---|---|
| North | 90 | 54 |
| South | 10 | 10 |
Example result
64% pooled · 80% team mean
Who uses this?
Business operations analyst. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Compare a weighted completion rate with a simple average of team rates. The episode follows a service-business audit and the points where a booking journey can be measured. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video