Excel statistics formulas
[COLM'26] SkillLearnBench is the first benchmark for evaluating continual learning methods that automatically generate agent skills.
npx -y skills add cxcscmu/SkillLearnBench --skill excel-statistics-formulasAssembled 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
Excel statistical functions (MIN, MAX, MEDIAN, AVERAGE, PERCENTILE, SUMPRODUCT) with ROUND.
SKILL.md
0.8 KB, as published. Nobody here has run it
Excel Statistical Formulas
Common Statistical Functions
=MIN(range)
=MAX(range)
=MEDIAN(range)
=AVERAGE(range)
=PERCENTILE(range, k) -- k is 0 to 1 (e.g., 0.25 for 25th percentile)
ROUND Function
=ROUND(value, num_digits) -- e.g., ROUND(12.345, 1) = 12.3
SUMPRODUCT for Weighted Mean
GDP-weighted mean of net exports as % of GDP:
=ROUND(SUMPRODUCT(Exports - Imports) / SUM(GDP) * 100, 1)
This works because:
- weighted_mean = Σ(gdp_i × (exp_i - imp_i)/gdp_i) / Σ(gdp_i) × 100
- Simplifies to: Σ(exp_i - imp_i) / Σ(gdp_i) × 100
- SUMPRODUCT handles the element-wise subtraction and summation