Average, spread and deviation of a set of fill weights.
Your figures
Keep units consistent: kg with kg, minutes with minutes. Results update as you type.
Average fill weight
—
Deviation from target
—
Deviation from target
—
Lowest
—
Highest
—
Standard deviation (sample)
—
Samples
—
Formula
Average = sum of sample weights ÷ number of samples; deviation = average − target
=AVERAGE(B2:B11)Excel: Sample weights: one per cell down column B
Save this calculation
Enter your figures (or try the worked example) to save them.
General calculation. Confirm your site's own definitions, validated limits and specifications before using a result for process control or product release.