Run2 excel weighted mean
[COLM'26] SkillLearnBench is the first benchmark for evaluating continual learning methods that automatically generate agent skills.
npx -y skills add cxcscmu/SkillLearnBench --skill run2_excel-weighted-meanAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
What its author says it does
Copied from the file, not written here
Understanding scaling and execution of weighted means using SUMPRODUCT.
SKILL.md
0.8 KB, as published. Nobody here has run it
Weighted Means
A weighted mean accounts for the varying importance of data points using a secondary vector of weights (e.g., GDP).
The SUMPRODUCT Formula
=SUMPRODUCT(values, weights) / SUM(weights)
- Values: e.g., Net Exports as % of GDP (
H35:H40). - Weights: e.g., Total GDP (
H26:H31).
Scaling Preservation
If your input values are already scaled by 100 (e.g., 12.3 representing 12.3%), the result of the weighted mean will automatically preserve this scale. No secondary multiplication by 100 is needed.
=ROUND(SUMPRODUCT(H35:H40, H26:H31) / SUM(H26:H31), 1)
This calculates the aggregated weighted mean percentage directly and rounds it to the nearest single decimal.