Excel statistics formulas
Excel statistical functions (MIN, MAX, MEDIAN, AVERAGE, PERCENTILE, SUMPRODUCT) with ROUND.From its SKILL.md
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.
SKILL.md
0.8 KB, 218 tokens by cl100k_base, 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
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.