Standard Deviation

[joetaxpayer]

I understand how to use STDEV to get Standard Deviation of a list of
numbers. Is there a way to do this from data which shows numbers and
their frequency?
e.g.

1.3 5
1.25 8
1.00 9

Above means the raw data had 5 occurances of 1.3 and 8 of 1.25.
It would be quite the chore to expand the list to get one number in each
cell. The data was created as a 'number of instances' for simplicity sake.
JOE

 

[Bernard Liengme]

If you numbers are in A1:A3 and their frequencies in B1:B3
use
=SQRT(SUMPRODUCT((B1:B3*((A1:A3-SUMPRODUCT(A1:A3,B1:B3)/SUM(B1:B3))^2)))/SUM(B1:B3,-1))

 

[joetaxpayer]

If you numbers are in A1:A3 and their frequencies in B1:B3
use
=SQRT(SUMPRODUCT((B1:B3*((A1:A3-SUMPRODUCT(A1:A3,B1:B3)/SUM(B1:B3))^2)))/SUM(B1:B3,-1))

I substitued my cells for yours and it worked like a charm. I appreciate
the quick reply.
JOE