agentsclimarketplace
Sign in

Run2 excel weighted mean

Skill cxcscmu/SkillLearnBench/skills/b2-self-feedback-gemini-3.1-pro-preview/weighted-gdp-calculation/run2_excel-weighted-mean

Understanding scaling and execution of weighted means using SUMPRODUCT.From its SKILL.md

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

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

SKILL.md

0.8 KB, 191 tokens by cl100k_base, as published. Nobody here has run it

Weighted Means

A weighted mean accounts for the varying importance of data points using a secondary vector of weights (e.g., GDP).

The SUMPRODUCT Formula

=SUMPRODUCT(values, weights) / SUM(weights)
  • Values: e.g., Net Exports as % of GDP (H35:H40).
  • Weights: e.g., Total GDP (H26:H31).

Scaling Preservation

If your input values are already scaled by 100 (e.g., 12.3 representing 12.3%), the result of the weighted mean will automatically preserve this scale. No secondary multiplication by 100 is needed.

=ROUND(SUMPRODUCT(H35:H40, H26:H31) / SUM(H26:H31), 1)

This calculates the aggregated weighted mean percentage directly and rounds it to the nearest single decimal.

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.