Run3 Weighted Mean using SUMPRODUCT
Calculate the weighted mean by multiplying Net Exports % by the corresponding GDP values and dividing by the total GDP.From its SKILL.md
npx -y skills add cxcscmu/SkillLearnBench --skill run3_Weighted-Mean-using-SUMPRODUCTAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
0.8 KB, 152 tokens by cl100k_base, as published. Nobody here has run it
- Define the weighted mean formula:
=ROUND(SUMPRODUCT(NetExportsRange, GDPRange) / SUM(GDPRange), 1). - Ensure
NetExportsRangeandGDPRangehave the exact same dimensions and orientation corresponding to the GCC countries for the given year. - Verify that the calculation multiplies by 100 if the source data is in decimal format (e.g.,
0.123) to ensure the final output reflects the12.3requirement. - If the source data is already in percentage format (e.g.,
12.3), simply use the formula above without multiplying by 100, ensuring the finalROUND(..., 1)satisfies the precision requirement.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.