Run2 excel stats
[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-statsAssembled 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
Using Excel's statistical functions with rounding and percentage scaling in openpyxl.
SKILL.md
1.0 KB, as published. Nobody here has run it
Statistical Calculations with Rounding
Common Excel statistical functions used for data analysis:
- Min/Max:
=MIN(range),=MAX(range) - Median/Mean:
=MEDIAN(range),=AVERAGE(range) - Percentiles: Use
=PERCENTILE(range, alpha)for broad compatibility (where alpha is 0.25 for 25th, etc.).
Rounding and Scaling to Percentages
If the requirement is to display percentages as whole numbers with one decimal place (e.g., 12.3 rather than 0.123):
- Calculate the ratio:
(Numerator / Denominator). - Multiply by 100:
ratio * 100. - Round the result:
ROUND(result, 1).
=ROUND((Exports - Imports) / GDP * 100, 1)
Consistent Formula Application
- Ensure statistics are computed over the correct data range (e.g.,
H35:H40for each year). - If statistics themselves are percentages, ensure they are also rounded as per user instructions.
=ROUND(AVERAGE(H35:H40), 1)