Run2 excel statistics
Calculating and rounding summary statistics like percentiles in Excel.From its SKILL.md
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.
SKILL.md
0.9 KB, 198 tokens by cl100k_base, 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.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.