STDev - Standard Deviation
I would like to calcualte standard deviation for a field across 3 records. I would like to calculate based on the following:
FieldA - number
FieldB - Name
FieldC - Stdev for FieldA in found set. Found set is by FieldB.
Record 1 = FieldA = 10, FieldB = Sample1
Record 2 = FieldA = 12, FieldB = Sample1
Record 3 = FieldA = 14, FieldB = Sample1
STDev should be for 3 records found by Sample1.
Record 4 = FieldA = 10, FieldB = Sample2
Record 5 = FieldA = 12, FieldB = Sample2
Record 6 = FieldA = 14, FieldB = Sample2
STDev should be for 3 records found by Sample2.
I would like to get the Standard Deviation for FieldA across the 3 records based on FieldB data. Each set of records based on FieldB should have a STDev. How would I calculate this or create the appropriate fields?
Thank you in advance.