Excel Statistical Formulas
SkillFiles & storageExcel statistical functions (MIN, MAX, MEDIAN, AVERAGE, PERCENTILE, SUMPRODUCT) with ROUND.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the Excel Statistical Formulas skill
What this skill tells your AI
The instructions your AI receives, as published by cxcscmu/skilllearnbench in skills/b1-one-shot-claude-opus-4-6/weighted-gdp-calculation/excel-statistics-formulas/SKILL.md and read by ahel’s review.
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
Signals
- GitHub stars
- 83
- Forks
- 5
- Last commit
- Jul 2026
Advanced
- Catalog kind
- skill
- Gateway key
excel-statistics-formulas- Source
- github.com/cxcscmu/skilllearnbench