Run2 excel statistics
[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-statisticsAssembled 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
Calculating and rounding summary statistics like percentiles in Excel.
SKILL.md
0.9 KB, as published. Nobody here has run it
Statistical Metrics in Excel
Excel provides built-in functions for summarizing data sets. When formatting is restricted, or exact value representation is required, use ROUND.
Key Functions
- Min / Max / Median:
=MIN(range),=MAX(range),=MEDIAN(range) - Mean:
=AVERAGE(range) - Percentiles: The safest function across all Excel versions and LibreOffice is
=PERCENTILE(range, k)wherekis the fraction (e.g.,0.25or0.75).
Applying Hard Rounding
To force a calculation to a specific decimal place explicitly (not just visually formatted), wrap the entire calculation in ROUND:
=ROUND(PERCENTILE(H35:H40, 0.25), 1)
This ensures the stored value is accurately rounded to one decimal place, e.g., 12.3.