agentsclimarketplace
Sign in

Run1 excel weighted average sumproduct

Skill cxcscmu/SkillLearnBench/skills/b3-teacher-feedback-gemini-3-flash-preview/weighted-gdp-calculation/run1_excel-weighted-average-sumproduct

Calculate a weighted mean using the SUMPRODUCT and SUM functions.From its SKILL.md

Install
npx -y skills add cxcscmu/SkillLearnBench --skill run1_excel-weighted-average-sumproduct

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, 136 tokens by cl100k_base, as published. Nobody here has run it

A weighted average is calculated by multiplying each value by its corresponding weight, summing those products, and dividing by the total sum of the weights.

Formula structure: =SUMPRODUCT(values_range, weights_range) / SUM(weights_range)

  • values_range: The data points (e.g., Net Exports as % of GDP for each country).
  • weights_range: The values used for weighting (typically GDP or Population).

Example Application: If you need the weighted mean of net exports (column A) weighted by GDP (column B): =SUMPRODUCT(A1:A6, B1:B6) / SUM(B1:B6)

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.