agentsclimarketplace
Sign in

Weighted mean calculation

Skill cxcscmu/SkillLearnBench/skills/b4-skill-creator-gemini-3.1-flash-lite-preview/weighted-gdp-calculation/weighted-mean-calculation

How to calculate weighted means in Excel using SUMPRODUCT. Use this skill when calculating the weighted average for a group (e.g., GCC Countries) by multiplying values by their corresponding weights (e.g., GDP).From its SKILL.md

Install
npx -y skills add cxcscmu/SkillLearnBench --skill weighted-mean-calculation

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

0.7 KB, 107 tokens by cl100k_base, as published. Nobody here has run it

Weighted Mean Calculation: SUMPRODUCT

To calculate the weighted mean:

=SUMPRODUCT(values_range, weights_range) / SUM(weights_range)

  • values_range: The data points to be weighted (e.g., Net Exports as % of GDP).
  • weights_range: The values used as weights (e.g., GDP in current prices).

Ensure both ranges are of the same size. If the desired result is a percentage, format the cell appropriately or multiply the final formula by 100 to meet reporting requirements.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.