Standard Deviation

  • Thread starter Thread starter joetaxpayer
  • Start date Start date
J

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
 
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))
 
Bernard said:
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))
Click to expand...

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