Excel analysis
Techniques for statistical analysis in Excel including weighted means, percentiles, and rounding.From its SKILL.md
npx -y skills add cxcscmu/SkillLearnBench --skill excel-analysisAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
0.7 KB, 156 tokens by cl100k_base, as published. Nobody here has run it
Weighted Mean
Use SUMPRODUCT to calculate the weighted mean.
Formula: =SUMPRODUCT(values_array, weights_array) / SUM(weights_array)
Ensure the result is multiplied by 100 if the values are proportions.
Percentiles
Use the PERCENTILE.INC function.
Formula: =PERCENTILE.INC(array, k) where k is 0.25 for 25th percentile and 0.75 for 75th.
Rounding
Use the ROUND function to limit decimal places.
Formula: =ROUND(value, 1)
If the value is a percentage in proportion format (e.g., 0.123), use =ROUND(value * 100, 1).
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.