Build an operational review with the right denominator
Your goal: Compare two legitimate averages for one selected population and base the review flag on the agreed case-weighted metric.
Full task requirements
Fill G5:G7 for the region/state in G2:G3. G5 is the unweighted mean of services with positive case counts; G6 is the case-weighted mean, with explicit empty/negative-weight states; G7 compares numeric G6 with target G4 or carries its text state.
Equal-service and case-weighted judgments differChoose the report population
- Region
- East (G2)
- State
- Delivered (G3)
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 |
Step 1 of 3
Choose the report population
How the Excel rule works
Match region AND state before calculating either metric. A negative count outside this population must not affect this report.
Inspect selected records
No records selected yet.