excel-analysis
Techniques for statistical analysis in Excel including weighted means, percentiles, and rounding.
- License 许可
- MIT
- 最近更新
- 2026-10-02
- Stars
- ★ 92
- Forks
- 7
01 前言 Front Matter
- name
- excel-analysis
- description
- Techniques for statistical analysis in Excel including weighted means, percentiles, and rounding.
03 SKILL.md 正文
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).
04 同仓库更多 Skills
object_counter
Count occurrences of an object in the image using computer vision algorithm.
travel-planning-workflow
Invoke this skill when performing travel planning. It defines a structured workflow for generating itineraries. Following this workflow is essential to ensure the final plan satisfies user requirements.
bundled-dataset-search-tool
invoke this skill when you need to perform database search for travel planning. This skill provides some useful pre-packaged tools to look up accommodations, attractions, cities, driving distance, flights, and restaurants from the bundled dataset.
glm-output
Output-processing guidance for GLM tasks. Especially useful after glm-basics and glm-calibration when you need verifier-matching metrics from output.nc and a final /root/metrics.json.
glm-calibration
Calibration guidance for GLM tasks. Often most effective after glm-basics has clarified the setup; glm-output is the companion skill for exact final metric computation.
glm-basics
A good starting point for GLM calibration tasks. Use to inspect glm3.nml, confirm how GLM runs, and identify the relevant files before moving on to calibration and output evaluation.