Standard Deviation

Samuel, there are a few ways you can accomplish this. One method is to calculate the mean and standard deviation from your table of frequencies and values.

The mean could be calculated as =SUMPRODUCT(frequency,value)/SUM(frequency)

where in your test worksheet, frequency would be the range J108:J112 and value would be K108:K112 and cell K123 would be

=SUMPRODUCT($J$108:$J$112,K108:K112)/SUM(K108:K112)

The standard deviation would be

=SQRT(SUMPRODUCT((value-mean)^2,frequency)/(N-1))

using (N-1) for sample standard deviation or just (N) for the population standard deviation where N=SUM(frequency) and mean is the value you calculated in cell K123.

In your file, cell K124 would be

=SQRT(SUMPRODUCT(($J$108:$J$112-K123)^2,K108:K112)/(SUM(K108:K112)))

To understand these formulas, you'll need to look up the mathematical formulas for mean and standard deviation and also look up how SUMPRODUCT works.