Run1 excel weighted average sumproduct
[COLM'26] SkillLearnBench is the first benchmark for evaluating continual learning methods that automatically generate agent skills.
npx -y skills add cxcscmu/SkillLearnBench --skill run1_excel-weighted-average-sumproductAssembled 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
Calculate a weighted mean using the SUMPRODUCT and SUM functions.
SKILL.md
0.7 KB, as published. Nobody here has run it
A weighted average is calculated by multiplying each value by its corresponding weight, summing those products, and dividing by the total sum of the weights.
Formula structure:
=SUMPRODUCT(values_range, weights_range) / SUM(weights_range)
- values_range: The data points (e.g., Net Exports as % of GDP for each country).
- weights_range: The values used for weighting (typically GDP or Population).
Example Application:
If you need the weighted mean of net exports (column A) weighted by GDP (column B):
=SUMPRODUCT(A1:A6, B1:B6) / SUM(B1:B6)